Question: 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

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Question 4.A - SQL Consider the following database Schema: Item (Item No name, type, Price) Customer (CID, Name) Sales (SID, Item No, CID, Quantity) Write the following queries in SQL. 1. Display...

able Editing Note: Please type your solution in notepadotepad++ and save it as HWSYourName.sql", otherwise I won't grade it. This assignment is designed to let you have a hands-on experience writing...

DB Browser for SQLite - C:\Users\ACER\Downloads\Company SOLite(2).db File Edit View Tools Help New Database Open Database Write Changes Revert Changes Open Project Save Project Altach Database X...

the shopping database For many query questions we refer to the following database schema for a website that keeps track of what people like to buy or actually buy in different on-line supermarkets....

Please write in MySQL or according to MySQL. (because some other packages like Oracle commands for SQL are different from MySQL. I want MySQL.) You have to create the table, Populate with data and...

a 1. One to many relationships are the most uncommon type of relationships in an ERD. True or False? 2. Normalize the following schema, with given constraints, to 3NF. books/accessionno, isbn, title,...

DATABASE SYSTEM QUESTION /SQL QUERIES Consider the following relational schema for the airport transfer database: airport ( a-code , name, capacity) customer ( c-id , name, birth-year, address)...

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

Thompson Company spent $240,000 to acquire all of Lake Corporations stock on January 1, 20X2. The balance sheets of the two companies on December 31, 20X3, showed the following amounts: Lake reported...

A certain weak acid, HA, with a K a valueof 5.61?10?6, is titrated with NaOH. Part A A solution is made by titrating9.00mmol (millimoles) of HA and 3.00mmol of thestrong base. What is the resulting...

Credit card insurance is usually unnecessary since your liability on credit card losses is limited by law to Question content area bottom Part 1 A . $ 0 . B . $ 5 0 . C . $ 1 0 0 . D . $ 5 0 0 .

SIMAD UNIVERSITY Class: BACC25 Subject: Islamic Accounting Instructions: a) Follow The Instructions. Midterm Exam Instructor: All Ibrahim Date: 6-4-2022 b) You Have 1.5 Hrs. To Complete This Test. c)...

(Appendices) SALES, SALES RETURNS, AND SALES ALLOWANCES. The contractor sales department of a Builders Square store in suburban Chicago had the following salesrelated transactions on a recent day: a)...

(Appendices) DISCOUNT POLICY AND GROSS MARGIN. Compton Electronics sells Motorola cellular phones. During 19x8, Compton sold 1,000 units for $300 per unit. Each unit costs Compton $180. At present,...

(Appendices) INTERNAL CONTROL FOR SALES. Alcoa Building Products distributes aluminum siding and related building products to building contractors, all of whom purchase on credit. LO6 REQUIRED: List...