- 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.
- 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.
- Exercise 2 – page 444: Follow same approach as #2 15 points also using the AP database.
- If the guitar database was used in a production environment, explain the following (15 points):
- Circumstances for implementing each of the four privilege levels.
- How you would group the privileges into roles