Answer Happy

Choose a scenario as listed in Practice Exercise 1 - 3. (You maychoose a different scenario then the one you chose before or choosethe same scenario from previous exercises - I recommend choosingthe same scenario that you created the ERD for). Create thedatabase in the actual database application as indicated by yourprofessor (i.e Microsoft Access, MySQL or Oracle, etc.). You mustuse SQL commands to create the tables in the database (i.e CreateTable command). Submit the SQL commands with the completed databaseas part of the assignment. The tables should be populated withrecords from the scenario you chose.
CREATE DATABASE WITH USE MYSQL
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. OrderNum 21608 21610 21610 21613 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. 21614 21617 21617 21619 21523 Project Code PC010 PC010 PC010 PC011 PC011 PC011 PC012 Northern Virginia Community College Annandale Campus ITD 256 Advanced Database Management Practice Exercise 3 PC012 PC012 OrderDate 10/20/2010 PartNum AT94 10/20/2010 DR93 10/20/2010 DW11 10/21/2010 KL62 10/21/2010 10/23/2010 10/23/2010 KT03 BV06 CD52 DR93 10/23/2010 KV29 10/23/2010 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. Description Iron Gas Range Washer Dryer Dishwasher Home Gym Microwave Oven Gas Range Treadmill OR Manager Project Name Reservation Mr. Ajay System Reservation Mr. Ajay System Reservation Mr. Ajay System HR System HR System Mrs. Charu Mrs. Charu Mrs. Charu Attendance Mr. Rajesh HR System System Attendance Mr. Rajesh 710700 S218 System Attendance Mr. Rajesh System 120500 $102 Project Project Employee Employee Department Department Hourly Name No. Name Rate Budget No. 120500 S100 Database 21.00 120500 | S101 500500 $103 500500 $104 500500 $315 710700 S137 710700 S109 NumOrdered Mohan 11 1 1 4 2 2 4 1 2 D03 Vipul D02 Riyaz Vikas D01 Pavan D03 Jitendra D02 Pooja D01 Rahul D03 Avneesh D02 QuotedPrice $21.95 $495.00 $399.99 $329.95 D01 $595.00 $794.95 $150.00 $495.00 $1290.00 Testing IT Database Testing IT Database Testing IT 16.50 22.00 18.50 17.00 23.50 21.50 15.50 20.50 1| Page