BDAN 330 Structured Data Analysis
Final Exam
Page 1
Dr. Kirk Atkinson
This final exam is intended to be a “hands–on experience”. I expect all students to do their own work. By
completing this exam and submitting your Word document with screen shots, you are agreeing to the
student ethics guidelines as established within the college.
Good luck! Ensure that you include enough information in your screen shots to sufficiently answer the
questions. This means displaying the Schemas, SQL code window, the result grid, and the Action
Output panes! Ensure that all screen shots are placed with the numbered step and are legible!!!
Assume at least one screenshot PER STEP!
1. List all rows from the employees table with limit set to 50000. How long did it take?
BDAN 330 Structured Data Analysis
Final Exam
Page 2
Dr. Kirk Atkinson
2. -List all rows from the employees table with limit set to none. How long did it take? (leave set at
NO LIMIT for the balance of the exam)
BDAN 330 Structured Data Analysis
Final Exam
Page 3
Dr. Kirk Atkinson
3. List all female department heads; include dept_no, emp_no, first_name, last_name, hire_date,
order by dept_no. Be sure to display the number of rows returned in your screen shot!
BDAN 330 Structured Data Analysis
Final Exam
Page 4
Dr. Kirk Atkinson
4. List all male employees whose salary is less than or equal to 55000.
BDAN 330 Structured Data Analysis
Final Exam
Page 5
Dr. Kirk Atkinson
5. List all female employees whose CURRENT salary is >= 55000; include their title.
BDAN 330 Structured Data Analysis
Final Exam
Page 6
Dr. Kirk Atkinson
6. List all female employees whose current salary is between 55000 and 75000.
BDAN 330 Structured Data Analysis
Final Exam
