Consider the General Hardware Corp. relational database. Using the informal relational command language described in this chapter, write commands to: MINICASES 1. Consider the following relational database for Happy Cruise Lines. It keeps track of ships, cruises, ports, and passengers. A ‘‘cruise’’ is a particular sailing of a ship on a particular date. For example, the seven-day journey a. List the product name and unit price of all of the products. b. List the employee names and titles of all the employees of customer 2198. c. Retrieve the record for office number 1284. d. Retrievetherecordsforcustomersheadquartered in Los Angeles. e. Find the size of office number 1209. f. Find the name of the salesperson assigned to office number 1209. g. List the product name and quantity sold of each product sold by salesperson 361.
Consider the General Hardware Corp. relational
a). List the product name and unit price of all of the products.
Query: select ProductName,UnitPrice from PRODUCT;
b). List the employee names and titles of all the employees of customer 2198.
Query: select EmployeeName, Title from CUSTOMEREMPLOYEE where CustomerNumber = 2198;
c). Retrieve the record for office number 1284.
Query: select *from OFFICE where OfficeNumber=1284;
d). Retrieve the records for customers headquartered in Los Angeles.
Query: select *from CUSTOMER where HQCITY='Los Angeles';
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
