Part A: Entity-Relationship Modelling 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. 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 line has several drivers. 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. Based on the given description, model the given business rules, and present your model as an Entity-Relationship(ER) diagram. Carefully state any assumptions that you make. In your ER diagram, you must properly denote all applicable concepts, including weak or strong entities, keys, composite or multi-valued attributes, relationships and their cardinality and participation constraints. If you cannot represent any of this information in the ER model, clearly explain what limitations in the ER model restrict you from representing your model. You must use UML notation and the diagramming tool Lucidchart to draw your diagram. Your diagram must be drawn to a high standard with minimal clutter. You are not required to map the ER model to relational model.A special note: Task 2: Optimize an Entity-Relationship Model Advanced Metro Trains Study Initial design of Metro Trains management database is now presented to users. After some detailed discussions, complete requirements for the database are finalised as follows (changes are in bold): 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. A station also has a number counting outwards from the city centre. A station may be on several train lines with the same number. For example, Happy Valley is the 2nd station on both the Lake Villa line and Eastwood line. Smallville is the 10th station on both the Eastwood line and Eastern Cross line Standard station facilities 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 line has several drivers. During peak hours (7:30am9:30am on workdays) premium stations have supervisors to provide customer service. A station has a supervisor, and a supervisor can manage at most one station. An employee may have a line manager, who is also an employee at Metro Trains. Start date of supervision should also be recorded. A station may have several platforms numbered from one. For example, Happy Valley has 8 platforms from No. 1 to No. 8. Smallville has 4 platforms from No. 1 to No. 4. Each line has inbound and outbound train runs that are numbered from one. For example, Eastern line has inbound run No. 1, outbound run No. 1, inbound No. 2, outbound No. 2 etc. Each train run is assigned a primary driver and an assistant driver. Each train run is also assigned a train. On each line, a train run is timetabled to depart a platform of a station at certain time. Express train runs do not stop at all stations on a line. Please modify / optimize your initial ER diagram from Task 1 to enforce the additional requirements specified above. A complete ER diagram (initial ER with amendments) should be presented. Carefully sate any assumptions that you make. In your ER diagram, you must properly denote all applicable concepts, including weak or stron entities, keys, composite or multi-value attributes, relationships and their cardinality and participation contraints. You must use UML notation and diagramming tool lucid chart to draw your diagram. Your diagram must be drawn to a high standard with minimal clutter. You are not required to map the ER model to a relational model.