Mid Term Exam
Tuesday, July 5th, 6:00pm - 9:00pm, SB204
The exam will be designed to take 60-90 minutes to complete. However, you will have the entire class period available if needed. Questions will be both multiple-choice and full text questions. Most of the topics have been covered in homework assignments 1 and 2.
- The relational model
- Schemata and Instances
- Integrity Constraints
- Relational algebra:
- Write relational algebra expressions
- Translate SQL into relational algebra
- SQL: Write SQL statements and evaluate them
- Write DDL commands to create new tables
- Write SQL queries or evaluate them
- Write SQL inserts, updates, and delete
- Relational Database Design and the Entity-Relationship model
- Design an ER model for a given application domain
Final Exam
Thursday, July 28th, 6:00pm - 9:00pm, SB204
The exam will be designed to take 90 minutes to complete. However, you will have the entire class period available if needed. Questions will be both multiple-choice and full answer questions.
- Relational algebra:
- Write relational algebra expressions
- SQL: Write SQL statements and evaluate them
- Write DDL commands to create new tables
- Write DDL commands to create new indexes
- Understand the benefits of indexes and when a database would use them
- Write SQL queries or evaluate them
- Write SQL inserts, updates, and delete
- Normalization
- Determine if a table is in 3rd normal form
- Locking
- Understand the different types of locks
- Understand two-phase locking
- Miscellaneous
- Understand general architecture of shared-everything and shared-nothing distributed databases
- Understand the pros/cons of column-oriented tables