Garden Glory wants to expand its database applications beyond the recording of property services. The company...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Garden Glory wants to expand its database applications beyond the recording of property services. The company still wants to maintain data on owners, properties, employees, services, and the service work done at the properties, but it wants to include other data as well. Specifically, Garden Glory wants to track equipment, how it is used during services, and equipment repairs. In addition, employees need to be trained before they use certain equipment, and management wants to be able to determine who has obtained training on which equipment. With regard to properties, Garden Glory has determined that most of the properties it services are too large and complex to be described in one record. The company wants the database to allow for many subproperty descriptions of a property. Thus, a particular property might have subproperty descriptions such as Front Garden, Back Garden, Second-Level Courtyard, and so on. For better accounting to the customers, services are to be related to the subproperties rather than to the overall property. Garden Glory wants to expand its database applications beyond the recording of property services. The company still wants to maintain data on owners, properties, employees, services, and the service work done at the properties, but it wants to include other data as well. Specifically, Garden Glory wants to track equipment, how it is used during services, and equipment repairs. In addition, employees need to be trained before they use certain equipment, and management wants to be able to determine who has obtained training on which equipment. With regard to properties, Garden Glory has determined that most of the properties it services are too large and complex to be described in one record. The company wants the database to allow for many subproperty descriptions of a property. Thus, a particular property might have subproperty descriptions such as Front Garden, Back Garden, Second-Level Courtyard, and so on. For better accounting to the customers, services are to be related to the subproperties rather than to the overall property.
Expert Answer:
Answer rating: 100% (QA)
Equipment Tracking What tables should be added or modified to track equipment its usage during services and repairs To track equipment you would likely need at least two new tables one for equipment a... View the full answer
Related Book For
Posted Date:
Students also viewed these databases questions
-
1. Should a juvenile ever be waived to adult court, with the risk that the child will be incarcerated with adult felons? 2. Do you support the death penalty for children? 3. Should juveniles be given...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
The control features of a bank account do not include: (a) having bank auditors verify the correctness of the bank balance per books. (b) minimizing the amount of cash that must be kept on hand. (c)...
-
Interview a systems analyst or database analyst and ask questions about how that organization uses data modeling and design tools in the systems development process. Concentrate your questions on how...
-
Sam, a small business owner, has had a turnaround in business; its now profitable. She wants to keep the excess cash liquid so that she can get it quickly if she needs it. How should she invest it?...
-
Research the use of robotics In manufacturing. Hovrare robots used? LO1
-
On December 31, 20X5, KTR Corporation acquired 80% of the outstanding shares of SJC Limited for $ 5,000,000. KTR is a Vancouver- based company, while SJC is based in Las Vegas, in the US. SJCs...
-
Lark City (a government entity) donates land that has a FMV of $800,000 and cash of $100,000 to Orange Corporation as an inducement to locate in the city. Four months later, Orange purchases...
-
A boy tosses a ball onto the roof of a house. For the launch conditions shown, determine the slant distance s to the point of impact. Also, determine the angle which the velocity of the ball makes...
-
17. A tree ecologist is studying oak trees in a forest in upstate New York. She knows from prior research that oaks occur at a rate of 8.2 trees per square mile in this forest. She marks off a random...
-
The Tokyo Olympics. After watching how the tokyo olympics became the most expensive summer game ever video answer the following questions. Q 3 : As you saw in the video, the capital investment a city...
-
write at least two paragraphs discussing the experiences of individuals who identify outside the traditional binary gender system (male/female.) Please explore the challenges they face and how...
-
Newly formed S&J Iron Corporation has 163,000 shares of $5 par common stock authorized. On March 1, Year 1, S&J Iron issued 9,000 shares of the stock for $12 per share. On May 2, the company issued...
-
Use the SMOKE for this question. The variable cigs is the number of cigarettes smoked per day. How many people in the sample do not smoke at all? What fraction of people claim to smoke 20 cigarettes...
-
Transcribed image text : Reproduced below from Farthington Supply's accounting records is the accounts receivable subledger along with selected general ledger accounts. Dec. 31/19 Balance Credit...
-
What are the differences between simple and complex EPS structure?
-
Citing a scientific article, explain in your own words, how DNA fingerprinting has been used in forensic science to solve crimes and why it may not always be accurate or effective.
-
What file extension should you use for SQL scripts?
-
What is a statement of work (SOW)? What purpose does it serve?
-
What is a modification problem? What are the three possible types of modification problems?
-
David Rose is puzzled. His company had a price-earnings ratio of 25 in 2004. He feels that this is an indication that the company is doing well. Julie Bast, his accountant, says that more information...
-
Which ratio or ratios from this chapter do you think should be of greatest interest to: (a) a pension fund considering investing in a corpo- ration's 20-year bonds? (b) a bank contemplating a...
-
Name ratios useful in assessing (a) li- quidity, (b) solvency, and (c) profitability. AppendixLO1
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App