PRIMARY KEY based on data Data is maintained as shown to keep track of all the services performed on different properties. PropertyID PropertyName PropertyType Street P001 Eastlake Building Office 123 East Lake Ct. City Fairfax State Zip ServiceDate P002 Elm Street Apt Apartments 546 Elm Street P001 Eastlake Building Office 123 East Lake Ct. P003 Fairfax Arts Center Commercial 123 Main Plaza POGZ Elm Street Apt Apartments P004 Roberts Household Residential Herndon Fairfax Reston 546 Elm Street Herndon 456 Old Woods Road Burke VA 22129 VA 22099 VA 22029 VA 22153 VA 22099 VA 22015 Description 5/1/2011 Lawn Mow 5/6/2011 Lanscape 5/7/2011 Lawn Mow 5/3/2011 Garden Service 5/12/2011 Lawn Mow 5/12/2011 Garden Service Amount $90 $530 $60 $230 $80 $190 Each property is uniquely identified by PropertyID. As seen, the same property is serviced multiple times each on a different date. No property is serviced twice on the same date. Given the data and above information, which ONE would be best option for a primary key? ○ PropertyID O Composite of (PropertyID, Service Date) O Composite of (PropertyName, ServiceDate) ○ Amount

PRIMARY KEY based on data Data is maintained as shown to keep track of all the services performed on different properties. PropertyID PropertyName PropertyType Street P001 Eastlake Building Office 123 East Lake Ct. City Fairfax State Zip ServiceDate P002 Elm Street Apt Apartments 546 Elm Street P001 Eastlake Building Office 123 East Lake Ct. P003 Fairfax Arts Center Commercial 123 Main Plaza POGZ Elm Street Apt Apartments P004 Roberts Household Residential Herndon Fairfax Reston 546 Elm Street Herndon 456 Old Woods Road Burke VA 22129 VA 22099 VA 22029 VA 22153 VA 22099 VA 22015 Description 5/1/2011 Lawn Mow 5/6/2011 Lanscape 5/7/2011 Lawn Mow 5/3/2011 Garden Service 5/12/2011 Lawn Mow 5/12/2011 Garden Service Amount $90 $530 $60 $230 $80 $190 Each property is uniquely identified by PropertyID. As seen, the same property is serviced multiple times each on a different date. No property is serviced twice on the same date. Given the data and above information, which ONE would be best option for a primary key? ○ PropertyID O Composite of (PropertyID, Service Date) O Composite of (PropertyName, ServiceDate) ○ Amount

Understanding Business

12th Edition

ISBN:9781259929434

Author:William Nickels

Publisher:William Nickels

Chapter1: Taking Risks And Making Profits Within The Dynamic Business Environment

Section: Chapter Questions

Problem 1CE

See similar textbooks

Similar questions

Quarter 1 2 31 11 14 172 20 23 263 29 32 354 38 41 44Compute seasonal relatives for this quarterly data.a. Use the SA method.
php?attempt=104149&cmid%330865 aline Services v OS Ticket system My Dispense Academic Calendar N My courses 3) v Q b) Calculate the weighted moving average for periods 7 through 10 using weights of 0.6, 0.3, and 0.1. n Lo S : Cha Weighted moving Period Actual average 1 64 2 84 3 91 4 97 115 6. 135 7. 137 8. 144 6. 153 10 171 beriods 7 through 10. Use 5.
QUESTION 4 Suppose the following are the seasonal indices for the first three quarters of the year for a quarterly series: Quarter Seasonal Index Q1 72.4 Q2 85.3 Q3 109.6 Remember that the seasonal indices should average 100 so you should be able to infer the seasonal index for Q4. Furthermore, suppose that the estimated coeffcients from a regression of the deseasonalized series on Time are given below: Coefficients Intercept 2,506 Time 71.3 If the original value of the series in a Q1 was 2,040, then what is the seasonally adjusted value? (please round your answer to 1 decimal place)
Part C
Naïve method versus three period Moving Average The number of major plumbing repair jobs performed by Augur’s Plumbing Service in each of the last six months is listed below. Month Jobs October 92 November 94 December 98 January 95 February 99 March 104 Use the ‘textbook’ naïve method to forecast April jobs (Ft+1 = Xt + (Xt – Xt-1). Use the three- period moving average to forecast jobs in April Based upon the MAD (mean absolute deviation), determine whether the three-period moving average or textbook naïve method is more accurate, based upon forecasts for January through March.
Year Quarter Period Cost/Unit ($) 1 1 1 $20.00 2 2 $17.23 3 3 $13.39 4 4 $17.94 2 1 5 $20.29 2 6 $25.61 3 7 $22.62 4 8 $29.63 3 1 9 $23.87 2 10 $20.35 3 11 $26.32 4 12 $25.50 4 1 13 $20.90 2 14 $28.48 3 15 $32.65 4 16 $25.78 5 1 17 $28.90 2 18 $32.61 3 19 $28.66 4 20 $25.27 6 1 21 $25.80 2 22 $35.71 3 23 $27.26 4 24 $27.89 7 1 25 $28.50 2 26 $28.64 3 27 $32.52 4 28 $28.24 8 1 29 $37.95 2 30 $28.59 3 31 $37.07 4 32 $38.16 Use simple linear regression analysis to find the estimated parameters for the line that minimizes MSE for this time series. (Round your answers to two decimal places.) b0= b1= (c) What is the average cost increase (in $) that the firm has been realizing per quarter? (Round your answer to two decimal places.) $ (d) Compute an estimate of the cost/unit (in $) for the next quarter. (Round your answer to two decimal places.) $
Interpret the MAD of the most accurate among the forecasting models below. A. Naïve approach;B. 5-month SMA model;C. WMA model with weights 0.1, 0.3, and 0.6; orD. ES model with α = 0.5 and a forecast of 3,500 liters in the first month.