DAD 220 Module Two Activity Guidelines and Rubric Overview Understanding the information shown in tables and the outputs of certain commands are skills necessary for success in data analytics. In

this assignment, you'll practice identifying the parts of a database. You'll also see some of the commands that can be used to show the information and update the tables. Directions The tables below follow a relational data structure. Download the Module Two Activity Template from the What to Submit section, retitle it to include your last name, place your answers in it, and submit it for grading. You'll only answer the 10 questions found below and complete a visual inspection of the data tables and SQL code. This is not a coding exercise. The SQL statements shown here are similar to commands that can be used to generate the same outcomes to those shown in the tables. Employee Table Employee_ID 100 101 First Name Last Name John Smith Mary Jones Department_ID HIN 1 2 Classification Exempt Non-Exempt St Fu Pa 102 103 104 Mary Gwen Michael SQL Statement 1 CREATE TABLE Employee ( Employee_ID SMALLINT, First Name VARCHAR(40), Last Name VARCHAR(60), Department_ID SMALLINT, Classification VARCHAR(10), Status VARCHAR(10), Salary DECIMAL(7,2)); Branches Table Williams Johnson Jones 323 12 Exempt NULL Non-Exempt Fu Fu Fu Department_ID Department_Name Accounting Human Resources Information Systems Marketing 1 2 3 14 SQL Statement 2 CREATE TABLE Branches ( Department_ID SMALLINT, Department_Name VARCHAR(50)); Questions 1. How many records are shown in the Employee table? 2. How many attributes are there in the Branches table? 3. Which attribute could be a primary key for the Employee table? 4. How many decimal places (maximum) can be stored in an employee's salary field? 5. How many decimal places (maximum) can a Department_ID have? 6. What three rules do tables obey? 7. Is the Employee table normalized? How do you know? 8. What is the result of the following query? 1.- Select sum(Salary) from Employee where Department_ID=3; 9. Identify the Employee ID(s) that would be returned as a result of the following query. 10. 1. Select * from Employee where Classification <> 'Exempt'; What is the result of the following query? 1. - Select max(Salary) from Employee; What to Submit Submit your responses in the Module Two Activity Template. All of your answers should go in their respective locations in that document and then be submitted for grading and feedback. Criteria Question 1 Question 2 Question 3 Question 4 Module Two Activity Rubric Proficient (100%) Answers question correctly Answers question correctly Answers question correctly Answers question correctly Not Evident (0%) Does not attempt criterion, or answer is incorrect Does not attempt criterion, or answer is incorrect Does not attempt criterion, or answer is incorrect Does not attempt criterion, or answer is incorrect Criteria Question 5 Question 6 Question 7 Question 8 Question 9 Question 10 Proficient (100%) Answers question correctly Answers question correctly Answers question correctly Answers question correctly Answers question correctly Answers question correctly Not Evident (0%) Does not attempt criterion, or answer is incorrect Does not attempt criterion, or answer is incorrect Does not attempt criterion, or answer is incorrect Does not attempt criterion, or answer is incorrect Does not attempt criterion, or answer is incorrect Does not attempt criterion, or answer is incorrect Total