DAD 220 Module Two Activity Template

docx

School

Southern New Hampshire University *

*We aren’t endorsed by this school

Course

220

Subject

Chemistry

Date

Feb 20, 2024

Type

docx

Pages

1

Uploaded by Mastersteel03

Report
DAD 220 Module Two Activity Template Replace the bracketed text in this template with your answers and any supporting screenshots. Then submit it for the Module Two table and SQL identification activity. You’ll need to download this template, save it as a unique file, and then submit it for grading. Rename this document to include your last name and remove these instructions before submitting. 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. 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. 5. How many decimal places (maximum) can a Department_ID have? One. 6. What three rules do tables obey? One value allowed in each cell; duplicate column names not allowed in one table. No two rows may have the same values. 7. Is the Employee table normalized? How do you know? Yes, it is normalized due to the fact that the value in that cell only. 8. What is the result of the following query? Select sum(Salary) from Employee where Department_ID=3; 80000+90000= 1700000 9. Identify the Employee ID(s) that would be 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; 9000
Discover more documents: Sign up today!
Unlock a world of knowledge! Explore tailored content for a richer learning experience. Here's what you'll get:
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help