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
Get step-by-step solutions from verified subject matter experts
