Case Study:

A Country bus company owns a number of buses. Each bus is allocated a particular route, although some routes may have several buses. Each route passes through a number of towns. One or more drivers are allocated to each stages of route, which corresponds to a journey through some or all of the towns on a route. Some of the towns have garage where buses are kept and each of the buses are identified by the registration number and can carry different number 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 average number of passengers carried per day for each route. Drivers have an employee number, name, address and sometimes a telephone number.

 

 

Mapping:

·        Bus (bus-no, no of pass, garage-name)

·        Route (route-no, area)

·        Allocated by (bus-no, Route-no)

·        Driver (Driver ID, Name, phone no, stage no)

·        Town (town name, state, garage name)

·        Garage (Garage name, address, bus no)

·        Stage (Stage no, route no)

·        Pass through (town name, stage no)