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)...
-
A 750 = g uniform steel rod is bent into a circular arc of radius 500 mm as shown. The rod is supported by a pin at A and the cord BC. Determine (a) The tension in the cord, (b) The reaction at A....
-
5 Which one of the following correctly represents Sodium oxide? +2 XX a) Na 20 XX 6) 2NaOx x; 1-2 'xx' 1-2 c) 2 Na 20% c) Na XX XX 6 An element with atomic number_ will form a basic oxide. a) 7 (2,5)...
-
Adjusting entries are often required in accounting. Please describe the various types of adjusting entries and give at least three examples.
-
The Hemp Division of West Company produces rope. One-third of the Hemp Divisions output is sold to the Hammock Products Division of West; the remainder is sold to outside customers. The Hemp...
-
The following information pertains to the City of Williamson for 2 0 2 4 , its first year of legal existence. For convenience, assume that all transactions are for the general fund, which has three...
-
A month has elapsed since Precision Computer Centres year-end. Tony Freedman will use four specialized journals for recording business transactions in the month of Septembertwo in this chapter, and...
-
Provide a detailed (arrow-pushing) reaction mechanism for the reaction scheme given below SONOGASHIRA COUPLING SYNTHESIS 1. NaBH. 91% 2. TMSC=CMgBr. MEOCOCI, 0C. 65% 3. K,CO,, MEOH, 70% 1. MCPBA,...
-
A company has the following adjusted trial balance: Debit Credit Cash Accounts receivable Prepaid rent Equipment 1,500 2,100 100 3,500 Accumulated depreciation-Equipment 1,500 Accounts payable...
-
Stacey's Plano Rebuilding Company has been operating for one year. At the start of the second year, its Income statement accounts had zero balances and its balance sheet account balances were as...
-
The Willson Company starts operations in Year One. It makes sales of $600,000 in Year One and $800,000 in Year Two. Cash of $440,000 is collected in Year One while $600,000 is collected in Year Two....
-
Most economies today are "mixed economies," in which there is a both a public sector and a private sector. Explain the following justifications for government intervention in the economy: public...
-
Briefly explain why when the marginal cost of an activity increases as one does more of it and why the marginal benefit of an activity decreases the more one engages in it.
-
. Draw and explain generic PL/SQL block
-
If someone's Z-score for a variable was 0.67. Their score is a significant extreme score. Their score is not significant. O Their score is slightly above average. O Their score is an outlier.
-
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?
-
As problems 5.18 and 5.19 reflect, the air temperature in the test section of conventional hypersonic wind tunnels is low. In reality, air liquefies at a temperature of about \(50 \mathrm{~K}\)...
-
The reservoir temperature calculated in problem 5.20 is beyond the capabilities of heaters in the reservoir of continuous-flow wind tunnels using air. This is why you do not see a Mach 20...
-
Write the \(y\) component of Eq. (6.7), and use it to derive Eq. (6.12). Equation 6.12: \(\frac{\partial(ho v)}{\partial t}+abla \cdot(ho v \mathbf{V})=-\frac{\partial p}{\partial y}+ho f_y\) V pfd7...
Study smarter with the SolutionInn App