You have been given a file that contains fields relating to CD information. Using the steps of

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


Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Systems analysis and design

ISBN: ?978-1118808177

5th edition

Authors: Alan Dennis, Barbara Haley Wixom, Roberta m. Roth

Question Posted: