The first 2 are store receipts, like in a drug store.Can you picture yourself ha

Question

The first 2 are store receipts, like in a drug store.Can you picture yourself having been in a store and buying these items? Should be a familiar experience - we do it all the time. Now how would the database for this look?

Now in the third tab is the "First Try" where we try to analyze these receipts from a database standpoint. Of course this is not fini,shed. We still to apply the 3 rules, NF1, NF2, and NF3 until we have a completely normalized database.

Now as before, the answer is given as the fourth tab Step 3, which results after you have applied the three steps.

Can you create 2 new tabs with the intermediate results - step 1 and step 2?

Hint: The unique key for the "First Try" tab is

"order #" and

"part no"

Do you know why?

Store Receipts

70.1

Receipt 2

First Try

Step 3

part no. part desc qty quot cost cost this item 103 toothpaste 2 4.5 9 250 toothbrush 9 1.5 13.5 222 mouthwash 3 9.5 28.5 301 powder 1 5.5 5.5 555 bandaids 4 3.4 13.6 19

70.1

Explanation / Answer

After Adding one more record for cutomer 1023 with Order # 1018 on 10/22/2014 for 2 mouthwash and 2 powder at standard prize, Tables will be updated as below

Order Table Customer Table order # order date cust # cust # cust name cust addr cust addr 1003 9/30/2014 1001 1001 Tom Thumb 101 Main St 1017 10/15/2014 1023 1023 Sarie Thumb 444 First St. 1018 10/22/2014 1023 Order-Part Table Part Table order # part # qty quot price part # part desc std price 1003 103 2 4.5 103 toothpaste 4.5 1003 250 9 1.5 250 toothbrush 1.75 1003 222 3 9.5 222 mouthwash 9.5 1003 301 1 5.5 301 powder 5.5 1003 555 4 3.4 555 bandaids 3.4 1017 103 2 4.5 1017 250 3 1.75 1018 222 2 9.5 1018 301 2 5.5

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

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