Class Schedule - Spring 2019

CSE 3330 - 001 Database Systems And File Structures

Lecture Time: Wednesday, 4:00PM- 6:50PM - PKH 111

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

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

General Policies:

Back to previous page