TU257: A Bus company has hired you to design their database: Information Systems Assignment, UCC, Ireland
| University | University College Cork (UCC) |
| Subject | TU257: Information Systems |
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.
Are You Searching Answer of this Question? Request Ireland Writers to Write a plagiarism Free Copy for You.
Get Help By Expert
Ireland Assignments is the best essay writing service provider in Ireland. We offer affordable, professional, and reliable assignment writing services to students of all levels. Whether you are a first-year student or a Ph.D. candidate, we can help you with your assignments. We have a team of experienced and qualified writers who can provide you with high-quality essays, term papers, research papers, and dissertations. We understand the challenges that students face when it comes to university essay writing, and we are here to help you overcome them. Contact us today for a free consultation.
