Takes Place: Apr 2, 2019

The midterm quiz will take place at the beginning of class on Tue Apr 2nd. Make sure to arrive on time for class.

The quiz is worth 10 points (each question is worth 1 point) and will consist of two parts:

Part I – Definitions

Of these 7 terms, 5 will appear on the quiz. You will choose 3 to define in 4-6 complete sentences. Your answers must address the primary meaning of the terms, with some supporting details. You may not bring any notes (test is closed-book). Look at these example definitions to see what a full, partial, and no credit answer would look like.

• Data type
• Geometry type
• Normalization
• Primary key
• Schema
• Spatial Reference System
• View

Part II – SQL

You will be given print outs of 2 sample tables. There will be 7 questions where you are asked to write a SQL statement based on these tables. The material in this part covers just the fundamentals from classes 2 & 3, except there will be 1 question about adding geometry columns. Your statements must follow the standard SQL style guidelines.

You will be given a SQL reference sheet (this sheet here) that you can refer to throughout the test, but some questions may include material that is not on the sheet.