Create a logical data model that represents the file

Assignment Help Computer Engineering

Reference no: EM131164355

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.

Reference no: EM131164355

Questions Cloud

Effectiveness of the new program determined : How could company policies or operating procedures harmonize with the new program. How was the effectiveness of the new program determined. How were rewards or incentives used to promote the new program.

What types of files would be needed : Visit a commercial Web site (e.g., CDnow, Amazon. com). If files were being used to store the data supporting the application, what types of files would be needed? What data would they contain?

What toyota obtains from its production system : What other benefits do you think Toyota obtains from its production system? Think in broader terms than just production, and consider financial, marketing, and human resource management issues

In what companies has the dbms been implemented : In what companies has the database management system (DBMS) been implemented, and for what purposes? According to the information that you found, what are three strengths and weaknesses of the product?

Create a logical data model that represents the file : 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.

Create a logical data model : Create a logical data model. (You may have done this already in Chapter 7.) Apply the rules of normalization to the model to check the model for processing efficiency.

Extent of the liabilities of partners : What is the extent of the liabilities of partners in a general partnership? How does the limited partnership differ from the general partnership? What actions, if any, should the partnership take during any "winding up" period?

How you would denormalize the model that you created : Describe how you would denormalize the model that you created in question E. Draw the new physical model on the basis of your suggested changes. How would performance be affected by your suggestions?

Examine the physical data model that you created : Examine the physical data model that you created in question F. Develop a clustering and indexing strategy for this model. Describe how your strategy will improve the performance of the database.

User Account

All Pages