Topic Module 3 Discussion 4 x DITD256 Online Exercise3(3).pdf × -photoshop-NV280ITE 170E05 XO (110) Third Normal Form 3 NF × DITD256 Online Exercise3(3) pdf + C File | C:/Users/Hestia/Pictures/Screenshots/ITE%201 70/ITD256-Online-Exercise3(3).pdf Apps M VUDU My Mo es ๏ hbo O u bir T Browse TED Talks a Amazoncom Thank D favo te shit -Nirvana Massage C D Important Docs. 401k rahoo! ASL . Am encan S. D Astrolabe Free Char. D Astrolabe Free Char. D Astrology Answers D Harem Pants D Thai Massage Vide. D Victor 's Secret An D Go D Spanish Other bookmarks ITD256 Online_Exercise3(3).pdf 1/2 Northern Virginia Community College Annandale Campus ITD 256 Advanced Database Management Normalization Choose one of the below scenarios (can be the same or different scenario then the one you chose for previous exercises), treat the table in the scenario you chose as 1NF (first normal form) and use the normalization technique to produce the 3NF (third normal form) of the data. You may submit a Microsoft Word document as the deliverable for this assignment. Make sure to submit the work by the due date as indicated by your professor Scenario 1: This is a simple list table of a company trying to keep track of parts that they sell and orders that came in purchasing those parts (in other words, not a database but a flat one table file). You will design a database for this company so that they won't be relying on a simple 1 table list system to keep track of their data. Looking at the table below, produce the 3NF of the data PartNum Description OrderNum 21608 21610 21610 21613 21614 21617 21617 21619 21523 OrderDate 10/20/2010 AT94 10/20/2010 DR93 10/20/2010 DW11 10/21/2010 KL62 10/21/2010 10/23/2010 BV06 10/23/2010 CD52 10/23/2010 DR93 10/23/2010 NumOrdered QuotedPrice $21.95 495.00 399.99 $329.95 $595.00 $794.95 150.00 $495.00 Iron Gas Range Washer 4 KTO3 Dishwasher Home Gym Microwave Oven 4 Gas Range Treadmill KV29 1290.00 OR Scenario 2: This is a simple list table of a company trying to keep track of employee assignment to company projects (in other words, not a database but a flat one table file). You will design a database for this company so that they won't be relying on a simple 1 table list system to keep track of their data. Looking at the table below, produce the 3NF of the data 3nf pdf selection-tools-bas...z.p Show all | × ^ UPg ITD256-Online-Exe Photoshop Lesson layers-basics.zip 8:58 AM Type here to search 3/22/2019