4.8 Create relational tables that solve the update, insert, and delete anomalies

Question

4.8 Create relational tables that solve the update, insert, and delete anomalies in Table 4-17 TABLE 4-17 Invoice Table ORDER DATE CUSTOMER INVOICE # DATE 6-19-2018 5-25-2018 6-19-2018 5-25-2018 6-19-2018 5-25-2018 6-19-2018 5-25-2018 6-20-2018 6-01-2018 6-20-2018 6-01-2018 6-20-2018 6-01-2018 CUSTOMER ID NAME ITEM # DESCRIPTION QUANTITY 52 52 52 52 57 57 57 201 201 201 201 305 305 305 Johnson Johnson Johnson Johnson Henry Henry Henry 103 Trek 9000 122 Nimbus 4000 10 Izzod 3000 71 LD Trainer 535 TR Standard 12 18 15 115 NT 2000 122 Nimbus 4000

Explanation / Answer

Solution

Part 1 Invoice Table

Part 2 Invoice Inventory Table

Part 3 Customer Table

Part 4 Item Table

Invoice (Primary Key) Date Order Date Customer ID (Foreign Key) 52 06-19-2018 05-25-2018 201 57 06-20-2018 06-01-2018 305

Related Questions

Navigate

• Browse (All)
• Browse 4
• Subjects

---

---

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