INFO 321 American Military Modeling of Integrity Constraints University Essay

Assignment Instructions:
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

17.5 Describe the purpose of integrity constraints and identify the main types of integrity constraints on a logical data model.

Part 2) 20%
HINT: Review the Normalization Process: Parts and Suppliers One-to-Many Example in the Terms and Concepts forum.
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%

Second Normal Form (2NF)
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%

Your submission must be original, include supporting sentences using the terms, concepts, and theories with the page number or website from the required readings or other material. Your submission should paraphrase material you reference, restrict your use of direct quotes (copy and paste) to less than 15% of the submission (the required copy and paste content will not be considered part of the 15% guideline).