Module Two Activity Template

DAD 220 Module Two Activity Template Overview Download this template and rename the file to include your last name. Remove these instructions before submitting the completed document for grading. Replace the bracketed text in this template with your answers and any supporting screenshots. Then submit the completed template for grading and feedback. Using the tables and SQL statements from the Module Two Activity Guidelines and Rubric, answer the questions below. Replace the bracketed text with your answers and any supporting screenshots. How many records are shown in the Employee table? [Insert your answer here.] How many attributes are there in the Branches table? [Insert your answer here.] Which attribute could be a primary key for the Employee table? [Insert your answer here.] What is the maximum number of decimal places that can be stored in an employee’s Salary field? [Insert your answer here.] What is the maximum number of decimal places that a Department_ID can have? [Insert your answer here.] What three rules do tables obey? [Insert your answer here.] What is the result of the following query? Select sum( Salary) from Employee where Department_ID =3; [Insert your answer here.] Identify the Employee ID or IDs that would be returned as a result of the following query. Select * from Employee where Classification ! = 'Exempt'; Hint: True Null values will not return in the query. [Insert your answer here.] What is the result of the following query? Select max( Salary) from Employee; [Insert your answer here.]