Question

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 create 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). ACCT 3015 Assignment 1 – This is an individual assignment Page 2 of 3 Your Assignment Note: You might find this and other Unit 3 references to be useful while completing this assignment: https://www.datanamic.com/support/lt-dez005-introduction-dbmodeling.html Please submit

Questions 1-3 in either Microsoft Word or PDF format, and Question 4 in Microsoft Access. Submit your files to the Assignment 1 dropbox before the deadline. This is worth 15% of your course grade.

Question 1 (3 points):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.

Question 2 (3 points): Create the Logical E-R data model

Question 3 (5 points): Create the Physical E-R data model, showing how you went from the Logical to the Physical using best practices.

Question 4 (4 points): Create the resulting accounting information system in LibreOffice Base (which is free) or in Microsoft Access.

Answer 1

Answer to Question No.1. Entity Relationship database

From the mentioned passage it is clear about the entity relationship with customers and develop a data base for smooth running of the organisation in the future level.Here specified the Janet's business as a hairdresser and sequential improvement in the business such as grown into a spa and beauty retreat and she now employs a few staff.During the growth of business Janet bring certain important reforms for sustaining the customers in her business and also an asset of the entity in future level.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 create a simple, customized solution for her business. Besides this  her immediate need is for a customer sales information system,for this  she wants to maintain a record of each customer’s contact information and preferences because the customer service being so important to Janet, her customers tend to become regular.Under this information it 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).

Janet also take decision for connecting employees with customers for providing better service in her spa business,for this Janet just needs to record the names and cell phone numbers in the database.So 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). From the database record we can identify each customer's,name,location, need and preferences and also understand their visit time,their services needed time,who are the employees meet this services and the customer's ultimate experiences about the services and like that,Janet just understood these things with a simple click upon the "visits" in the data base.

An entity relationship model, also called an entity-relationship (ER) diagram, is a graphical representation of entities and their relationships to each other, typically used in computing in regard to the organization of data within databases or information systems.The entity relationship modelling has become a widely used approach in the development of database applications. The approach is essentially top-down, in that the first step is to look overall at the requirements for the application being developed, identifying the entities involved. The approach progresses from that point through the development of a detailed model of the entities, their attributes and relationships. The Entity-Relationship Modelling process is not formal, in the mathematical sense, but to be done well, it requires a consistent precision to be applied to the way that entities, their relationships and their attributes are discussed.An entity may represent a category of people, things, events, locations or concepts within the area under consideration. An entity instance is a specific example of an entity. For example, Janet is an entity instance of customer and employee entity.Based on the entity of customer relationship ,the requirements in the database the attributes such as,Name,Address,Date of Visit, Needed service, Date of service, Billing.In the case of employee relationship with the entity,the requirements in the database,the attributes such as-Name of the employee, Address,Job title, Division of the Unit,Employee Id No.,Service, Date of Service and like that.So the database can provide better usefulness to Janet business in this regards.