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: Neha Nilcant Shet
E-Mail: nehanilcant.shet@mavs.uta.edu
Office Location: ERB 501, CSE@UTA
Office Hours: Mo & We 10:00 a.m. - 11:30 a.m. or by Appointment
Week | Date | Covered Topics | Related Comments |
---|---|---|---|
1-Tu | 08/22 | n/a | n/a |
1-Th | 08/24 | Overview Syllabus | n/a |
2-Tu | 08/29 | Introduction to Database Systems - Chapter 1 | n/a |
2-Th | 08/31 | Cont. Introduction to Database Systems - Chapter 1 | n/a |
3-Tu | 09/05 | Database System Concepts and Architecture - Chapter 2 | n/a |
3-Th | 09/07 | The Relational Data Model and Relational Database Constraints - Chapter 03 | Team 1 - Presentation |
4-Tu | 09/12 | Review Chapters 1,2, and 3 Review Project Description | Exercise |
4-Th | 09/14 | Basic SQL - Chapter 04 | Team 2 - Presentation |
5-Tu | 09/19 | More SQL: Complex Queries, Triggers, Views, and Schema Modification - Chapter 05 | Team 11 - Presentation |
5-Th | 09/21 | Review Chapters 4,5 | Exercise |
6-Tu | 09/26 | The Relational Algebra and Calculus - Chapter 06 | Team 6 - Presentation |
6-Th | 09/28 | Data Modeling Using the Entity-Relationship Model - Chapter 07 | Team 8 - Presentation |
7-Tu | 10/03 | Review Chapters 6,7 | n/a |
7-Th | 10/05 | The Enhanced Entity-Relationship (EER) Model - Chapter 08 | Team 3 - Presentation |
8-Tu | 10/10 | Relational Database Design by ER- and EER-to-Relational Mapping - Chapter 09 | Team 9 - Presentation |
8-Th | 10/12 | Prep. Midterm Exam | n/a |
9-Tu | 10/17 | Midterm Exam | n/a |
9-Th | 10/19 | Review Chapters 8,9 | n/a |
10-Tu | 10/24 | Practical Database Design Methodology and Use of UML Diagrams - Chapter 10 | Team 15 - Presentation |
10-Th | 10/26 | Disk Storage, Basic File Structures, and Hashing - Chapter 17 | Team 5 - Presentation |
11-Tu | 10/31 | Review Chapters 10,17 | Project due date (Parts 1, 2) |
11-Th | 11/02 | Indexing Structures for Files - Chapter 18 | Team 13 - Presentation |
12-Tu | 11/07 | Introduction to Transaction Processing Concepts and Theory - Chapter 21 | Team 14 - Presentation |
12-Th | 11/09 | Review Chapters 18, 21 | n/a |
13-Tu | 11/14 | Concurrency Control Techniques - Chapter 22 | Team 12 - Presentation |
13-Th | 11/16 | Concurrency Control Techniques, continued. | n/a |
14-Tu | 11/21 | Database Recovery Techniques - Chapter 23 | Project due- EXTENDED: November 26, 2017 11:59:59 PM. Team 4 - Presentation |
14-Th | 11/23 | Thanksgiving holidays - No Class | Public holiday |
15-Tu | 11/28 | Review Chapters 22, 23 Database Security and Authorization - Chapter 24 | Team 7 - Presentation |
15-Th | 11/30 | Functional Dependencies and Normalization for Relational Databases | Team 10 - Presentation |
16-Tu | 12/05 | Prep. Final Exam - Last day of class. | n/a |
16-Th | 12/07 | No Class | University Schedule |
17-Tu | 12/12 | Final Exam - Time : 5:30 - 8:00 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 | n/a |