Examine the attached unnormalized table. Using the MySQL Workbench Data Modeler,

Question

Examine the attached unnormalized table. Using the MySQL Workbench Data Modeler, construct a diagram that shows the table in 3rd Normal Form.

Provide a summary of the steps you took to achieve 3rd Normal form. Include your rationale for new table creation, key selection and grouping of attributes.

Using MySQL Workbench Data Modeler, create a model showing the below table in 3rd Normal Form. Note that you only can model table and column names and data types. The data shown is for your reference to determine functional, partial, and transitive dependencies. Amount ProcedureName PetName InvoiceNumber InvoiceDate CustomerName CustomerAddress Chopper Boomer 987 Jan 13 2015 Mark Evans 987 Jan 13 2015 Mark Evans 123 This Street Orlando, FL 123 This Street Orlando, FL 30.00 Rabies Vaccination 24.00 Rabies Vaccination

Explanation / Answer

The following dependencies can be deciphered from the above database:

PetName --> InvoiceNumber
InvoiceNumber --> InvoiceDate, CustomerName
CustomerName --> CustomerAddress
PetName, ProcedureName--> Amount

3NF states that :

A database is in third normal form if it satisfies the following conditions:

Therefore, removing the transitive functional dependencies from these relations,
PetName --> InvoiceNumber
PetName --> InvoiceDate, CustomerName
CustomerName --> CustomerAddress
PetName, ProcedureName--> Amount

This makes the relation satisfy 3NF.

Related Questions

Navigate

• Browse (All)
• Browse E
• Subjects

---

---

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