normalisation aol music web site data

[dadou]

Hi everyone

My name is sam a student from London south bank university

I need your help...................
i ve an assignement to do on normalisation, i basically need to find the attributes and entities of aol music web site and go trough the 3 normal form i ve done it and got some doubt about my answer all advise and correction are more than welcome.


Aol Music database Entities and attributes

First NF

Artist (Artist_ID, Album_ID)

Artist details (Artist_ID, Album_ID, Music_genre, Traks_names, Artist_photos, Artist_videos, latest_news, Live_Tiket, download)


Second NF

Artist (Artist_ID, Album_ID)

Artist details (Artist_ID, Album_ID, Music_genre, Traks_names, Album_released, Artist_photos, Artist_videos, latest_news, Live_Tiket)

Album (Album_ID, Artist_ID, Music_genre, Traks_names, Album_released, Download)


Third NF

Artist (Artist_ID, Album_ID)

Artist details (Artist_ID, Album_ID, Music_genre)

Album (Album_ID, Artist_ID, Music_genre, Traks_names, Album_released, Download)

Artist extra ( Artist_ID, Artist_video, Artist_photo, Latest_news, Live_tiket)

[BoxesAndLines]

Some questions to consider,
Why do I need album_id to identify an artist?
What does download have to do with an Album?
How do you store all of the tracks on an Album?

[dadou]

i was not sure, it is a bit hard to create a relationship just on a web site, i really considered your feedback, and removed the one you considered useless, it seems to sound better, but still not sure about my answer hope that other feedback will help me to finalise my answer
thanks again for your help ........

First NF

Artist (Artist_ID)
Artist details (Artist_ID, Album_ID, Music_genre, Artist_photos, Artist_videos, latest_news, Live_Tiket)


Second NF

Artist (Artist_ID)
Artist details (Artist_ID, Album_ID, Music_genre, Album_released, Artist_photos, Artist_videos, latest_news, Live_Tiket)
Album (Album_ID, Artist_ID, Music_genre, Traks_names, Album_released)

Third NF

Artist (Artist_ID)
Artist details (Artist_ID, Music_genre)
Album (Album_ID, Artist_ID, Music_genre, Album_released)
Artist extra ( Artist_ID, Artist_video, Artist_photo, Latest_news, Live_tiket)

[BoxesAndLines]

No attributes for an artist?
Artist extra has 3 more entities in it. Artist photo sounds like an attribute of artist.
Artist details can only store one row for a given artist as defined. Ditto for artist extra.

[dadou]

Thanks again .....

Could you please try to be a bit clearer, i do not really know where i need to make correction

Thanks again

[BoxesAndLines]

Not really. I could model the whole website out in 10 minutes, but then again, you wouldn't be any better off other than having your homework complete. There is a ton of information on normalizing data on the web with examples.

Good luck!

[dadou]

Thank you for everything, i really appreciated it i ll send you my mark

[Sponsored content]