Create the logical e-r data model

Assignment Help Accounting Basics
Reference no: EM132670015

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 Creating 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: Create the Logical E-R data model

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

Reference no: EM132670015

Questions Cloud

Obtain new genetic information by conjugation : Is it usually more advantageous for a bacterium to obtain new genetic information by conjugation or by spontaneous mutation? Explain your answer.
What are the elements of accounting : Define Accounting. What are the elements of accounting? Explain in detail. Explain the generally accepted accounting Principles (GAAP)
How does film shape your understanding of the prison system : How does 13th characterize our criminal justice system and political institutions? How does this film shape your understanding of the prison system?
How the fiji government can work better in combating issues : Provide suggestions as how the Fiji government can work better in combating the issues experienced from Covid-19 pandemic.
Create 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.
Provide an overview of the normal flora : Provide an overview of the normal flora in the human body that your pathogen may interact with, and include some challenges that the flora might present.
Discuss about the social reproduction in brief : Please select two of the following concepts and write an essay discussing how they are reflected in the labour markets and organization of work.
How does the natural flora in the gi tract protect : How does the natural flora in the GI tract protect your body from salmonella?
Outline potential barriers salmonella : Outline potential barriers salmonella might encounter going through the human body

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd