Question
A local hair salon is a consulting client of yours. The salon began operations in January 2018 and has grown steadily over the past 5
A local hair salon is a consulting client of yours. The salon began operations in January 2018 and has grown steadily over the past 5 months. It provides a variety of services but does not sell hair care products. The Salon does not have an accounting software package. It began tracking customers, appointments, and payments through a paper log book. The salon does not intend to implement a complex accounting information system, but would like assistance in establishing a better designed database system to track important information, such as services offered and used, inventory purchases, stylists and schedules. Customers make Appointments with their favorite hair stylist and can indulge in a number of Services such as basic hair cut/styling, hair color, highlights, perm, etc. Walk-ins are always welcome provided there is an opening (i.e., stylist is available) to serve them. For Appointments the salon needs to know the date and time of the appointment and which customer the appointment is for. The salon wants to track inventory levels (shampoo, hair color), so that purchase orders can be placed in a timely manner. The salon would also like to track the time it takes to complete each service. While each service has a standard price, promotions and other factors may affect the actual price extended to the Customer for the given service. The salon needs to keep information on its Employees including their home address, contact information and rate of pay. Customers contact information and gender also needs to be stored. You may find it useful to visit a local hair salon and find examples (screenshots) of forms and reports typically used in the salon (e.g., appointment book, purchase order). Incorporate applicable data elements from these documents in your database.
Create a REA model for the salons SALES and PURCHASE business processes. The REA must be clearly labeled. The deliverable should provide:
1. Entities (event, resources, and agents) for each process
2. Relationship between entities - cardinalities (min. max.).
Describe in sentences the relationship between major entities
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started