Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals Of Quality Control And Improvement

Authors: Amitava Mitra

5th Edition

1119692334, 978-1119692331

More Books

Students also viewed these General Management questions

Question

For the simple linear regression model, prove that E (s2) = a d.

Answered: 1 week ago