Open SaiYwutKhay opened 1 year ago
erDiagram Category { Category_ID Category_Name } Car { Car_ID Category_ID Car_Name Car_Model Color_ID } Color { Color_ID Color_Name } Customer { Customer_ID First_Name Last_Name Contact_Info Address } Staff { Staff_ID First_Name Last_Name Hire_Date Position } Sale_Record { Sale_ID Car_ID Customer_ID Staff_ID Sale_Date Sale_Price } Category ||--o{ Car : "Category_ID" Car ||--|{ Sale_Record : "Car_ID" Car ||--|{ Color : "Color_ID" Customer ||--|{ Sale_Record : "Customer_ID" Staff ||--|{ Sale_Record : "Staff_ID"
Assuming this is a prompt bug, marking it as such
erDiagram Category { Category_ID Category_Name } Car { Car_ID Category_ID Car_Name Car_Model Color_ID } Color { Color_ID Color_Name } Customer { Customer_ID First_Name Last_Name Contact_Info Address } Staff { Staff_ID First_Name Last_Name Hire_Date Position } Sale_Record { Sale_ID Car_ID Customer_ID Staff_ID Sale_Date Sale_Price } Category ||--o{ Car : "Category_ID" Car ||--|{ Sale_Record : "Car_ID" Car ||--|{ Color : "Color_ID" Customer ||--|{ Sale_Record : "Customer_ID" Staff ||--|{ Sale_Record : "Staff_ID"