Discussion: Purpose of integrity constraints

Discussion: Purpose of integrity constraints

Discussion: Purpose of integrity constraints

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 only by 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)

Complete the following:

1. Copy and paste the 2NF definition from the Connolly text (see page 422) (Completed)

“Second Normal Form (2NF) is 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?

3. Using the table and field names in the above table, explain your answer in plain English.

Your submission must be original, including supporting sentences using the terms, concepts, and theories with the page number and 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).

You must proofread your paper. But do not strictly rely on your computer’s spell-checker and grammar-checker; failure to do so indicates a lack of effort on your part and you can expect your grade to suffer accordingly. Papers with numerous misspelled words and grammatical mistakes will be penalized. Read over your paper – in silence and then aloud – before handing it in and make corrections as necessary. Often it is advantageous to have a friend proofread your paper for obvious errors. Handwritten corrections are preferable to uncorrected mistakes.

Use a standard 10 to 12 point (10 to 12 characters per inch) typeface. Smaller or compressed type and papers with small margins or single-spacing are hard to read. It is better to let your essay run over the recommended number of pages than to try to compress it into fewer pages.

Likewise, large type, large margins, large indentations, triple-spacing, increased leading (space between lines), increased kerning (space between letters), and any other such attempts at “padding” to increase the length of a paper are unacceptable, wasteful of trees, and will not fool your professor.

The paper must be neatly formatted, double-spaced with a one-inch margin on the top, bottom, and sides of each page. When submitting hard copy, be sure to use white paper and print out using dark ink. If it is hard to read your essay, it will also be hard to follow your argument.