This is a group project with maximum group size of 2 members. Only one submission is required from each group, but each group member should provide a peer evaluation of the partner.
Business Description for Order Processing System
A2Z Salon Inc. (A2Z), a beauty care organization, currently has ten stores in a metro area. It caters to the
beauty and hair care needs of both female and male clients. In addition, each salon sells beauty products
such as shampoos, conditioners, cosmetics, fragrances, etc. Each salon employs qualified beauticians with
relevant beauty certifications from trade schools. During a typical business day, each A2Z salon serves at
least 10 customers per beautician. A customer generally sets up an appointment ahead with a beautician,
but walk-ins without prior appointments are also allowed depending upon customer traffic. During a visit
a customer could order several services such as hair styling, hair color, pedicure, manicure, hair shampoo,
etc. and/or buy some beauty products. The business has been growing rapidly over the past year, and the
CEO/owner Jane Weber wants to install a new information system for managing the customer ordering
and payment processing across salons.
A2Z Salon Inc. offers optional membership to clients for a fixed annual fee (currently priced at $25). Members are offered discount prices on all products and services. Members also are sent promotions on a regular basis. For all customers, their styling preferences are stored in the system so that beautician could understand the needs and preferences of a customer during salon visits. Each salon accepts customer payments in terms of cash, credit card or check.
The following should be turned in on the Moodle before the due date and time. A printout of the report
should also be provided at the beginning of class on the due date. While one group member could upload
the group project, each member should upload the confidential peer evaluations individually.
List of Entities: All required entities should be identified including any associative entities identified for resolving M:N relationships
Business Rules: Rules that involve the above mentioned entities (two for each relationship on the ERD)
ER Diagram: This diagram should resolve all M: N relationships. This should clearly identify the major
attributes of various entity sets along with Primary/Foreign keys. Show appropriate connectivity. Use MS
Visio for creating ERD.