How do I normalize these tables into 3NF form? Purchaseltern Phone 206-325-7866
ID: 3733295 • Letter: H
Question
How do I normalize these tables into 3NF form?
Purchaseltern Phone 206-325-7866 206-325-7866 206-325-7866 206-325.7866 206-3256755 206.325.6755 206-325.8077 206-325-8977 206-325.6755 206-325-6755 425-7464322 425-746-5433 425-746.5433 206-325-9089 206-325-9088 Antique Desk Antique Desk Antique Candle Holders Antiquo Candlo Holdors Dining Tablo Linons 1,800.00 1,750.00 210.00 7-Nov-13 European Specialties Agure 3-33 7-Nov-13European Specialties Sample Sales Data for The Queen Anne Curiosity Shop 7-Nov-13 European Spacialties LastName FirstName 7-Nov 13 Europoan Spocialtios 14-Nov-13 Linons and Things 14-Nov-13 Linons and Things 4 Nov-13 Lamps and Lighting 14-Nov-13 Lamps and Lighting 21-Nov-13 Linens and Things 21-Nov-13 Linens and Things 21-Nov-13 Harrison, Denise 28-Nov-13 Loo, Andron 28 Nov-13 Loe, Andraw 28-Nov-13 Naw York Brokerage 28-Nov-13 NewYork Brokerage 206-524-2433 14-Dec-13 Antique Desk 3,000.00 249.00 3,249.00 541.50 Goodyoar Kathorine 206-524-3544 15.Doc-13 Dining Table Linans1,000.00 83.00 1,083.00 206-524-2433 14-Dec-13 Antique Desk Chair 500.0041.50 Desk Lamp 150.00 50.00 4.15 54.15 425-635-0788 15-Dec-13 Candles 206-5244655 23-Dec-13 Candles 206-524-2433 5-Jan-14Desk Lamp 425-635-8677 10-Jan-14 Dining Table Linens 45.00 3.74 Dining Table Linens 250.0020.75 270.75 750.00 62.25912.25 Book Shelf 150.00 7566 12-Jan-14 |Book Shef 250.00 20.75 Goodyoar Kathorino 206-524-3544 15 Jan 14 Antiquo Chair 1,250.00103.751,353.75 ,750.00 145.251,895.25 425-635-8677 25-Jan-14 Antique Candle Holders 350.00 29.05 379.05 Antique Desk Chalr Kathorine 206.524-354415-Jan-14 Antique Chair Antique Chair 1,050.00Explanation / Answer
3NF
Use Surrogate key as unique identifier which is not derived from application data.
Functional dependencies as per data :
VendorID ->Vendor , Phone
PurchaseID -> PurchaseItem,PurchasePrice,PurchaseDate
InvoiceID -> InvoiceItem, InvoiceDate,Price,Tax,Total
CustomerID ->Lastname,FirstName,Phone
where VendorID,PurchaseID,InvoiceID,CustomerID are surrogate keys.
Table in 3NF
VENDOR(VendorID , Vendor , Phone)
PURCHASE(PurchaseID, PurchaseItem,PurchasePrice,PurchaseDate)
INVOICE(InvoiceID, InvoiceItem, InvoiceDate,Price,Tax,Total)
CUSTOMER(CustomerID ,LastName,FirstName,Phone)
underlined attributes are primary keys
Do ask if any query. Please upvote if the answer is helpful.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.