A Bus company has hired you to design their database Their initial requirements are: Business Information Systems Assignment, UOG, Ireland

A Bus company has hired you to design their database. Their initial requirements are:

The Company owns a number of busses.
Each bus is allocated to a particular route, although some routes may have several busses.
Each route passes through a number of towns.
One or more drivers are allocated to each stage of a mute, which corresponds to a journey through some or all of the towns on a route.
Some of the towns have a garage/depot where buses are kept.
Each of the buses are identified by the registration number and can carry different numbers of passengers since the vehicles vary in size and can be single or double-decked.
Each route is identified by a route number and information is available on the average number of passengers carried per day for each mute.
Drivers have an employee number, name, address, and sometimes a telephone number.

PART 2 Logical Design

The form below lists the student record information for a typical student at a third-level college. Describe and illustrate the normalization steps by converting the form below from the normalized Form (ONF) to the Third Normal Form (3NF).

Get Solution of this Assessment. Hire Experts to solve this assignment for you Before Deadline.

The post A Bus company has hired you to design their database Their initial requirements are: Business Information Systems Assignment, UOG, Ireland appeared first on QQI Assignments.

A Bus company has hired you to design their database Their initial requirements are: Business Information Systems Assignment, UOG, Ireland
Scroll to top
WhatsApp
Hello! Need help with your assignments? We are here