Class Schedule - Fall 2017

CSE 3330 - 002 Database Systems And File Structures

Lecture Time: Tu Th 5:30PM - 6:50PM - GS 104

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

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 n/a

General Policies:

Back to previous page