Are the database tables given in CH07_SALECO (page 299) in THIRD NORMAL FORM ? I

Question

Are the database tables given in CH07_SALECO (page 299) in THIRD NORMAL FORM ?

I have trouble with normalization, can someone explain this and diagram this in detail correctly. it is extremely important it is correct.

PROVE THEM OR DISPROVE THEM.

The tables that are not in 3NF, explain in what NF they are, and moreover transform them into 3NF;

Draw the new ERD diagram after all the tables had been transformed into 3NF.

Still you must use the original tables given in CH07_saleCo database given in page 299.

Relational diagram CUSTOMER INVOICE INV NUMBER INV NUMBER LINE NUMBER CUS LNAME CUS CODE CUS FNAME NV DATE P CODE CUS INITIAL LINE UNITS CUS AREACODE LINE PRICE CUS PHONE CUS BALANCE Table name: CUSTOMER OTISLOODEI CUS NAME CUS NAME CUS NMAL as AREACODE CUS PHONE CUS EALANCE 10012 Smith Mathy W 65 894.2285 345.86 10013 Clowski Faul F 615 894-2180 56.75 10014 Orlando Myron 65 222-1672 0.00 10015 Brian Amy B 713 442-3381 0.00 10016 trown Nemes G 015 297-1220 221 19 10017 WMliams George 615 290-2556 7es.g3 10018 Ferriss Anne O 713 382-7185 216.55 10019 Smith oliette K 65 297-3809 000 Table name: INVOICE Table name: LINE INVINUMBER UNE NUMBER P CODE LINE UNITS ILINE PRICE INVINUMEER CUS CODE N DATE 1001 113-G2P2 1 14.99 1002 10011 16-Jan 14 1003 10012 16 Jan 14 1002 1154778-2 T 2 499 1004 10011 17Jan-14 1003 1 2238 1 3895 1005 10013 17-Jan 14 1003 21 546 1 3095 1006 10014 17-Jan-14 1003 313-02P2 s 14.99 1007 10015 17-Jan-14 1004 151778-21 3 499 1008 10011 17-Jan-14 1004 22 109 995 1005 1 PYC2 DRT 12 5.07 1006 SM-18277 3 699 100e 22232 TY 1 109.92 1006 489 WRE-Q 1 26.99 1007 1 13-02P2 2 14.99 1007 2507 1 499 1008 1 PVC23DRT 5 587 1000 2 3 119.95 PRODUCT VENDOR P coDE 8 v coDE P DESCRIPT V NAME P INDATE V CONTACT PLQOH V AREACODE P MIN V PHONE P PRICE V STATE P DISCOUNT V ORDER V CODE Table name: VENDOR CODE VNAME IV CONTACT AREACODE PHONE IV STATE ORDER 21226 SuperLoo, Inc. Frushing 904 215-8995 FL N 21231 D8E Supply 2567 Dome supply Smith 901 678-1419 GA N 24004 Brackman Bros. Browning 615 228-1410 TN N 24288 ORDVA, Inc. Hak ford 615 898-1234 TN Y 25443 B8K, Inc. Smith 904 227-0093 FL N 25501 Damal Suppies Smythe 25595 Rubicon systems Orton 904 456 0092 FL Y Table name: PRODUCT P_NDAT 00-Nov-13 8 s 10999 000 2s595 GERG1 Power painter, is p 3 nozzle savy bladc 13-Doc-13 32 15 S499 cos 21344 13-32 P2 72 in. 14 1A3 900 n saw blade 13-Nov-13 18 12 17 49 om 21344 1558.QM Hind cloth 12in.3s50 15. Jan-14 5 399 000 23119 2238OPC BBD cordess drill 12in 20-an-14 12 5 38 95 005 25595 2109-HE Clow nommer 20 Jan-14 2 10 99s C10 21225 IPvcz3DRT PVC Flipe, 35-n 8-t 20-Feb-14 1ao 75 58T 0,00 SM1B277 125 in. motal crown, 25 01 Mor-14 172 75 E00 00 21225

Explanation / Answer

I strongly feel the tables are already in 3NF as there are no transitive dependencies.

All the tables have information relevant to them and has foreign keys to refer to other tables. By doing this, the transitive dependencies are avoided and hence the table is in 3NF.

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

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