Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need help normalizing this table into 3NF and also explain how to put them into 3NF Phone InvoiceDate Price Total LastName FirstName Shire Shire
I need help normalizing this table into 3NF and also explain how to put them into 3NF
Phone InvoiceDate Price Total LastName FirstName Shire Shire Goodyear Katherine 206-524-3544 15-Dec-15 Dining Table Linens BancroftChris Griffith John Shire Tierney Doris Anderson Donnaa Goodyear Katherine 206-524-3544 15-Jan-16 Antique Chair Goodyear Katherine 206-524-3544 15-Jan-16 Antique Chair Tierney Doris Invoiceltem Tax Robert206-524-2433 14-Dec-15 Antique Desk Robert 206-524-2433 14-Dec-15 Antique Desk Chair 3000.00 249.00 3249.00 41.50541.50 83.00 1083.00 54.15 48.74 20.75270.75 62.25812.25 20.75270.75 1250.00 103.75 1353.75 1750.00 145.25 1895.25 29.05 379.05 500.00 1000.00 50.00 45.00 250.00 750.00 250.00 425-635-9788 15-Dec-15 Candles 206-524-465523-Dec-15lCandles 4.15 3.74 Robert 206-524-2433 5-Jan-16 Desk Lamp 425-635-8677 10-Jan-16Dining Table Linens 360-538-756612-Jan-16 Book Shelf 425-635-8677 25-Jan-16 Antique Candle Holders 350.00Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started