Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Metro Trains Study You are asked to design the train service management database for Metro Trains Corporation. Description of the miniworld is given below. There
Metro Trains Study You are asked to design the train service management database for Metro Trains Corporation. Description of the miniworld is given below. There are several train lines from the city centre to suburbs. Each line has a unique name and is also described by the distance between the city centre and the terminus station. For example, the Lake Villa line runs from the city centre to Lake Villa and has a distance of 30 kilometres. Each station has a unique name, a contact phone number. A station is on at least one train line and some stations are on several train lines. Standard facilities of stations include vending machines, newspaper machines, and ticket machines. Each machine has a unique facility number. Some premium stations have such facilities. Trains are identified by unique train Nos. Other information about trains includes passenger capacity, model, manufacturer and year-made. A train line has several trains and a train is assigned to one line if not under maintenance. Employees of Metro Trains are described by unique employee Nos, and the first name, last name, and birth date. Drivers are assigned to work on several train lines, and a
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started