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).