HELP IN RELATIONAL DATABASE SYSTEMS

Chapter 5 HW 321

1: What is the purpose of DDL SQL statements?

6: What is the purpose of the SELECT command?

7: What is the purpose of the WHERE condition?

13: What is the purpose of the HAVING clause?

EXERCISE:

Write the SQL queries that accomplish the following tasks in the ZAGI Retail Company Sales Department Database:

E5.1b Display the CustomerName and CustomerZip for all customers.

E5.1c Display the ProductID, ProductName, and Product Price for products with a ProductPrice of $100 or higher.

E5.1k Display the TID and the total number of items (of all products) sold within the transaction for all sales transactions whose total number of items (of all products) sold within the transaction is greater than five.

EXERCISE:

Write the SQL queries that accomplish the following tasks in the HAFH Realty Company Property Management Database:

E5.2b Display the CCID, CCName, and CCIndustry for all corporate clients.

MC3 Snooty Fashions

Write CREATE TABLE statements to create the tables for the Snooty Fashions Operations Database depicted by the relational schema created in mini case MC3 in Chapter 3.

Use INSERT INTO statements to insert no fewer than 2 and no more than 10 records per table in the Snooty Fashions Operations Database.

(Do CREATE TABLE and INSERT statements just for DESIGNER and SHOW.