Byerly DAD 220 Module Two Activity (1)

.docx

School

Southern New Hampshire University *

*We aren’t endorsed by this school

Course

220

Subject

Business

Date

Feb 20, 2024

Type

docx

Pages

1

Uploaded by CaptainPencil6470

Report
Professor Venckus Sarah Byerly 04 September 2023 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. 1. How many records are shown in the Employee table? 5 2. How many attributes are there in the Branches table? 8 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? No duplicate rows Columns must have a unique name that clearly descries the culumn. Each cell can only contain one value. 7. Is the Employee table normalized? How do you know? This table is normalized because only a single value is in each cell. 8. What is the result of the following query? Select sum(Salary) from Employee where Department_ID=3; 170,000 9. Identify the Employee ID(s) that would be returned as a result of the following query. Select * from Employee where Classification <> 'Exempt'; 100 and 102 10. What is the result of the following query? Select max(Salary) from Employee; 90,000
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