Problem 1: Rocky Mountain Hair Salon provides hair services and sells hair products. Your ERD should represent information requirements as described below:
- The database records information about each customer (name, address, email, and phone). If the customer participates in the loyalty program, loyalty card number is stored. Note that two customers can have the same phone number (e.g., home phone number of people from the same family) but they can't have the same loyalty number.
- The database needs to store a list of hair services that this salon can provide. For each service, the current price is stored. All customers receiving a service pay the current price of the service.
- A customer can receive multiple services during each session. Database needs to store what services were provided for the customer, quantity of each service provided, and price of each service provided.
- A customer can also purchase hair products at the end of a session, which is also recorded in the database, together with session dollar total and payment method. Again, quantity purchased and price paid are also recorded.
- Information about each product should be stored (a unique product number, description, type of product, and price.)
- If the customer participates in the loyalty program, a total number of points earned is calculated for each session and added to the current total number of points for this customer.