Convert this data model to a database design. Specify the tables, primary keys,
ID: 3670294 • Letter: C
Question
Convert this data model to a database design. Specify the tables, primary keys, foreign keys, and column properties.
293 CHA Transforming Data Models into Database Designs PTER 6 SCHEDULED MAINTENANCE OWNER BOAT MaintenancelD CoastGuardRegNumber BoatName BoatMake BoatModel OwnerlD CompanyName LastName FirstName Address City State ZIP Phone Maintenanceltem RequiredDate ScheduledDate CompletedDate Cost IH- BoatType Length Beamn NumberOfBerths Email BankName BankAccountNumber CUSTOMER CHARTER EQUIPMENT CustomerID CharterID ItemIDTabNumber ItemNumber ItemSerialNumber ItemMake ItemModel NumberOfltems ItemCost DepartureDate ReturnDate NumberlnParty BoatCost EquipmentCost TotalCost LastName FirstName Address City State ZIP Phone Email CreditCardNumber LOG CharterlD EntryNumber GURE 6-45 ta Model for San Juan ilboat Charters EntryDate EntryTime EntryLocation Weatheir DepartingFrom SailingTcoExplanation / Answer
OWNER
OWNERID {PK}
COMPANYNAME {PK}
LASTNAME VARCHAR2(20)
FIRSTNAME VARCHAR2(20)
ADDRESS VARCHAR2(20)
CITY VARCHAR2(20)
STATE VARCHAR2(20)
ZIP NUMBER(5)
PHONE NUMBER(10)
EMAIL VARCHAR2(20)
BANKNAME VARCHAR2(20)
BANKACCOUNT NUMBER NUMBER(20) {PK}
BOAT
COASTGUARDREGNUMBER NUMBER(5) {PK}
BOATNAME VARCHAR2(20)
BOATMAKE VARCHAR2(20)
BOATMODEL VARCHAR2(20)
BOATTYPE VARCHAR2(20)
LENGTH NUMBER(5)
BEAM NUMBER(5)
NUMBEROFBERTHS NUMBER(5)
SCHEDULED_MAINTAINANCE
MAINTAINANCEID VARCHAR2(20) {PK}
MAINTAINANCEITEMM VARCHAR2(20)
SCHEDULEDDATE DATE
COMPLETEDDATE DATE
COST DECIMAL(10,2)
EQUIPMENT
ITEMIDTABNUMBER {PK}
ITEMNUMBER{PK}
ITEMSERIALNUMBER NUMBER(5)
ITEMMAKE VARCHAR2(20)
ITEMMODEL VARCHAR2(20)
NUMBEROFITEMS NUMBER(5)
ITEMCOST DECIMAL(10,2)
CHARTER
CHARTERID VARCHAR2(20) {PK}
DEPARTUREDATE DATE
RETURNDATE DATE
NUMBERINPARTY NUMBER(5)
BOATCOST DECIMAL(10,2)
EQUIPMENTCOST DECIMAL(10,2)
TOTALCOST DECIMAL(10,2)
CUSTOMER
CUSTOMERID VARCHAR2(20) {PK}
LASTNAME VARCHAR2(20)
FIRSTNAME VARCHAR2(20)
ADDRESS VARCHAR2(50)
CITY VARCHAR2(20)
STATE VARCHAR2(20)
ZIP NUMBER(5)
PHONE NUMBER(10)
EMAIL VARCHAR2(20)
CREDITCARDNUMBER NUMBER(16)
LOG
CHARTERID VARCHAR2(20) {PK}
ENTRYNUMBER NUMBER(5)
ENTRYDATE DATE
ENTRYTIME DATETIME
ENTRYLOCATION VARCHAR2(20)
WEATHER VARCHAR2(20)
DEPARTINGFROM VARCHAR2(20)
SAILINTO VARCHAR2(20)