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.
2. Is the above table in 2NF?
3. Using the table and field names in the above table explain your answer in plain English. 10%
