Explain, in general terms, the relationships of the tables in the Cape Codd data

Question

Explain, in general terms, the relationships of the tables in the Cape Codd database schema that is shown in Figure 2-34:

FIGURE 2-34 The Cape Codd Database with the WAREHOUSE, INVENTORY, and CATALOG SKU 2013 Tables RETAIL ORDER OrderNumber ORDER ITEM 0 OrderNumber SKU StoreZIP Quantity Price The INVENTORY table OrderYear SKU DATA OrderTotal SKU Buyer INVENTORY WAREHOUSE | WarehouselD SKU SKU_Description QuantityOnHand 7 warehouse!D WarehouseCity WarehouseState Manager SquareFeet The WAREHOUSE table CATALOG SKU 2015 CATALOG SKU 2014 CatalogiD SKU SKU_Description Department CATALOG_SKU 2013 CatalogiD 9 CatalogID SKU SKU SKU Description DateOnWebSite DateOnWebSite DateOnWebSite

Explanation / Answer

Retail_order nad order_item has 1 to many relationship, as there can be multiple items in each individual order.
SKU_DATA table has 1 to many relation with Order_item table.
Similarly, SKU_DATA table has 1 to many relation with INVENTORY table.
Warehouse has a 1 to many relation with inventory table, since each inventory is places in a particular warehouse.
Other catalog tables are not related to each other.

Related Questions

Navigate

• Browse (All)
• Browse E
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.