part 1:
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
17.5 Describe the purpose of integrity constraints and identify the main types of integrity constraints on a
logical data model.
part 2:
Background
We want to keep track of the price we charge for each type of part, the supplier for each type of part, and the
amount we pay the supplier for each type of part (the cost). Each supplier can provide us with many different
types of parts, but each part can be provided to us by only one supplier. This requires a one-to-many
relationship.
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%
   2NF definition from text:
   A relation that is in first normal form and every non-primary-key attribute is fully functionally dependent on the
   primary key.
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%