Computer science question

  1. Application Implementation

You Must write each of the following SQL commands:

Write a set of at least 6 SQL queries that would retrieve relative and important data from your database.

Write a set of at least 5 SQL updates that would modify relative and important data in your database.

Write a set of at least 5 SQL deletes that would delete some data from your database.

Write a set of at least 2 SQL views that would define some virtual tables in your database.

 

For each of the above SQL commands give a brief explanation of the purpose of each command and the output (if any) for each.

.

finally:
Create forms, reports, queries, menus or navigation forms as needed on top of the tables. In general, a simple data entry form should be created for each table. For example, if the business takes orders from customers, create a form with Orders and Order items with

SAMPLE ASSIGNMENT
Powered by WordPress