Starting from:

$30

IT2351-Assignment 7 Solved

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 tablesto 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.  .  Use the AP database.

 

3.      Exercise 2 – page 444: Follow same approach as #2 also using the AP database.

 

 

4.      If the guitar database was used in a production environment, explain the following):

 

a.      Circumstances for implementing each of the four privilege levels.

b.      How you would group the privileges into roles

More products