DAD 220 2-3 Updating tables and SQL Identification PDF

Preview

Summary

Codio assignment that builds up for final assignment...

Description

DAD 220 Module Two Activity Template Brandi Rose November 2020 MOD 2 2-3: Updating Tables and SQL Identification Using the tables and SQL statements from the prompt for Module Two Activity, answer the following questions. Replace the bracketed text with your answers. 1. How many records are shown in the Employee table? [Five] 2. How many attributes are there in the Branches table? [Two] 3. Which attribute could be a primary key for the Employee table? [Employee ID] 4. How many decimal places (maximum) can be stored in an employee’s salary field? [Two, by the DECIMAL(7,2)] 5. How many decimal places (maximum) can a Department_ID have? [Insert your answer here] 6. What three rules do tables obey? [One value in each cell only Duplicate column names not allowed on one table No two rows can have same values in all columns] 7. How do you know that the Employee table is or is not normalized? [Normalized, there is value that is in cell only] 8. What is the result of the following query? - Select sum(Salary) from Employee where Department_ID=3; [80000+90000=170000] 9. How many rows are returned as a result of the following query? - Select * from Employee where Classification 'Exempt'; [Two] 10. What is the result of the following query? - Select max(Salary) from Employee; [90000, that is the highest on the table]...