DATABASE SQL QUESTION ON NORMALIZATION: Q. determine the UNF and the 1NF and han

Question

DATABASE SQL QUESTION ON NORMALIZATION:

Q.determine the UNF and the 1NF and hand in this

UNF:

1NF:

***WRITE THE EXACT ANSWERS ONLY (I DO NOT NEED NOTES THAT HOW TO DO IT, I POSTED THIS QUESTION PREVIOUSLY BUT PEOPLE ARE WRITING NOTES FROM GOOGLE THAT HOW TO DO IT! )

Here is an example of a user view. This reports lists the customers of the Premiere Corporation. Premiere Corporation Customer List City Cust. Name Street State Zip Sales Code Rep No 124 Sa ll Adams 482 Oak Lansing MI 49224 03 49219 256 Samuel 215 Pete Grant MI MI 49034 12 311 Don Charl 48 Coll Ira e3 315 Tom Daniel 914 Cherry Kent MI 48391 06 MI 49219 12 40 Al Williams 519 W Grant at SO Lansing MI 49224 03 412 Sa Adams 16 Elm 522 Mary Nelson 108 Pine Ada MI 49441 12

Explanation / Answer

Unnormalised kind

The first step to standardization is to:

Gather all the attributes, and place them into an inventory (not continuation the attributes)
Identify the first Key(Unique field) ANd represent it with an underline
Indent the continuation teams
Name the relation

First traditional kind

Remove the continuation teams to a replacement entity
Identify the new primary key for the new entity
Add during a foreign key to make a relationship between the 2 tables

Second traditional kind

cross-check tables with a composite key
Review every non-key attribute to spot whether or not the attribute depends on a part of the key or all of the key
take away any partial key and dependants to a replacement table

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.