Posted: January 24th, 2023

W7 DATABASE EXERCISE \$NFO 321

Assignment Instructions

Don't use plagiarized sources. Get Your Custom Essay on
W7 DATABASE EXERCISE \$NFO 321
Just from \$13/Page

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 500+ words
Part 2 a) 10%
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) 2%
2. Is the above table in 2NF? 3%
3. Using the table and field names in the above table explain your answer in plain English. 5%
Part 2 b) 10%
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 each supplier for each type of part (the cost). This time, a supplier can provide us with many different types of parts, AND each part can be provided to us by more than one supplier. Each supplier may charge us a different amount for each part (cost). This requires a many-to-many relationship.

Functional analysis:
Part —- > Price
Supplier —- > Street, City, State, Zip, Telephone
Part, Supplier —- > Cost
Table:
Parts (Part, Price, Cost, Supplier, Street, City, State, Zip, Telephone)
Complete the following:
1. Copy and paste the 2NF definition from the Connolly text (see page 422) 2%
2. Is the above table in 2NF? 3%
3. Using the table and field names in the above table explain your answer in plain English. 5%
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 the material you reference, restrict your use of direct quotes (copy and paste) to less than 15% of the submission (the questions and the required copy and paste content will not be considered part of the 15% guideline).
Name your document Last Name_Assignment7 (i.e. Smith_Assignment7).
HINT: Review the One-to-Many and Many-to-Many Parts and Suppliers examples in the Terms and Concepts forum.
Contact the instructor with any questions.
The following rubric will be used:
Part 1
Synthesis of Concepts
Response to 17.5             40%
Non-text examples           15%
Part 2 a)                           10%
Part 2 b)                           10%
Using APA style/reference      5%
Writing Org/Clarity/Spelling   20%
(-1 per misspelled word)
Total                                 100%

Submission

Expert paper writers are just a few clicks away

Place an order in 3 easy steps. Takes less than 5 mins.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
\$0.00

Order your essay today and save 20% with the discount code Newyr