Assignment 9824LA4

Lab 5-2

1. The functional dependencies for the ProAudio relation:

c_id -> f_name, l_name, address, city, state, zip

item_id -> title, price

ord_no -> c_id, order_date

ord_no + item_id -> shipped

zip -> city, state

Original ProAudio relation:

Discussion 2

 

Determining functional dependencies for ProAudio database

You learned in Module 5 that normalization is a set of rules that ensures the proper design of a database. In theory, the higher the normal form, the stronger the design of the database.

Use the file for  Functional Dependencies  to answer the following questions:

Now that you are familiar with the mission statement and the entities and attributes the for ProAudio:

1. What are types of anomalies can occur when normalization has not taken place?

2. What types of anomalies could happen in the ProAudio relation in it's present normal form. Give 3 specific examples.

3. How can these be fixed/avoided?

Submission Format:

1. Define Anomalies- definitions in your own words- do not copy paste

· Anomalie 1

· Anomalie 2 

· Anomalie 3

2. Identify anomalies in ProAudio- Give 3 examples means that you list specific instances from ProAudio on insert, delete or update anomalies, describing each in the context of the ProAudio database.

· ProAudio Anomaly example 1

· ProAudio Anomaly example 2

· ProAudio Anomaly example 3

· Resolve ProAudio anomalies- citing the anomalies you described in the previous section- specifically say how to fix each one

· Fix 1

· Fix 2

· Fix 3

· Comment to at least 1 post from fellow students with responses that are at least 3 sentences in length each.