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.]