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

  What is the before-tax cost of debt for olympic

Olympic Sports has two issues of debt outstanding. What is the before-tax cost of debt for Olympic? What is Olympic's after-tax cost of debt

  Complete the michigan

Complete page 1 of the federal 1040 for Richard and Mary. Complete the Michigan 1040 Income tax form, Schedule 1, Form 1040CR property tax credit, Schedule W, and Form 4884 pension schedule

  Tony matheson plans to graduate from college in may 2012

tony matheson plans to graduate from college in may 2012 after spending four years earning a degree in sports and

  Predicting future social security payments

When discussing the statements sent to you by the federal government that predict your future Social Security payments, we said.

  Discuss the given statements

Discuss the following statements:- Over a typical cycle, the movement of the yield curve is like the wagging of a dog's tail. The entire tail wags, but short- term rates wag more often than long- term rates.

  What was the appropriate journal entry for job

For job 836, direct labor hours were 810 for the month of December. What was the appropriate journal entry for job 836 for the month of December

  The merchandise is not included in the preliminary inventory

At year-end, Raymond had merchandise costing $15,000 on consignment with the Joclyn Corporation. The merchandise is not included in the preliminary inventory balance.

  Allowance for doubtful accounts credit balance

It is estimated that 4% of credit sales will be uncollectible. What adjusting entry will Manning Company make if the Allowance for Doubtful Accounts has a credit balance of $1,485 before adjustment?

  Compute the cost of goods sold and ending inventory

Compute the cost of goods sold, ending inventory, gross profit, income tax expense and net profit assuming: FIFO cost flow, LIFO cost flow

  G and l form a limited partnership

G and L form a limited partnership. G, the general partner, contributes $80,000 and L, the limited partner, contributes $320,000. The partnership purchases commercial real estate on leased land, paying $4000,000 cash and borrowing $1,600,000 on a ..

  Post the above transactions to t-accounts

William Waterspout set up a retailing business selling gardening tools, called ‘Toolgarden' on 1 November 2016.

  What are the project rankings

Project A involves a present outlay of $100 and yields $321.76 after 5 years. What are the project rankings

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