You have been asked to design a database management system for a commuter rail system. The entities and attributes for the database management system are provided by the customer as following:

Train

Train No

Typical Crew

Engine

Engine No

Manufacturer

Type

Maintenance Intervals (there are more than 1 size of these)

Purchase Date

Manufacture Date

Years In Service

Car

Car No

Manufacturer

Capacity

Seat Types (there can be more than 1 of these)

Purchase Date

Manufacture Date

Years In Service

Crew

Crew Member ID

Name

Start Date

Years Of Service

You have also been provided with some additional information:

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.