Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditory Cognition And Human Performance: Research And Applications

Authors: Carryl L. Baldwin

1st Edition

0415325943, 978-0415325943

More Books

Students also viewed these Accounting questions