Question 4 Sql Consider Following Database Schema Item Itemno Name Type Price Customer Cid Q43802164
Question 4.A – SQL Consider the following database Schema: Item (ItemNo, name, type, Price) Customer (CID, Name) Sales (SID, ItemNo, CID, Quantity) Write the following queries in SQL. 1. Display item name, customer name and Quantity for all items bought by customer “CID=415”. 2. Retrieve the list of customers’ ID who have bought at least one item of type “Electrical” but never bought items of type “Cleaning”. Question 4.B – Relational Algebra Use the schema in Q#4 to answer the following queries in RELATIONAL ALGEBRA 1. Display the list of customers’ ID who have bought at least one item of type “Electrical”, but never bought items of type “Cleaning”. 2. Change the name of Customer ID=301 to be ‘Mike’. Show transcribed image text Question 4.A – SQL Consider the following database Schema: Item (ItemNo, name, type, Price) Customer (CID, Name) Sales (SID, ItemNo, CID, Quantity) Write the following queries in SQL. 1. Display item name, customer name and Quantity for all items bought by customer “CID=415”. 2. Retrieve the list of customers’ ID who have bought at least one item of type “Electrical” but never bought items of type “Cleaning”.
Question 4.B – Relational Algebra Use the schema in Q#4 to answer the following queries in RELATIONAL ALGEBRA 1. Display the list of customers’ ID who have bought at least one item of type “Electrical”, but never bought items of type “Cleaning”. 2. Change the name of Customer ID=301 to be ‘Mike’.
Expert Answer
Answer to Question 4.A – SQL Consider the following database Schema: Item (ItemNo, name, type, Price) Customer (CID, Name) Sales (…
OR