Instructor: Ali Sharifara
E-Mail: ali.sharifara@uta.edu
Website: https://heracleia.uta.edu/~sharifara
Office Location: ERB 321, CSE@UTA
Office Hours: Wednesday 2:00 - 3:45 p.m. or by Appointment
----------------------------------------------------------------TA Information:
Name: Arunika Oyshi
E-Mail: arunika.oyshi@mavs.uta.edu
Office Location: ERB 501
Office Hours: Tue/Thu 3:30-5:00 p.m.
Week | Date | Covered Topics | Related Comments |
---|---|---|---|
1 | 01/16 | Syllabus Course Overview Introduction to Database Systems | Ch1 |
2 | 01/23 | Introduction to Database Systems- continued. | Ch1 |
3 | 01/30 | Database System Concepts and Architecture | Ch2 |
4 | 02/06 | The Relational Data Model and Relational Database Constraints | Ch3 Project Description |
5 | 02/13 | SQL | Ch4 |
6 | 02/20 | More SQL: Complex Queries, Triggers, Views, and Schema Modification | Ch5 |
7 | 02/27 | Relational Algebra Entity-Relationship Model | Ch6 |
8 | 03/06 | Entity-Relationship Model -continued. | Ch7 |
9 | 03/13 | Spring Break | |
10 | 03/20 | Midterm Exam | |
11 | 03/27 | The Enhanced Entity-Relationship (EER) Model | Ch8 |
12 | 04/03 | Relational Database Design (ER- and EER-to-Relational Mapping) | Ch9 Project due (Parts 1 & 2)- EXTENDED: Wednesday, April 10, 2019 11:59pm. |
13 | 04/10 | Normalization for Relational Databasess | Ch15 |
14 | 04/17 | Disk Storage, Basic File Structures, and Hashing | Ch17 |
15 | 04/24 | Indexing Structures for Files | Ch18 |
16 | 05/01 | Final Exam | Project due (Part 3) - On the same day of demo session May, 2nd & May, 3rd - Demo sessions for projects. |
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 |
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 |