- Please Refer To This Image To Answer The Next 4 Questions Items Transactions Pk Barcode 1 10 Pk Transactionid Purchas 1 (27.17 KiB) Viewed 24 times
- Please Refer To This Image To Answer The Next 4 Questions Items Transactions Pk Barcode 1 10 Pk Transactionid Purchas 2 (69.32 KiB) Viewed 24 times
- Please Refer To This Image To Answer The Next 4 Questions Items Transactions Pk Barcode 1 10 Pk Transactionid Purchas 3 (81.86 KiB) Viewed 24 times
- Please Refer To This Image To Answer The Next 4 Questions Items Transactions Pk Barcode 1 10 Pk Transactionid Purchas 4 (29.68 KiB) Viewed 24 times
his is open-book/note/slides. Do not work with other students on the exam. E ou have 1 attempt and the attempt will last for 1 hr and 50 minutes or 110 mir D Question 41 Use the ER diagram above to answer the following question: What customers have not used their rewards card (Rewards)? (Hint: Left and Right joins are not determined by the ER Diagram, but th SELECT * from Rewards r [Select] D [Select] INNER JOIN Transactions t LEFT JOIN Transactions t OUTER JOIN Transactions t RIGHT JOIN Transactions t * Previous
(Hint: Left and Right joins are not determined by the ER Diagram, be SELECT * from Rewards r [Select] [ Select] [Select] ON t.Customer AND r.CustomerCode WHERE t.Customer=r.CustomerCode ON t.Customer-r.Customer Code WHERE t.Customer AND r.CustomerCode Previous
Use the ER diagram above to answer the following question What customers have not used their rewards card (Rewarc (Hint: Left and Right joins are not determined by the ER Dia SELECT from Rewards r [Select] [Select] WHERE [Select] [Select] t.transactionID-0 ttransactionID is 0 t.transactionID is NULL EtransactionID=NULL • Previous Unnamed-Discord Warrior-Outfit - W Quiz Fir