I need help converting this ERD to Third Normal Form (3NF) Here is what I have s

Question

I need help converting this ERD to Third Normal Form (3NF)

Here is what I have so far:

Staff(StaffID, Certification)

Appointment(AppointmentID, StaffID(FK)

Customer(CustomerID, StaffID (FK)

Ticket(Ticket ID, CustomerID)

Purchase(PurchaseID)

Payment(Ticket ID, Payment Type)

Service(SPurchaseID, Description)

Product(PPurchaseID, Price)

Staff Appointment Customer Staff ID Certification) Position Salary Hire Date Service) Appointment Date Appointment Time Requested Staff Name Services generated by Contact Info (Address, Home Phone Cell Phone, Email) Memeber Contact Info Address, Home Phone, Cell Phone, Email) Ticket Ticket ID Product Date/Time Staff Amount Customer ID generates Purchase Purchase ID ategor describes Product Payment Service PPurchaselD Description Price Ticket ID describ Description Payment Type (Cash, Credit) Price

Explanation / Answer

STAFF(STAFFID, CERTIFICATION, POSITION, SALARY, HIREDATE, CONTACT INFO)

CUSTOMER(CUSTOMERID, CUSTOMERNAME,CONTACTINFO)

APPOINTMENT(APPOINTMENTID, APPDATE, APPTIME, CUSTOMERNAME)

TICKET(TICKETID, CUSTOMERID, DATE/TIME, AMOUNT)

PURCHASE(PURCHASEID)

PRODUCT(PRODUCTID, PURCHASEID, DESCRIPTION, PRICE)

SERVICE(SPURCHASEID, DESCRIPTION, PRICE)

PAYMENT(TICKETID, PAYMENTTYPE)

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

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