Tentative Class Schedule

CSE 5330 - 002 Database Systems

Lecture Time: Mo We 2:30PM - 3:50PM - WH 210

Textbook: Fundamentals of Database Systems, Sixth Edition, by Elmasri/Navathe, published by Addison-Wesley, 2012.

Note: Some sections of certain chapters may be omitted or modified as the course progresses. The lists of excluded sections will be specified during lectures, if any. Lecture material and due dates may be adjusted.

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

Grading Policy:

Make-up Exams: No make-up exam will be given.

Grading Distribution:

A >= 90%, B >= 80%, C >= 70%, D >= 60%, F < 60%

Syllabus (Tentative)

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

General Policies:

Back to previous page