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:30 p.m. or by Appointment
----------------------------------------------------------------TA Information:
Name: Arunika Oyshi
E-Mail: arunika.oyshi@mavs.uta.edu
Office Location: ERB 501
Office Hours: Tu & Th 12:30 - 2:00pm or by Appointment
Week | Date | Covered Topics | Related Comments |
---|---|---|---|
1-Th | 08/23 | Syllabus Overview | |
2-Tu | 08/28 | Introduction to Database Systems - Chapter 1 | |
2-Th | 08/30 | Introduction to Database Systems, continued. | |
3-Tu | 09/04 | Database System Concepts and Architecture - Chapter 2 | |
3-Th | 09/06 | The Relational Data Model and Relational Database Constraints - Chapter 3 | Team 1 - Presentation |
4-Tu | 09/11 | Review Chapters 1,2, & 3 Project Description | |
4-Th | 09/13 | Basic SQL - Chapter 4 | Team 2 - Presentation |
5-Tu | 09/18 | More SQL: Complex Queries, Triggers, Views, and Schema Modification - Chapter 5 | Team 3 - Presentation |
5-Th | 09/20 | Review Chapters 4 & 5 | |
6-Tu | 09/25 | The Relational Algebra and Calculus - Chapter 6 | Team 4 - Presentation |
6-Th | 09/27 | Data Modeling Using the Entity-Relationship Model - Chapter 7 | Team 5 - Presentation |
7-Tu | 10/02 | Review Chapters 6 & 7 Prep. Exam 1 | |
7-Th | 10/04 | Exam 1 | |
8-Tu | 10/09 | The Enhanced Entity-Relationship (EER) Model - Chapter 08 | Team 6 - Presentation |
8-Th | 10/11 | Relational Database Design by ER- and EER-to-Relational Mapping - Chapter 09 | Team 7 - Presentation |
9-Tu | 10/16 | Review Chapters 8 & 9 | |
9-Th | 10/18 | Practical Database Design Methodology and Use of UML Diagrams - Chapter 10 | Team 8 - Presentation |
10-Tu | 10/23 | Functional Dependencies and Normalization for Relational Databases - Chapter 15 | Team 9 - Presentation |
10-Th | 10/25 | Review Chapters 10 & 15 | |
11-Tu | 10/30 | Disk Storage, Basic File Structures, and Hashing - Chapter 17 | Project due (Parts 1 & 2)- EXTENDED: Thursday, November 1, 2018 11:59p.m. Team 10 - Presentation |
11-Th | 11/01 | Indexing Structures for Files - Chapter 18 | Team 11 - Presentation |
12-Tu | 11/06 | Review Chapters 17 & 18 | |
12-Th | 11/08 | Exam 2 | |
13-Tu | 11/13 | Introduction to Transaction Processing Concepts and Theory - Chapter 21 | Team 12 - Presentation |
13-Th | 11/15 | Introduction to Transaction Processing Concepts and Theory, continued. | |
14-Tu | 11/20 | Concurrency Control Techniques - Chapter 22 | Team 13 - Presentation |
14-Th | 11/22 | Thanksgiving holiday | No Class |
15-Tu | 11/27 | Concurrency Control Techniques, continued. | Project due (Part 3) |
15-Th | 11/29 | Database Recovery Techniques - Chapter 23 | Team 14 - Presentation |
16-Tu | 12/04 | Exam 3 |
Topic Covered | # of Lectures |
---|---|
Syllabus | n/a |
Introduction to Database Systems - Chapter 1 | n/a |
Databases and Database Users - Chapter 1 | n/a |
Database System Concepts and Architecture - Chapter 2 | n/a |
The Relational Data Model and Relational Database Constraints - Chapter 3 | n/a |
Basic SQL - Chapter 4 | n/a |
More SQL: Complex Queries, Triggers, Views, and Schema Modification - Chapter 5 | n/a |
The Relational Algebra and Calculus - Chapter 6 | n/a |
Data Modeling Using the Entity-Relationship Model - Chapter 7 | n/a |
The Enhanced Entity-Relationship (EER) Model - Chapter 8 | n/a |
Relational Database Design by ER- and EER-to-Relational Mapping - Chapter 9 | n/a |
Practical Database Design Methodology and Use of UML Diagrams - Chapter 10 | n/a |
Functional Dependencies and Normalization for Relational Databases - Chapter 15 | 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 |