Please refer to this image to answer the next 4 questions. Items Transactions PK BarCode (1,10) PK TransactionID Purchas
Posted: Fri May 06, 2022 12:19 pm
Please refer to this image to answer the next 4 questions. Items Transactions PK BarCode (1,10) PK TransactionID Purchase Name (0,10)-0 FK BarCode Cost DateTime Type FK Customer . Previous Collect (1.1) Rewards (1.1) PK CustomerCode FirstName LastName Email
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
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