1. Can we tell Lizzie about the spoilage charges for the entire period? We know the pounds...
Question:
1. Can we tell Lizzie about the spoilage charges for the entire period? We know the pounds of loss, but can we extract the cost from this database? Why or why not?
2. If your answer to 1 is no, how to change the database to solve this problem. Your answer must be specific (an attribute of a class, A new relationship Relationship properties)
3. The database has three volatile attributes. what they are?
4. Select one of the attributes you identified in 3) and tell me that two events will trigger a change in that attribute.
5. Lizzie wants to know which of the three stores has the highest revenue. This model does not give us this information because sometimes employees work in stores where they are not assigned. Tell me why we can't get this information from the database and how you would solve this problem.
Query 1 "total sales by customer" Total Sales by Customer X Customer SumOfDollar. $47,100.00 $37,500.00 $37,600.00 $36,250.00 $34,200.00 $52,000.00 $42,700.00 $4,000.00 Query 2 "total purchases by farmer" C310 C311 C312 C313 C314 C315 C316 C500 Farmer SumOfDollar. F202 F203 F204 F205 F206 F207 F208 F209 $18,100.00 $17,500.00 $18,100.00 $19,500.00 $16,500.00 $13,700.00 $15,700.00 $7,800.00 Query 3 "Q1 total sales" SumOfDollar - $134,300.00 Field: Customer = Table: Sale Total: Group By Sort: Show: Criteria: or: 4 Field: Farmer Table: Purchase Total: Group By Sort: Show: Criteria: or: Field: Dollar amount Table: Sale Total: Sum Sort: Show: Criteria: or: Sale date Sale Where ✓ Dollar amount Sale Sum ✓Dollar amount Purchase Sum KI K Between #1/1/2018# And #3/31/2018 Query 4 "Q1 total purchases" SumOfDollar $56,300.00 Field: Dollar amount Table: Purchase Total: Sum Sort: Show: Criteria: or: Query 5 "Q1 approximate GM" Expr1 $78,000.00 Query 6 "Sale delivery mileage" Engine # SumOfDriver. E456789 E567123 E654987 E659847 E978653 Field: GM: [Total Sales]! [SumOfDollar amount]-[Total Purchases] [SumOfDollar amount] Table: Sort: Show: Criteria: or: 0 45.5 36.3 22 ✔ 25 30.7 S Purchase Date Purchase Where Field: Engine Table: Sale Between #1/1/2018# And #3/31/2018# Total: Group By Sort: Show: Criteria: or: S Driver time Sale Sum S > Query 7 "time spent rinsing" ▬▬▬ Employee So Time Rinsing . 11122333 123456789 234567891 987654321 999884321 99988777 Field: Employee Social Sec Time Rinsing: SumLabor acquisition][Total hours worked]Labor acquisition] [Percentage of time rinsing Table: Employee Total: Group By Expression Sort: Show: Criteria: or: Query 8 "Cost of rinsing" D 123456789 234567891 987654321 999884321 99988777 101.5 116.8 100.3 Employee So Cost Rinsing. 11122333 67.8 57.9 42.7 S $1,522.50 $1,693.60 $1,404.20 $1,017.00 $897.45 $640.50 ISI Field: Employee Social Securit Cost Rinsing: [Employee]![Employee wage rate]"[Time Spent Rinsing][Time Rinsing] Table: Employee Sort: Show: Criteria: or: S Query 9 "total sales by type" Produce ID SumOfQuant. F1 F2 F3 F4 F5 V1 V2 V3 V4 V5 10575 19125 14950 9700 12325 16400 22125 F2 F3 F4 F5 V1 V2 V3 V4 V5 12005 16170 11375 Query 10 "total purchases by type" Produce ID # SumOfQuant. 12200 19400 15650 11650 12400 16700 23700 12700 18500 11600 Field: Produce ID Table: Stockflow 2 Total: Group By Sort: Show: Criteria: or: ✔ Field: Produce ID Table: Stockflow 4 Total Group By Sort: Show: Criteria: or: ✓Quantity sold Stockflow 2 Sum M Quantity purchased Stockflow 4 Sum S Query 11 "total QOH by type" F2 F3 F4 F5 V1 GSSSS V2 V3 V4 V5 WECHASSSSS Produce ID. SumOfTotal ( 1400 200 575 1900 F2 Query 12 "spoilage by produce type" Produce ID. Expr1. Produce descr 225 Tomato 75 Watermelon 125 Strawberry 50 Blueberry 75 Raspberry 300 Boston lettuce 75 Potato F3 F4 FS V1 V2 V3 feldoe Tab Produce type sold Sert ON 0 0 1500 500 2300 0 195 Romaine lettuce 30 Onion 225 Mushroom Field: Produce ID Table: Produce Total: Group By Sort: Show: Criteria: or: S B Total QOH Produce Sum K spolage produce type purchased undantly purchase produce pe soumourity sol produce type on handunofotel que descriptio Query 1 "total sales by customer" Total Sales by Customer X Customer SumOfDollar. $47,100.00 $37,500.00 $37,600.00 $36,250.00 $34,200.00 $52,000.00 $42,700.00 $4,000.00 Query 2 "total purchases by farmer" C310 C311 C312 C313 C314 C315 C316 C500 Farmer SumOfDollar. F202 F203 F204 F205 F206 F207 F208 F209 $18,100.00 $17,500.00 $18,100.00 $19,500.00 $16,500.00 $13,700.00 $15,700.00 $7,800.00 Query 3 "Q1 total sales" SumOfDollar - $134,300.00 Field: Customer = Table: Sale Total: Group By Sort: Show: Criteria: or: 4 Field: Farmer Table: Purchase Total: Group By Sort: Show: Criteria: or: Field: Dollar amount Table: Sale Total: Sum Sort: Show: Criteria: or: Sale date Sale Where ✓ Dollar amount Sale Sum ✓Dollar amount Purchase Sum KI K Between #1/1/2018# And #3/31/2018 Query 4 "Q1 total purchases" SumOfDollar $56,300.00 Field: Dollar amount Table: Purchase Total: Sum Sort: Show: Criteria: or: Query 5 "Q1 approximate GM" Expr1 $78,000.00 Query 6 "Sale delivery mileage" Engine # SumOfDriver. E456789 E567123 E654987 E659847 E978653 Field: GM: [Total Sales]! [SumOfDollar amount]-[Total Purchases] [SumOfDollar amount] Table: Sort: Show: Criteria: or: 0 45.5 36.3 22 ✔ 25 30.7 S Purchase Date Purchase Where Field: Engine Table: Sale Between #1/1/2018# And #3/31/2018# Total: Group By Sort: Show: Criteria: or: S Driver time Sale Sum S > Query 7 "time spent rinsing" ▬▬▬ Employee So Time Rinsing . 11122333 123456789 234567891 987654321 999884321 99988777 Field: Employee Social Sec Time Rinsing: SumLabor acquisition][Total hours worked]Labor acquisition] [Percentage of time rinsing Table: Employee Total: Group By Expression Sort: Show: Criteria: or: Query 8 "Cost of rinsing" D 123456789 234567891 987654321 999884321 99988777 101.5 116.8 100.3 Employee So Cost Rinsing. 11122333 67.8 57.9 42.7 S $1,522.50 $1,693.60 $1,404.20 $1,017.00 $897.45 $640.50 ISI Field: Employee Social Securit Cost Rinsing: [Employee]![Employee wage rate]"[Time Spent Rinsing][Time Rinsing] Table: Employee Sort: Show: Criteria: or: S Query 9 "total sales by type" Produce ID SumOfQuant. F1 F2 F3 F4 F5 V1 V2 V3 V4 V5 10575 19125 14950 9700 12325 16400 22125 F2 F3 F4 F5 V1 V2 V3 V4 V5 12005 16170 11375 Query 10 "total purchases by type" Produce ID # SumOfQuant. 12200 19400 15650 11650 12400 16700 23700 12700 18500 11600 Field: Produce ID Table: Stockflow 2 Total: Group By Sort: Show: Criteria: or: ✔ Field: Produce ID Table: Stockflow 4 Total Group By Sort: Show: Criteria: or: ✓Quantity sold Stockflow 2 Sum M Quantity purchased Stockflow 4 Sum S Query 11 "total QOH by type" F2 F3 F4 F5 V1 GSSSS V2 V3 V4 V5 WECHASSSSS Produce ID. SumOfTotal ( 1400 200 575 1900 F2 Query 12 "spoilage by produce type" Produce ID. Expr1. Produce descr 225 Tomato 75 Watermelon 125 Strawberry 50 Blueberry 75 Raspberry 300 Boston lettuce 75 Potato F3 F4 FS V1 V2 V3 feldoe Tab Produce type sold Sert ON 0 0 1500 500 2300 0 195 Romaine lettuce 30 Onion 225 Mushroom Field: Produce ID Table: Produce Total: Group By Sort: Show: Criteria: or: S B Total QOH Produce Sum K spolage produce type purchased undantly purchase produce pe soumourity sol produce type on handunofotel que descriptio
Expert Answer:
1 Yes In the case of spoilage the supplier will charge the retailer for the entire period of the los... View the full answer
Students also viewed these accounting questions
-
If your answer to #1 above was yes, what do you think would happen to your taxes? What would happen to your private health insurance premiums? Would you come out ahead or not?
-
How would your answer to Problem 1 change if instead we use the long-run model, with shoes and computers produced using labor and capital?
-
What can we tell about a compound when we know the empirical formula? What additional information is conveyed by the molecular formula? By the structural formula? Explain in each case.
-
A mover lifts a 50 lbm box off the ground and places it on a truck (Figure 1-21). If the floor of the truck is 4 feet off the ground, how much work was required to lift the box? 4 ft 50 lbs...
-
Discuss the relevance and value of business research, using a range of examples of business research projects to support your answer.
-
Convert the following 4-bit twos complement numbers to 8-bit twos complement numbers. (a) 0111 2 (b) 1001 2
-
In a recent study involving 54 women, the mean body temperature of the women was found to be 97.2F, with a standard deviation of 0.83. Random samples of size 36 are drawn from this population, and...
-
Sovereign Millwork, Ltd., produces reproductions of antique residential moldings at a plant located in Manchester, England. Since there are hundreds of products, some of which are made only to order,...
-
The expected return on Big Time Toys is 11 percent and its standard deviation is 17 percent. The expected return on Chemical Industries is 7 percent and its standard deviation is 16 percent. Suppose...
-
Play the following games in the Games Fair: Three Prize Roller Word Scramble Marble Draw Ten Spinner For each Games Fair game, answer the following questions: Create the probability distribution in a...
-
Donna is in hospital and is next to the washbasin on her three-bed bay. An older woman in the bay next to her has some tests done during the day. Afterward, the two staff members wash their hands in...
-
The price of IBA stock is $101. It will either increase by $10.2 or decrease by $8.5 at the end of month 1. If the price is up in the first month, it will either increase by $16.1 or decrease by $21...
-
"What are the functions and characteristics of the status registers, stack pointers, circular buffers, single repeat registers, and temporary registers in the C55x digital signal processor?"
-
With the rise of explainable AI (XAI),how can we design and analyze algorithms that not only achieve high performance on a specific task but can also demonstrably justify their decisions in a way...
-
A large multinational corporation with offices across the globe plans to implement Software-Defined Networking (SDN) to improve network agility and security.However,the corporation also relies on...
-
In a scenario with a large, distributed NoSQL database storing constantly changing sensor data from millions of IoT devices, how would you design a system to efficiently manage data consistency,...
-
pleaesolve require secion In 20X5, Build-It Corp. (BIC) was awarded a fixed-price contract of $9,400,000 to construct a warehouse for a client. Work began in 20X5 and was completed in 20X7. BIC...
-
Assume a simple Keynesian depression economy with a multiplier of 4 and an initial equilibrium income of $3,000. Saving and investment equal $400, and assume full employment income is $4,000. a. What...
-
Suppose the EEOC uses a job-scoring system and they determines that the wage rate for a secretary is $50 per hour, while the competitive labor market wage rate is $10 per hour. What is the effect of...
-
Identify two positive and two normative statements given concerning raising the minimum wage. List other minimum wage arguments not discussed in the Economics in Practice, and classify them as either...
-
How does government debt create a socially more inequitable distribution of income- redistribute income away from those with relatively lower incomes to those with relatively high income?
-
You are required to prepare a purchases ledger control account from the following for the month of June. The balance of the account is to be taken as the amount of creditors as on 30 June. 19X6 June...
-
Prepare a sales ledger control account from the following: 19X5 May 1 Debit balances Totals for May: Sales journal Cash and cheques received from debtors Discounts allowed Debit balances in the sales...
-
Prepare a sales ledger control account from the following information for July 19X9, carrying down the balance at 31 July: 19X9 July 1 July 31 Sales ledger balances Sales journal 9,700 99,280 Bad...
Study smarter with the SolutionInn App