Using MySQL Workbench Data Modeler, create a model showing the below table in 3r

Question

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 Boome 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

For the given data mysql code is as follows:

functional dependencies                  

InvoiceNumber -> InvoiceDate,CustomerName

CustomerName -> CustomerAddress,PetName

PetName,ProcedureName -> Amount

Tables in 3NF

Invoice(InvoiceNumber , InvoiceDate,CustomerName)

Customer(CustomerName , CustomerAddress,PetName)

Procedure(PetName,ProcedureName , Amount)

underlined are primary keys and italicized are foreign keys

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

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