- What Are The Answers Can You Show The Work 1 (205.41 KiB) Viewed 34 times
What are the answers? Can you show the work?
-
answerhappygod
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
What are the answers? Can you show the work?
What are the answers? Can you show the work?
OWNER FIGURE 5-30 Data Model for San Juan Sailboat Charters OwnerID CompanyName LastName FirstName Address City State ZIP Phone EmailAddress BankName BankAccountNumber EQUIPMENT ItemIDTabNumber ItemNumber ItemSerialNumber A. Convert this data model to a database design. Specify tables, primary keys, and foreign keys. Using Figure 5-26 and Figure 5-28 as guides, specify column properties. ItemMake ItemModel NumberOfitems ItemCost B. Describe how you have represented weak entities, if any exist. C. Describe how you have represented supertype and subtype entities, if any exist. D. Create a visual representation of your database design as an IE Crow's Foot E-R dia- gram similar to the one in Figure 5-27. E. Document referential integrity constraint enforcement, using Figure 5-29 as a guide. BOAT Coast GuardRegNumber BoatName BoatMake BoatModel Boat Type Length Beam NumberOfBerths CHARTER CharterID DepartureDate ReturnDate NumberInParty BoatCost EquipmentCost TotalCost LOG CharterlD EntryNumber EntryDate Entry Time EntryLocation Weather DepartingFrom Sailing To SCHEDULED_MAINTENANCE MaintenancelD Maintenanceltem RequiredDate ScheduledDate CompletedDate Cost CUSTOMER CustomerID LastName FirstName Address City State ZIP Phone Email CreditCardNumber
OWNER FIGURE 5-30 Data Model for San Juan Sailboat Charters OwnerID CompanyName LastName FirstName Address City State ZIP Phone EmailAddress BankName BankAccountNumber EQUIPMENT ItemIDTabNumber ItemNumber ItemSerialNumber A. Convert this data model to a database design. Specify tables, primary keys, and foreign keys. Using Figure 5-26 and Figure 5-28 as guides, specify column properties. ItemMake ItemModel NumberOfitems ItemCost B. Describe how you have represented weak entities, if any exist. C. Describe how you have represented supertype and subtype entities, if any exist. D. Create a visual representation of your database design as an IE Crow's Foot E-R dia- gram similar to the one in Figure 5-27. E. Document referential integrity constraint enforcement, using Figure 5-29 as a guide. BOAT Coast GuardRegNumber BoatName BoatMake BoatModel Boat Type Length Beam NumberOfBerths CHARTER CharterID DepartureDate ReturnDate NumberInParty BoatCost EquipmentCost TotalCost LOG CharterlD EntryNumber EntryDate Entry Time EntryLocation Weather DepartingFrom Sailing To SCHEDULED_MAINTENANCE MaintenancelD Maintenanceltem RequiredDate ScheduledDate CompletedDate Cost CUSTOMER CustomerID LastName FirstName Address City State ZIP Phone Email CreditCardNumber