Part 2: Module Practice: You have been given a file that contains the following fields relating to CD information. Using the...

profilebtaoya

Part 2: Module Practice:

You have been given a file that contains the following fields relating to CD information. Using the steps of normalization, create a logical data model that represents this file in third normal form. The fields include the following:

   Musical group name

   Musicians in group

   Date group was formed

   Group’s agent

   CD title 1

   CD title 2

   CD title 3

   CD 1 length

   CD 2 length

   CD 3 length

The assumptions are as follows:

   Musicians in group contains a list of the members of the people in the musical group.

Musical groups can have more than one CD, so both group name and CD title are needed to uniquely identify a particular CD.

    • 9 years ago
    • 999999.99
    Answer(0)
    Bids(0)