DAD220 2-3 Updating Tables and SQL Identification PDF

Preview

Summary

DAD220 week 2 activitly 3 updating tables and SQL Identification...

Description

DAD220 Southern New Hampshire University Alexander Frederick 8/30/2021

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? 5

2. How many attributes are there in the Branches table? 2 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? 2

5. How many decimal places (maximum) can a Department_ID have? 0

6. What three rules do tables obey? There are Three Rules 1. Tables are Normalized 2. No duplicate column names 3. No duplicate rows 7. How do you know that the Employee table is or is not normalized? We know it is normalized because there is only one value in each cell.

8. What is the result of the following query? - Select sum(Salary) from Employee where Department_ID=3; 170,000

9. How many rows are returned as a result of the following query? - Select * from Employee where Classification 'Exempt'; 2 rows are returned as a result of the query. 10. What is the result of the following query? - Select max(Salary) from Employee; 90000...