Topic: Week 7 database

Part 1) 55%

Complete Review Question 17.5 on page 509 in the Connolly text; explain each constraint (40%) and provide an example of each constraint other than the one in the text (15%). The response should be in the order of 500+ words

Part 2) 20%

Review the Normalization Process: Parts and Suppliers One-to-Many Example in the Terms and Concepts discussion.

Functional analysis:

Part —- > Price, Cost, Supplier, Street, City, State, Zip, Telephone

Supplier —- > Street, City, State, Zip, Telephone

Part —- > Price, Cost, Supplier

Table:

Parts (Part, Price, Cost, Supplier, Street, City, State, Zip, Telephone)

Compete the following:

1. Copy and paste the 2NF definition from the Connolly text (see page 422) 4%
2. Is the above table in 2NF? 6%
3. Using the table and field names in the above table explain your answer in plain English. 10%