Convert this data model to a database design. Specify tables, primary keys, and foreign keys.

Create 4 tables and associated fields. (Normalize into 4 tables)

Relate (join) the 4 tables together adding appropriate foreign key fields as necessary.

RULE: Only like fields can be related. Example BOAT.CoastGuardRegNumber (primary key in BOAT) to CHARTER.CoastGuardRegNumber (foreign key in CHARTER)

OWNER OwnerlD CompanyName LastName FirstName Address City State ZIP Phone EmailAddress BankName BankAccountNumber BOAT CoastGuardRegNumber BoatName BoatMake SCHEDULED MAINTENANCE MaintenancelD Maintenanceltem JOo-BoatModel O RequiredDate Boat Type Length Beam NumberOfBerths ScheduledDate CompletedDate Cost EQUIPMENT temiDTabNumber temNumber ItemSerialNumber tem Make temModel NumberOfltems temCost CHARTER CUSTOMER CharterlD DepartureDate ReturnDate NumberinParty CustomerlD LastName FirstName Address BoatCost City State ZIP Phone Email CreditCardNumber EquipmentCost TotalCost LoG CharterID EntryNumber EntryDate EntryTime EntryLocation Weather DepartingFrom SailingTo OWNER OwnerlD CompanyName LastName FirstName Address City State ZIP Phone EmailAddress BankName BankAccountNumber BOAT CoastGuardRegNumber BoatName BoatMake SCHEDULED MAINTENANCE MaintenancelD Maintenanceltem JOo-BoatModel O RequiredDate Boat Type Length Beam NumberOfBerths ScheduledDate CompletedDate Cost EQUIPMENT temiDTabNumber temNumber ItemSerialNumber tem Make temModel NumberOfltems temCost CHARTER CUSTOMER CharterlD DepartureDate ReturnDate NumberinParty CustomerlD LastName FirstName Address BoatCost City State ZIP Phone Email CreditCardNumber EquipmentCost TotalCost LoG CharterID EntryNumber EntryDate EntryTime EntryLocation Weather DepartingFrom SailingTo