Task:
OrangeTunes music downloading service has the below table for recordings (tracks) that they sell (with associated functional dependencies). What level of normalization is the table in? (the best level it is in). Explain Why. Produce a new design that is in 3NF, and show all of the records in the resulting tables.
|
Track# |
Year |
Title |
Artist |
Genre |
CD |
Company |
Price |
|
5 |
1975 |
Born to Run |
Springsteen |
Rock |
Born to Run |
Columbia |
0.79 |
|
10 |
1978 |
Badlands |
Springsteen |
Rock |
Darkness … |
Columbia |
0.79 |
|
15 |
1978 |
Promised Land |
Springsteen |
Rock |
Darkness … |
Columbia |
0.79 |
|
20 |
2003 |
Numb |
Linkin Park |
Modern Rock |
Meteora |
Warner |
1.19 |
|
25 |
2003 |
Breaking the Habit |
Linkin Park |
Modern Rock |
Meteora |
Warner |
1.19 |
|
30 |
1982 |
Hot in the City |
Billy Idol |
Pop Punk |
Billy Idol |
Chrysalis |
0.79 |
|
35 |
1982 |
White Wedding |
Billy Idol |
Pop Punk |
Billy Idol |
Chrysalis |
0.79 |
|
40 |
1986 |
Rebel Yell |
Billy Idol |
Pop Punk |
Rebel Yell |
EMI |
0.99 |
|
45 |
1997 |
The Impression … |
Mighty, Mighty … |
Ska |
Let's Face It |
Mercury |
0.79 |
|
50 |
1994 |
Pictures to Prove It |
Mighty, Mighty … |
Ska |
Question the … |
Mercury |
0.79 |
PK: Track#
Track#è Year
Track#è Title
Track#è Artist
Track#è Genre
Track#è CD
Track#è Company
Track#è Price
Artist è Genre
CD è Company