Part 1)
Identify 4 database constraints (examples can include: Not NULL, primary key, unique, domain; there can be different ones as well). 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)
HINT: Review the Normalization Process: Parts and Suppliers One-to-Many Example
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. Include a definition of 2 normal form
2. Is the above table in 2NF?
3. Using the table and field names in the above table explain your answer.
Assignment Guidelines
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).
