What This Document Is
This document, labeled “Class Exercise B” for MIS 310 at George Mason University, presents a series of SQL query writing problems. It’s designed as a practical exercise to reinforce understanding of database querying concepts. The exercise focuses on retrieving specific data from tables related to employees, properties, and owners using `SELECT` statements, `WHERE` clauses, subqueries, and `JOIN` operations.
Why This Document Matters
This exercise is intended for students enrolled in the Database Management Systems (MIS 310) course. It serves as a formative assessment to gauge their ability to translate data retrieval requirements into functional SQL code. Successfully completing this exercise is a step towards mastering database interaction skills crucial for information systems professionals.
Common Limitations or Challenges
This document provides practice problems, but does not offer comprehensive explanations of SQL syntax or database design principles. It assumes a foundational understanding of these concepts. It also focuses on a specific database schema (OWNER, EMPLOYEE, PROPERTY_SERVICE, OWNED_PROPERTY) and may not generalize directly to other database structures.
What This Document Provides
The document includes several partially completed SQL queries and their expected results. Specifically, it demonstrates:
* SQL statements to list all columns from specified tables.
* Queries filtering employee data based on experience level.
* Queries using `LIKE` operators for pattern matching in employee names.
* Queries utilizing subqueries to retrieve data based on relationships between tables.
* Queries using `JOIN` operations to combine data from multiple tables.
* Queries calculating aggregate functions (SUM) and grouping results.
This preview *does not* include all possible solutions or detailed explanations for each query. It only shows a selection of the problems and their corresponding outputs.