Replace the bracketed text in this template with your answers and any supporting screenshots. Then submit it for the Module Two table and SQL identification activity. You$$ll need to download this template, save it as a unique file, and then submit it for grading. Rename this document to include your last name and remove these instructions before submitting.

Using the tables and SQL statements from the prompt for Module Two Activity, answer the following questions. Replace the bracketed text with your answers and any supporting screenshots.

$1.$ How many records are shown in the Employee table?

$5$

$2.$ How many attributes are there in the Branches table?

$[$Insert your answer here.$]$

$3.$ Which attribute could be a primary key for the Employee table?

$[$Insert your answer here.$]$

$4.$ How many decimal places $($maximum$)$ can be stored in an employee$$s salary field?

$[$Insert your answer here.$]$

$5.$ How many decimal places $($maximum$)$ can a Department$\_$ID have?

$[$Insert your answer here.$]$

$6.$ What three rules do tables obey?

$[$Insert your answer here.$]$

$7.$ Is the Employee table normalized? How do you know?

$[$Insert your answer here.$]$

$8.$ What is the result of the following query?

$$ Select sum$($Salary$)$ from Employee where Department$\_$ID$=3$;

$[$Insert your answer here.$]$

$9.$ Identify the Employee ID$($s$)$ that would be returned as a result of the following query.

$$ Select $*$ from Employee where Classification $<>$ 'Exempt';

$[$Insert your answer here.$]$

$10.$ What is the result of the following query?

$$ Select max$($Salary$)$ from Employee;

$[$Insert your answer here.$]$