Task 1 - Modeling Task 1.1 - ER Diagram: Deutsche Bahn (DB) wants to implement a new system for its long-distance train service. As you are our modeling specialist, your task is to model the requirements of our customer through an ER diagram. Use the notation for entity-relationship diagrams from the lecture. Weak entities and relationships, if any, should be double-bordered. Specify cardinalities for relationships in Chen notation (i.e., 1:N, 1:1, N:M) - Do not use the min-max-notation! To assess whether your cardinalities make sense, you should first read and understand the following description in its entirety. In case you need additional attributes, feel free to add them. Task: Create an entity-relationship diagram (ER diagram) and consider the following requirements: - Stops have a name and a place. Both information together uniquely identify a stop, e.g., -Main station, Dortmund". - Each two stops are a certain distance (km) apart. - A train has a unique serial number and a maximum speed (in km/h ). We distinguish between.,ICE" and .IC" trains. For ICE trains, we additionally stote the number of on-board restaurants. - A seat has a number and is located in a wagon, eg. ..Number 12, Wagon 2. It is uniquely identifiable by means of the two pieces of information and in combination with a train. - Trains conduct journeys. For joumeys, the line number as well as the scheduled start and end time are noted. A line number should of course be allowed to be used more than once. - We record not only which stop occurs on which journey, but also in what order. For example, the first stop is the start stop of a joumey. A stop can be visited more than once. - Customers have a unique identifier, a name, and an email address. - Customers can book tickets for journeys. A ticket always refers to exactly one joumey. It has a unique number, a total price, and can include multiple seats. - Of course, customers do not have to book a ticket for the entire joumey (e.g. from Dortmund to Munich). A ticket can also be booked for only part of a joumey, e.g. from Dusseldorf to Frankfurt. To realize this, we store from which stop to which stop a customer would like to travel with their ticket. - Seats can only be booked if they are free for the specified (partial) joumey