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.

Transcribed Image Text:

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

Answer rating: 100% (QA)

1 Yes In the case of spoilage the supplier will charge the retailer for the entire period of the los... View the full answer