2. Normalize each of the followingdatasets (i.e. remove the repeating fields and

Question

2. Normalize each of the followingdatasets (i.e. remove the repeating fields and place into aseparate table with a foreign key). Rewrite the field namesunder an appropriate name for each table. Also, underline the keyfield(s) in each table.

    i. CD-Database

           CD ID

           Title of CD

           Artist

           Year recorded

           Genre (rock, pop, hiphop, etc.)

           Year purchased

           Following fields repeat 1- n times

Track title

                       Track length

Explanation / Answer

Dear,    Here given example for a CD database. Afterperforming normalization, this given database is split into thefollowing relations. These relations will not have any repeatinggroups.    The relations with their primary and foreignkeys are as follows,     CD_INFO             ( CD ID, Title, Artist,year_recorded, Year_purchased, Genre_id, Track_ID)       Here, CD ID is the primarykey and Genre_id, Track_ID are foreign keys    GENRE_INFO      (Genre_ID, Genretype)       Here, Genre_ID is theprimay key     TRACK_INFO       (Track_ID,Track_Title, Track_Length)       Here Track_ID is theprimary key. " I hope this will help you "

Related Questions

Navigate

• Browse (All)
• Browse 2
• Subjects

---