Class Schedule - Fall 2018

CSE 3330 - 002 Database Systems And File Structures

Lecture Time: Tu Th 5:30PM - 6:50PM - ERB 130

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: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

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 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

General Policies:

Back to previous page