DAD 220 Module Two Activity - Foxworth PDF

Preview

Summary

DAD220 Assignment: Answer questions based on the information provided in the module. Grade - A...

Description

DAD 220 Module Two Activity

1. How many records are shown in the Employee table? There are five records shown in the Employee table. 2. How many attributes are there in the Branches table? There are two attributes in the Branches table. 3. Which attribute could be a primary key for the Employee table? Employee ID can be a primary key. 4. How many decimal places (maximum) can be stored in an employee’s salary field? A maximum of 2 decimal places. 5. How many decimal places (maximum) can a Department_ID have? Department_ID can only have integers which does not allow for any decimal places. 6. What three rules do tables obey? 1. The tables are normalized which means only one value can exist in each cell. (Winsberg et al, 2019) 2. There cannot be duplicate column names. While the same column name can exist in different tables, it is not allowed in the same table. (Winsberg et al, 2019) 3. There cannot be duplicate rows. “No two rows can have identical values in all columns.” (Winsberg et al, 2019) 7. How do you know that the Employee table is or is not normalized? The Employee table is normalized because exactly one value exists in each cell. Each column has a unique name and is not duplicated. The data listed in each column is of the same type, i.e., the first name column includes text representing a first name for each row. 8. What is the result of the following query? - Select sum(Salary) from Employee where Department_ID=3; The sum of this query is 170,000. 9. How many rows are returned as a result of the following query? - Select * from Employee where Classification 'Exempt'; Three rows are returned as a result of this query. 10. What is the result of the following query? - Select max(Salary) from Employee; The max salary from Employee is 90,000.

Reference:

Winsberg, P. et. al. (2019). zyBooks. ZyBooks. https://learn.zybooks.com/zybook/SNHUDAD220v1/chapter/2/section/2...