Normalization Implementation As in the ‘In-Class Exercise 7-6 Normalization DDL,’ this homework is to complete the normalization process using problems in Homework 3-1 and Homework 6-1. Similiarly, a SQL file has been created with data from the ‘Homework 3-1.’ The ER diagrams in the ‘Homework 6-1’ are provided as guides to create new tables. Download both ‘Chapter7—DDL–Normalization.mdf’ and ‘Chapter7—DDL–Normalization_log.ldf’ files to your USB drive and attach the .mdf file. For each of the following problems, 1. Use DDL to create the tables as shown in the ER diagram. Copy the DDL codes to a Word document and include a screenshot of the tables created in SQL Object Explorer. 2. Use bulk insert DDL to insert records from the original table (the name is in the top row of the data table) into the normalized tables. DO NOT insert one record at a time using the data in the tables below. These tables are only for your reference. In the real world, it’s very unlikely that you would enter records one at a time. Be sure to insert data into the columns in the correct order. Copy the DDL codes to the Word document.
The post Normalization Implementation appeared first on My Assignment Online.