[Solved] IT2351 Assignment7

1. If you were assigned the task of deleting a customer from the customers table as a database administrator, explain the logic you would implement to accomplish this task via a stored program in in a PDF file named Assignment7. Include the type of stored program and the steps that would be required (keep in mind the relationships between the tables). 15 points +5 to include implementation in MySQL Workbench.
2. Exercise 1 page 444. Be sure to fully comment your code since the solution is in the student files.

Commenting your code shows your understanding of the topic. I recommend you attempt the exercise before turning to the solution. 15 points. Use the AP database.

3. Exercise 2 page 444: Follow same approach as #2 15 points also using the AP database.
4. If the guitar database was used in a production environment, explain the following (15 points):
5. Circumstances for implementing each of the four privilege levels.
6. How you would group the privileges into roles