DAD 220 Module Two Activity Template
Using the tables and SQL statements from the prompt for Module Two Activity, answer the following questions. Replace the bracketed text with your answers and any supporting screenshots.
•
How many records are shown in the Employee table?
[In the Employee table, five records are displayed.]
•
How many attributes are there in the Branches table?
[The Branches table has two properties.]
•
Which attribute could be a primary key for the Employee table?
[A primary key may be the employee ID.]
•
How many decimal places (maximum) can be stored in an employee’s salary field?
[There are two decimal places.]
•
How many decimal places (maximum) can a Department_ID have?
[Department_ID can not support decimal places and can only include integers.]
•
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)]
•
Is the Employee table normalized? How do you know?
[Since each cell in the Employee table contains precisely one value, the table is normalized. Every column
is distinct and does not contain duplicates. Every column has identical data; for example, the first name
column contains text that corresponds to a first name for every row.]
•
What is the result of the following query? •
Select sum(Salary) from Employee where Department_ID=3;
[This query has a total of 170,000.]
•
Identify the Employee ID(s) that would be returned as a result of the following query. •
Select * from Employee where Classification <> 'Exempt';
[This query yields three rows in response.]
•
What is the result of the following query? •
Select max(Salary) from Employee;
[Employees are paid a maximum of 90,000.]
