normalisation aol music web site data

View previous topic View next topic Go down

normalisation aol music web site data

Post  dadou on Tue Apr 21, 2009 1:38 pm

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)

dadou

Posts : 4
Join date : 2009-04-21

View user profile

Back to top Go down

Re: normalisation aol music web site data

Post  BoxesAndLines on Tue Apr 21, 2009 1:46 pm

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?
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

thanks

Post  dadou on Tue Apr 21, 2009 5:53 pm

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)

dadou

Posts : 4
Join date : 2009-04-21

View user profile

Back to top Go down

Re: normalisation aol music web site data

Post  BoxesAndLines on Tue Apr 21, 2009 6:10 pm

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.
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

hi

Post  dadou on Wed Apr 22, 2009 10:41 am

Thanks again .....

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

Thanks again

dadou

Posts : 4
Join date : 2009-04-21

View user profile

Back to top Go down

Re: normalisation aol music web site data

Post  BoxesAndLines on Wed Apr 22, 2009 11:17 am

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!
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

thanks

Post  dadou on Wed Apr 22, 2009 5:42 pm

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

dadou

Posts : 4
Join date : 2009-04-21

View user profile

Back to top Go down

Re: normalisation aol music web site data

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum