Directions: Please read the question. Type your answer in the space provided. Add new lines/pages if necessary. No limit on the number of pages. Preferred file type to submit your answers is PDF.

• Words in bold need to be used in your answer as is..

What are log files used for? Write about at least 2 points. 

 

What three measures would you take to keep databases secure? 

 

 

 

 

 

 

 

 

 

 

 

 

Write a statement to rename a user named Bobto Robert.(same server). (statement(s) required) 

 

Write a statement to grant update and delete on all tables of testdatabase. (statement(s) required) 

 

Write three benefits of backing up a database. [3 pts] What statement/command is used to backup a database? 

 

What are three common errors/warnings trying to use the insert statement to do data entry? 

 

Create a database named myStore. (statement(s) required)[1 pt] Create a table named managerand another one named departmentswith at least 3 fields each (please use correct datatypes for each).(statement(s) required)[6 pts]Establish a relationship between the manager and departmentstable. (statement(s) required) 

 

Write a statement to add a 500 dollars holiday bonus for all employees who has been with the company since 01/01/2022.(statement(s) required)  Add 250holiday bonus for employeeswho joined the company on or after 07/01/2022. (statement(s) required)

 

Backup a database named vehicles.(statement(s) required).  Drop the database (statement(s) required) . Restore the database from the backup. (statement not required. Only steps that you are going to take to restore the database from the backup required.) 

 

Think of a local floral business. Based on all topics you have learned and reviewed, answer the following:

 

• How would they benefit from a database? Write three major benefits. 

• Would they need to hire multiple people to create and manage their database? 

• Create a user named anawith password pass1to have full access to the database with all privileges. (statement(s) required) [3pts]