Derive the logical e-r data model

Reference no: EM132675356

Janet, after years of working as a hairdresser and as a makeup artist, decided to go into business for herself. Over time the business has grown into a spa and beauty retreat and she now employs a few staff. With her growing operation she has identified the need to implement a computerized accounting information system. In order to have a system that meets her needs exactly and also to save cost, she has asked you to draw a simple, customized solution for her business. Her immediate need is for a customer sales information system, so that is what you will now create.

With customer service being so important to Janet, her customers tend to become regulars and she wants to maintain a record of each customer's contact information and preferences so that the spa will know what is important to the customer without having to be told each visit. The customer information that Janet considers important to maintain is the full name, cellphone number, favourite treatment, and special considerations (e.g. some customers have allergies or require fragrance-free products).

For employees, Janet just needs to record the names and cell phone numbers in the database. The spa also has a standard list of services which each have a standard name, description and price.

Janet also wants a database record of each customer visit both for customer billing at the time of service, as well as for future analysis. Janet wants to refer to these sales transactions as "Visits" in the database in order to reflect the spa's focus on customers' experiences. For each of these customer visits it is important to record a unique visit identifier, the date, the customer, the main staff member who served the customer, and the service or services experienced (sold).

Problem 1: Based on your analysis of Janet's requirements, list out the entities and relationships that should be present in the database, indicating the cardinality of each relationship.

Problem 2: Derive the Logical E-R data model

Problem 3: Show the Physical E-R data model, showing how you went from the Logical to the Physical using best practices.

Problem 4: assume the resulting accounting information system in LibreOffice Base (which is free) or in Microsoft Access.

Reference no: EM132675356

Questions Cloud

Personal philosophy of leadership : Provide a leadership detail according to the following question:

What types of substantive procedures can an auditor use : Discuss the difference in sampling risk and detection risk as well as the relationship between the two risks. What types of substantive procedures auditor use

How do construct the balance sheet and income statement : How do construct the balance sheet and income statement for Tonka Trucking LLC for the year ending December 31, 2019. Accounts Receivable $40,000

Reveries urban centers opened a new rental center : Reveries Urban Centers opened a new rental center in Midland, Michigan, on January 1, 2017. Michael Verhallen, the manager of the Midland rental center

Derive the logical e-r data model : Janet's requirements, list out the entities and relationships that should be present in the database, indicating the cardinality of each relationship.

Describe brockriede process : Describe Brockriede's process. Use a specific conflict that you have observed, (or one you could reasonably anticipate) to illustrate how the process works in

Describe opentable as a two-sided platform : Describe OpenTable as a two-sided platform. List the sides of that platform. Explain the same-side and the cross-side network effects.

Describe how this situation presents moral dilemma : Describe how this situation presents a moral dilemma. Identify the moral principles that are in conflict in this situation.

What are some of the barriers : Have you made evidence-based practice the norm in your practice and organization? What practices have you made sustainable?

User Account

All Pages