Add, change, and delete records to the What SUP database (use the Ch10-02 file) a. Add the

Question:

Add, change, and delete records to the What SUP database (use the Ch10-02 file)
a. Add the following record to the Buyers table: BuyerID 605, Farley, 555-7187.
b. Add G as a CategoryID with a CategoryName of Women’s as a category to the Category table.
c. Delete the following record from the Buyers table: BuyerID 601.
d. Change the buyer for the following Product IDs from buyer 601 to buyer 605: Product ID 104, 108, 113, and 115.
e. Print the first page of the product, buyers, and category tables as modified in a landscape orientation.
f. Save your file as Ch10-02_01_student_name (replacing student_name with your name).

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Question Posted: