Computer science question
-
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