DAD 220 Module Two Activity Template

.docx

School

Southern New Hampshire University *

*We aren’t endorsed by this school

Course

220

Subject

Chemistry

Date

Apr 3, 2024

Type

docx

Pages

2

Uploaded by AgentJackalPerson922 on coursehero.com

DAD 220 Module Two Activity Template Guardado Download this template and rename the file to include your last name. Remove these instructions before submitting the completed document for grading. Replace the bracketed text in this template with your answers and any supporting screenshots. Then submit the completed template for grading and feedback. Using the tables and SQL statements from the Module Two Activity Guidelines and Rubric, answer the questions below. Replace the bracketed text with your answers and any supporting screenshots. 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. What is the maximum number of decimal places that can be stored in an employee’s Salary field? 2 5. What is the maximum number of decimal places that a Department_ID can have? 0 6. What three rules do tables obey? They are normalized. there are no duplicate column names within the same table. There are no duplicate rows within the same table. 7. What is the result of the following query? a. Select sum(Salary) from Employee where Department_ID=3; 170000.00 (80000+90000) 8. Identify the Employee ID or IDs that would be returned as a result of the following query. a. Select * from Employee where Classification != 'Exempt'; i. Hint: True Null values will not return in the query.
ID100 and ID102 9. What is the result of the following query? a. Select max(Salary) from Employee; 90000
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help