Task 1: Designing an Entity-Relationship Model Metro Trains Study You are asked to design the train service management database for Metro Trains Corporation. Description of the miniworld is given below. e 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. e 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. e 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. e 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. e 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 line has several drivers. e During peak hours (7:30am9:30am on workdays) premium stations have supervisors to provide customer service. A premium station has a supervisor, and a supervisor can supervise at most one premium station