Lab1

Customer PK CustomerID FirstName LastName PhoneNumber Email Employee PK EmployeeID FirstName LastName Position Product PK ProductID ProductName Price Appointment PK AppointmentID FK1 EmployeeID FK2 CustomerID FK3 ServiceID AppointmentDate Sale PK SaleID FK1 CustomerID FK2 ProductID FK3 AppointmentID SaleDate TotalAmount makes Handles Makes Related to Service PK ServiceID ServiceName Price Related to Related to This relationship represents the connection between salon customers and their scheduled appointments. Customers make appointments to receive salon services, and this relationship tracks those appointments. Each customer can have multiple appointments, but each appointment is associated with one customer. This relationship reflects the relationship between salon customers and their purchase transactions. Customers initiate sales by buying products or services from the salon, and this relationship records those transactions. Each customer can have multiple sales, but each sale is initiated by one customer. This relationship signifies the association between salon products and their inclusion in sales transactions. It allows you to track which products were sold in each sale. Each product can be part of multiple sales, and each sale can include multiple products. This relationship connects salon appointments to sales transactions. It indicates that services provided during appointments may result in sales, such as haircuts or treatments. It helps record which appointments led to specific sales. Each appointment can be linked to multiple sales, and each sale can be associated with one appointment. This relationship represents the assignment of salon employees to specific appointments. It shows which employees are responsible for providing services during appointments. Each employee can handle multiple appointments, but each appointment is assigned to one employee. This relationship links specific services (such as haircuts or treatments) to appointments. It helps specify the type of service to be provided during an appointment. Each appointment can be associated with a particular service, and each service can be provided during multiple appointments.