Question: Given the following relational schemas: Client (cid: integer, cname: string, address: string, area: string) Item (Iid: integer, Iname: string, price: real, inStock: intger) Delivery (

Given the following relational schemas: Client (cid: integer, cname: string, address: string, area: string) Item (Iid: integer, Iname: string, price: real, inStock: intger) Delivery ( did: integer, cid: integer, shipdate: date) Delivered_Item( did: integer, Iid: integer, amount: integer) Write quires in SQL to : 1. Find the total value of Items in the stock. 2. For all Clients in Hawaliy, list the Client name, Item name, and amount for all Deliveries. 3. Find the Items name whose name contains iPad Air with price more than the average prices of all Items. 4. Find the Client names and total sales of Item delivered to each Client. Only show Clients with sales over 150 KD 5. Find the number of Deliveries to Client with the first name Sara

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!

Given the following relational schema, write queries in relational algebra to answer the English questions. The best approach is to use the online relational algebra tool. Customer (cid: integer,...

Given the following relational schema, write queries in relational algebra to answer the English questions. The Access Database for the schema is available, as is a DDL file. It is also available on...

Given the following relational schema, write queries in SQL to answer the English questions. The Access Database for the schema is available, as is a DDL file. It is also available on the MySQL...

3) (28 points): Given the following relational schemas where SSN stands for Social Security Number DEPARTMENT deptName, managerSSN, budget) EMPLOYEE(empSSN, empName, dateHire, birthdate, salary,...

Assume that you are given the following relational schemas for the basketball team Player (ID: integer, Name: varchar (64), Birthday: date, Address: varchar (128), Email: varchar (32), PhoneNumber:...

Given the following relational schemas of a Hospital database, express the queries using Relational Algebra. Hospital Database Doctor (Doc_id, Name, Designation, Area_of_Expertise) Employee (Emp_id,...

Given .sql file: create table Player ( ID integer, Name varchar(64), Birthday date, Address varchar(128), Email varchar(32), PhoneNumber char(10), PlayPos varchar(16) ); alter table Player add...

Given the following relational schemas (SQL) 1. List the name of every teacher (distinct names) who teaches in RoomN '34' in Winter2011. 2. List CourseN, CourseName, and TeacherName of every course...

Consider a discrete time Markov chain with finite or countable state space S and transition matrix II(x, y), x, y E S, so that II(x, y) > 0 is the probability for the Markov chain to jump from z to y...

Below is the energy level diagram for the reaction H 2(g) + F 2(g) HF (g) (a) Calculate the heat of formation of HF (g) ( 2 msk) (b) Is this reaction exothermic or endothermic? Enerav (KJ) 411 389...

QUESTION 1 Activity - based costing ( ABC ) is most beneficial for: Companies with a simple production process and low product diversity. Companies that produce a wide range of products with complex...

Assuming Purr-A-Lot, Inc. uses weighted-average (periodic) inventory procedures, the ending inventory cost is: Select one: A. $4,368 B. $4,992 C. $5,088 D. $4,320

What are the implications of rapidly rising health care prices and spending for ( a ) the growth of real-wage rates, ( b ) government budgets, and ( c ) off shoring of U.S. jobs? Explain.

KEY QUESTION What are the twin problems of the health care industry as viewed by society? How are they related?

LAST WORD What groups benefit and what groups lose from the U.S. sugar subsidy program?