TU257: A Bus Company Has Hired You To Design Their Database: Information Systems Assignment, UCC, Ireland

Business Requirements

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 route, which corresponds to a journey through some or all of the towns on a mute.
  • Some of the towns have a garage/depot where busses are kept.
  • Each of the busses 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 route.
  • Drivers have an employee number, name, address, and sometimes a telephone number.

No Comment.