DATABASE SQL 6. Create a view based on a query to display the order No and Ship_date for all ordersshipped from warehouseNo WH2.7. Create a view based on a query to display the warehouse information from which thecustomer named "Fatma" was supplied her orders. Produce a listing: orderNo,WarehouseNo,8. Create a view based on a query to display the cname,No_of_orders, Avg_order_amt,where the middle column is the total number of orders and last column is the averageorder amount for that customer.9. Create a view based on a query to display the orders that were not shipped within 30days from the order date.

5. Create a view based on a query to display the orderNo and Ship_date for all orders shipped from warehouse No WH2. 7. Create a view based on a query to display the warehouse information from which the customer named "Fatma" was supplied her orders. Produce a listing: orderNo, WarehouseNo, 3. Create a view based on a query to display the cname,No_of_orders, Avg_order_amt, where the middle column is the total number of orders and last column is the average order amount for that customer. 9. Create a view based on a query to display the orders that were not shipped within 30 days from the order date.

5. Create a view based on a query to display the orderNo and Ship_date for all orders shipped from warehouse No WH2. 7. Create a view based on a query to display the warehouse information from which the customer named "Fatma" was supplied her orders. Produce a listing: orderNo, WarehouseNo, 3. Create a view based on a query to display the cname,No_of_orders, Avg_order_amt, where the middle column is the total number of orders and last column is the average order amount for that customer. 9. Create a view based on a query to display the orders that were not shipped within 30 days from the order date.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Information technology Explain to management the notion of a database and the components of a database.
Reading and writing to a relational database using a computer language
How is user data entered into a database?
Explain the purpose and functionalities of database query languages such as SQL (Structured Query Language). Discuss the different types of SQL queries (SELECT, INSERT, UPDATE, DELETE) and their applications.
Explain the role of the database administrator in the development, implementation and maintenance of a database system.
Provide examples of popular relational database management systems (RDBMS).
Differentiate between database management systems and file-oriented systems.
Explain the role of a database management system (DBMS) in managing data and databases.
Differentiate between database management systems and file-oriented systems.
Please provide an example of an actual SQL database.