PLEASE HELP ME, THANK YOU

Assignment 2 ERD Diagramming Problem 1 You have been asked to design a database management system for a commuter rail system. Draw ER Diagram The customer has given you the following entities and attributes. Train Train No TypicalCrew Car Car No Manufacturer Capacity SeatTypes (there can be more than 1 of these) Purchase Date Manufacture Date YearsinService Engine Engine No Manufacturer Type Size Maintenance Intervals (there are more than 1 of these) Purchase Date Manufacture Date YearsInService Crew Crew MemberID Name StartDate Yearsofservice You have also been provided with some additional information: 6. A crew member may be assigned to more than 1 train in the same day. 1. A train must have at least one engine and one car. It may also have more than 1 engine and more than 1 car. 2. A train must have at least one crew member and may have many crew members. 3. Management would like to keep track of the dates that an engine, crew member and car are assigned to a train. 4. An engine may be assigned to 1 or more trains, but not on the same dates 5. A car may be assigned to 1 or more trains, but not on the same dates