dwqwdlqkdmqwkldnqwkldnwkdnwqdldkwd
Solutions To Workshop Exercises

Chapter 1: SQL and Data 4
Chapter 2: SQL: The Basics 13
Chapter 3: The WHERE and ORDER BY Clauses 20
Chapter 4: Character, Number, and Miscellaneous Functions 27
Chapter 5: Date and Conversion Functions 42
Chapter 6: Aggregate Functions, GROUP BY and HAVING 57
Chapter 7: Equijoins 73
Chapter 8: Subqueries 108
Chapter 9: Set Operators 126
Chapter 10: Complex Joins 137
Chapter 11: Insert, Update, and Delete 164
Chapter 12: Create, Alter, and Drop Tables 178
Chapter 13: Indexes, Sequences, and Views 188
Chapter 14: The Data Dictionary, Scripting, and Reporting 197
Chapter 15: Security 213
Chapter 16: Regular Expressions and Hierarchical Queries 222
Chapter 17: Exploring Data Warehousing Features 235
Chapter 18: SQL Optimization 248 Chapter 1: SQL and Data
In this chapter, you learned about data, how data is organized in tables, and how the relationships among the tables are depicted in a schema diagram. Based on your newly acquired knowledge, design a schema diagram based on the fictional ACME Construction Company. Draw on your own work experience to design the following components.

1. Draw boxes for these three tables: EMPLOYEE, POSITION, and DEPARTMENT.

Solution: See the solution for Exercise 3.

2. Create at least three columns for each of the tables and designate a primary key for each table.

Solution: See the solution for Exercise 3.

3. Create relationships among the tables that make sense to you. At least one table should have a self-referencing relationship. Hint: Be sure to include the necessary foreign key columns.

Solution: 4. Think about which columns should not allow NULL values.
Solution: By definition all the primary key columns do not allow null values. In the DEPARTMENT table the DEPARTMENT_NAME column should probably not allow null