Wednesday, February 6, 2019

Scenario to ERD


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.



2 comments:

  1. Wonderful blog! I found it while surfing around on Yahoo News. Do you have any suggestions on how to get listed in Yahoo News? I’ve been trying for a while but I never seem to get there! Appreciate it.
    hop on hop off bratislava

    ReplyDelete
  2. Nice to read your article! I am looking forward to sharing your adventures and experiences. bratislava city tour

    ReplyDelete

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