Question: Create an ER diagram and show any function dependencies to represent the following: You are responsible for designing a Railway Management System. This system contains

Create an ER diagram and show any function dependencies to represent the following: You are responsible for designing a Railway Management System.

This system contains stops, routes, trains and schedules. Each of these components have unique semantics and these semantics are described below:

1) Stops

a) Each stop must have a unique name

2) Routes

a) Each route must have a unique name

b) Each route can contain arbitrary amounts of stops

c) The order of the stops is not important

3) Trains

a) Each train must have a unique name

4) Schedules

a) Schedules must contain a route, a main train and time i) Ex: (Route: DT2, Train: Barbaros Train, Time: 13:30)

b) Schedules can also have an arbitrary amount of backup trains if something happens to the main train

Make sure to also include the type of relationship eg. 1 to many, many to many, many to one

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!