Instructor: Ali Sharifara
E-Mail: ali.sharifara@uta.edu
Website: https://heracleia.uta.edu/~sharifara
Office Location: ERB 321, CSE@UTA
Office Hours: Mo & We 4:00-5:30pm or by Appointment
----------------------------------------------------------------TA Information:
Name: Tariq Alsahfi
E-Mail: tariq.alsahfi@mavs.uta.edu
Office Location: ERB 560, CSE@UTA
Office Hours: Mo & We: 11:00am-12:30pm or by Appointment
Week | Date | Covered Topics | Related Comments |
---|---|---|---|
1-We | 01/17 | Syllabus Overview | |
2-Mo | 01/22 | Introduction to Database Systems - Chapter 1 | |
2-We | 01/24 | Cont. Introduction to Database Systems - Chapter 1 | |
3-Mo | 01/29 | Database System Concepts and Architecture - Chapter 2 | |
3-We | 01/31 | The Relational Data Model and Relational Database Constraints - Chapter 03 | Team 5 - Presentation |
4-Mo | 02/05 | Review Chapters 1,2, and 3 Review Project Description | |
4-We | 02/07 | Basic SQL - Chapter 04 | Team 1 - Presentation |
5-Mo | 02/12 | More SQL: Complex Queries, Triggers, Views, and Schema Modification - Chapter 05 | Team 2 - Presentation |
5-We | 02/14 | Review Chapters 4,5 | |
6-Mo | 02/19 | The Relational Algebra and Calculus - Chapter 06 | Team 11 - Presentation |
6-We | 02/21 | Data Modeling Using the Entity-Relationship Model - Chapter 07 | Team 3 - Presentation |
7-Mo | 02/26 | Review Chapters 6,7 Prep. Exam 1 | |
7-We | 02/28 | Exam 1 | |
8-Mo | 03/05 | The Enhanced Entity-Relationship (EER) Model - Chapter 08 | Team 14 - Presentation |
8-We | 03/07 | Relational Database Design by ER- and EER-to-Relational Mapping - Chapter 09 | |
9-Mo | 03/12 | Spring Vacation | No Class |
9-We | 03/14 | Spring Vacation | No Class |
10-Mo | 03/19 | Practical Database Design Methodology and Use of UML Diagrams - Chapter 10 | Team 9 - Presentation |
10-We | 03/21 | Disk Storage, Basic File Structures, and Hashing - Chapter 17 | Team 7 - Presentation |
11-Mo | 03/26 | Review Chapters 10,17 | Project due date (Parts 1, 2) |
11-We | 03/28 | Indexing Structures for Files - Chapter 18 | Team 6 - Presentation |
12-Mo | 04/02 | Review Chapter 18 Pre. Exam 2 | |
12-We | 04/04 | Exam 2 | |
13-Mo | 04/09 | Introduction to Transaction Processing Concepts and Theory - Chapter 21 | Team 12 - Presentation |
13-We | 04/11 | Introduction to Transaction Processing Concepts and Theory, continued. | |
14-Mo | 04/16 | Concurrency Control Techniques - Chapter 22 | Team 10 - Presentation |
14-We | 04/18 | Concurrency Control Techniques, continued. | Project due (Part 3)EXTENDED: Sunday, April 22, 2018 11:59:59pm |
15-Mo | 04/23 | Database Recovery Techniques - Chapter 23 | Team 4 - Presentation |
15-We | 04/25 | Review Chapters 22, 23 | |
16-Mo | 04/30 | Functional Dependencies and Normalization for Relational Databases - Chapter 15 | Team 13 - Presentation |
16-We | 05/02 | Prep. Final Exam - Last day of class | University Schedule |
17-Mo | 05/07 | No Class | University Schedule |
17-We | 05/09 | Final Exam - 2:30 p.m. | University Schedule |
Topic Covered | # of Lectures |
---|---|
Syllabus | n/a |
Introduction to Database Systems - Chapter 01 | n/a |
Databases and Database Users - Chapter 01 | n/a |
Database System Concepts and Architecture - Chapter 02 | n/a |
The Relational Data Model and Relational Database Constraints - Chapter 03 | n/a |
Basic SQL - Chapter 04 | n/a |
More SQL: Complex Queries, Triggers, Views, and Schema Modification - Chapter 05 | n/a |
The Relational Algebra and Calculus - Chapter 06 | n/a |
Data Modeling Using the Entity-Relationship Model - Chapter 07 | n/a |
The Enhanced Entity-Relationship (EER) Model - Chapter 08 | n/a |
Relational Database Design by ER- and EER-to-Relational Mapping - Chapter 09 | n/a |
Practical Database Design Methodology and Use of UML Diagrams - Chapter 10 | n/a |
Disk Storage, Basic File Structures, and Hashing - Chapter 17 | n/a |
Indexing Structures for Files - Chapter 18 | n/a |
Introduction to Transaction Processing Concepts and Theory - Chapter 21 | n/a |
Concurrency Control Techniques - Chapter 22 | n/a |
Database Recovery Techniques - Chapter 23 | n/a |
Database Security and Authorization - Chapter 24 | n/a |
Functional Dependencies and Normalization for Relational Databases - Chapter 15 | n/a |