Owner Ownerid Companyname Lastname Firstname Address City State Zip Assignment 6 Transforming Data Models Into Databas 1 (41.92 KiB) Viewed 27 times
Owner Ownerid Companyname Lastname Firstname Address City State Zip Assignment 6 Transforming Data Models Into Databas 2 (43.36 KiB) Viewed 27 times
Owner Ownerid Companyname Lastname Firstname Address City State Zip Assignment 6 Transforming Data Models Into Databas 3 (38.89 KiB) Viewed 27 times
OWNER OwnerID CompanyName LastName FirstName Address City State ZIP Assignment 6 - Transforming Data Models INto Database Designs Phone Email BankName BankAccountNumber EQUIPMENT ItemID TabNumber ItemNumber ItemSerialNumber ItemMake ItemModel NumberOftems ItemCost BOAT Coast GuardRegNumber BoatName BoatMake BoatModel BoatType Length Beam NumberOfBerths CHARTER Charter D DepartureDate ReturnDate NumberinParty BoatCost EquipmentCost TotalCost LOG Charter D EntryNumber EntryDate EntryTime EntryLocation Weather DepartingFrom Sailing To SCHEDULED MAINTENANCE MaintenanceID Maintenanceltem RequiredDate ScheduledDate CompletedDate Cost CUSTOMER CustomerID LastName FirstName Address City State ZIP Phone Email CreditCardNumber
A Convert this data model to a database design. Specify tables, primary keys, and foreign keys. Using Figure 6-43 as a guide, specify column properties. Duplicate the following table as needed to complete database design. Example Table with Specifications Column Name Data Type ExampleID Name Integer Char(4) Key Primary Key Required Yes Yes Default Value None None Remarks Surrogate (1, 1)
D Document your minimum cardinality enforcement using referential integrity actions for required parents, if any, and the form in Figure 6-29(b) for required children, if any using following table. Add rows to table as needed. PARENT Relationship CHILD Referential Integrity Constraint Cascading Behavior ON UPDATE ON DELETE
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!