Create related tables to capture sales data and sales


Assignment

Using the previous assignment (see attachment) Use SQL command to:

1. Create related tables to capture sales data and sales transactions.

2. Populate all tables with the related data.

3. Update the database when new products arrive.

4. Update the database when a sale is made.

5. Describe (in at least a half page) the major points you learned on SQL and what lessons you have learned in this exercise.

Attachment:- Case.rar

Solution Preview :

Prepared by a verified Expert
PL-SQL Programming: Create related tables to capture sales data and sales
Reference No:- TGS02490828

Now Priced at $70 (50% Discount)

Recommended (96%)

Rated (4.8/5)