Question: Introduction-In order to complete this lab, we will be using the database created in Lab 2 to create a new, normalized, set of tables.

 Introduction-In order to complete this lab, we will be using the database  
created in Lab 2 to create a new, normalized, set of tables. 

Introduction-In order to complete this lab, we will be using the database created in Lab 2 to create a new, normalized, set of tables. The following is an ER Diagram showing the content of our music database, presently there is only one table: music basic song VARCHAR(40) arist VARCHAR(40) gerve VARCHAR(25) duration DECIMAL CLO release date DNT abun VARCHAR(45) The music database's ERD (Contains one table) In this lab we want our database to have the normalized version of the data in our music basic table. This will help reduce data redundancy and increase data integrity. At the end of this lab. you will end up with four new tables (five tables overall including the original music basic table). Our new tables will contain very similar data as we have seen in music basic. Your music database at the end of this lab should look like the following ER Diagram: albom YARD(4) artists FIS DUT T at VAROHARD INT song MOR(40) ged INT duration DECA (L) AROWRDS Instructions: You will need to interpret this diagram and complete the following steps to create our new tables and populate them with data. Hints: 1. You can use the CSV files located on Canvas to help you create the tables 2. All the tables have an ID column, sometimes referenced in a different table. This is the primary key-foreign key relationship. 3. If foreign key constraints exist, the order you create tables and import data matters. You might want to start with the artists table. 4. Include all screenshots in a single Word document with headers for each step. Part 1: Our new normalized database contains 4 tables. You will need to create the new tables using SQL statements and establish referential integrity between the appropriate tables.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

To complete the task in the handson lab M02 HandsOn Lab Constructing the Database youll need to perf... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!