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 987 Jan 13 2015 Mark Evans 987 Jan 13 2015 Mark Evans 123 This Street Orlando, FL 123 This Street Orlando, FL$24.00 Rabies Vaccination 30.00 Rabies Vaccination Boomer

Explanation / Answer

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.