Question: Can anyone help me to normalize a simple sql table please? Please see the pics attached. 1. Turn the music table into a normalized database.
1. Turn the music table into a normalized database. 2. Draw or outline the tables (in any way that works for your group) a. Indicate table names, primary key, foreign key b. Describe the relationships (i.e. one to one, one to many, many to many) c. Add fields as needed, feel free to expand on the table d. Final database should be 2nd form normalized, and will have m3 to 5 tables
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
