A
bus company wants to keep track of its bus routes and schedules. Design an ER
diagram for the database according to the following description. Identify all
constraints and keys: Each
bus route has a route number, a departure station and a destination station. For
each bus route, there is a schedule, which records the departure times of
buses. For
each departure time of each route, a driver and a bus can be assigned (however
this is not necessary - information about the driver or the bus may sometimes
be missing). A
driver has an employee Id, a name and a phone number. A
bus is identified by its license number. The database also records the seating
capacity of each bus.
Subscribe to:
Post Comments (Atom)
How to Write Summary of a Research Paper
Paper Summary should contain the following points: What problem author’s solved? What are the motivations for that problem? Why is it import...
-
org 100h .data msg1 db 'capital$' msg2 db 'digital$' msg3 db 'others$' .code main proc ;input mov ah, ...
-
UPS prides itself on having up-to-date information on the processing and current location of each shipped item. To do this, UPS relies on...
-
A Bus Company owns a number of busses. Each bus is allocated to a particular route, although some routes may have several busses. Each ...
No comments:
Post a Comment