1. Engineering
  2. Computer Science
  3. database processing fundamentals design and implementation 15th ed 1 write...

Question: database processing fundamentals design and implementation 15th ed 1 write...

Question details

Database Processing Fundamentals, Design, and Implementation 15th Ed.


1. Write a relational algebra statement to display all of the columns of the INVENTORY table. (See page 120 for an instance of the INVENTORY table.)
2. Write a relational algebra statement to display WarehouseID, SKU, and SKU_Description columns of the INVENTORY table. (See page 120 for an instance of the INVENTORY table.)
3. Write a relational algebra statement to display all data on products of the INVENTORY table having a QuantityOnHand greater than 0. (See page 120 for an instance of the INVENTORY table.)
4. Write a relational algebra statement to display the SKU and SKU_Description for products of the INVENTORY table having QuantityOnHand equal to 0. (See page 120 for an instance of the INVENTORY table.)
5. Write a relational algebra statement to display SKU, SKU_Description, and WarehouseID for all products of the INVENTORY table that have a QuantityOnHand equal to 0 and a QuantityOnOrder greater than 0. (See page 120 for an instance of the INVENTORY table.)
6. Write a relational algebra statement to display the SKU, SKU_Description, WarehouseID, and QuantityOnHand for all products of the INVENTORY TABLE having a QuantityOnHand greater than 1 and less than 10. (See page 120 for an instance of the INVENTORY table.)
7. Write a relational algebra statement to show a unique SKU and SKU_Description for all products of the INVENTORY table having an SKU equal to 201000. There should be no duplicate rows in the result set. (See page 120 for an instance of the INVENTORY table.)
8. Use both the INVENTORY and WAREHOUSE tables to answer this question. Write a relational algebra statement to display the SKU, SKU_Description, and WarehouseID, WarehouseCity, and WarehouseState for all items stored in the Atlanta, Bangor, or Chicago warehouse. (See page 119 for an instance of the WAREHOUSE table and page 120 for an instance of the INVENTORY table.)
9. Use both the INVENTORY and WAREHOUSE tables to answer this question. Write a relational algebra statement to display the SKU, SKU_Description, WarehouseID, WarehouseCity, and WarehouseState of all items not stored in the Atlanta, Bangor, or Chicago warehouse. (See page 119 for an instance of the WAREHOUSE table and page 120 for an instance of the INVENTORY table.)
10. Use both the INVENTORY and WAREHOUSE tables to answer this question. Write a relational algebra statement to display the SKU, SKU_Description and WarehouseID for all items stored in a warehouse managed by Lucille Smith. (See page 119 for an instance of the WAREHOUSE table and page 120 for an instance of the INVENTORY table.)

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution