Databases MySQL Diagram Question: This is what I have so far but I don't know if it's correct thanks in advance!

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