You have been given a file that contains fields relating to CD information. Usin

Question

You have been given a file that contains 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.

Explanation / Answer

You have been given a file that contains fields relating to CD information. Usin

Related Questions

Navigate

• Browse (All)
• Browse Y
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.