CS4347 - Database Systems 
 
 Time and Location : Tue/Thr 5:30pm-6:45pm@GR 2.530

 
       Instructor    : Murat Kantarcioglu
        Office Hours & Location  :   Tuesday 4pm to 5pm @ Online or by appointment

 
       Teaching Assistant  :  Saquib Irtiza@ saquib.irtiza@utdallas.edu  

  Prerequisites                   :  CE 3345 or CS 3345 or SE 3345 
 
 

 Grading:

• Homework   % 10 (4 homework, each worth 2.5%)
•   Project         % 30 (Group project (up to 4 people) that requires programming)
•   Midterm       % 30  
•   Final            % 30 (All topics covered included)
•   Class attendance %5 (Bonus)
  

   Course Learning Objectives: 

• Understand Data Modeling
• Understand the Relational Model and theory
• Understand normalization of relations
• Gain a fundamental understanding of SQL programming
• Understand and protect against SQL attacks
• Understand data organization methods, indexing, and query processing
• Understand database integrity and concurrency

Textbook:
Database Management Systems, Ramakrishnan and Gehrke, Third Edition

Course Outline:

Jan. 16, 2024, Tuesday	Cancelled due to weather
Jan. 18, 2024, Thursday	Introduction (slides)
Jan. 23, 2024, Tuesday	ER Model    (slides)
Jan. 25, 2024, Thursday	ER Model Example (slides)
Jan. 30, 2024, Tuesday	The Relational Model and SQL DDL (slides)
Feb. 1, 2024, Thursday	Relational Algebra (slides)
Feb. 6, 2024, Tuesday	Relational Algebra Example (slides)
Feb. 8, 2024, Thursday	SQL (slides)
Feb. 13, 2024, Tuesday	SQL examples (slides) (queries)
Feb. 15, 2024, Thursday	Advanced Sql (slides) (Outer Join Example)
Feb. 20, 2024, Tuesday	Advanced SQL examples (partition() example) With AS query example (1) With AS query example (2)
Feb. 22, 2024, Thursday	Overview of  Storage and Indexing (slides) Parameters of Disks
Feb. 27, 2024, Tuesday	Tree Indexes (slides)
Feb. 29, 2024, Thursday	JDBC and Spring Framework: (slides) (code samples)
Mar. 5, 2024, Tuesday	Midterm review
Mar. 7, 2024, Thursday	MIDTERM
Mar. 12, 2024, Tuesday	SPRING BREAK
Mar. 14, 2024, Thursday	SPRING BREAK
Mar. 19, 2024, Tuesday	External Sorting (slides)
Mar. 21, 2024, Thursday	Evaluation of Join Operations (slides)
Mar. 26, 2024, Tuesday	Evaluation of Other Operations (slides)
Mar. 28, 2024, Thursday	A typical relational optimizer (slides) Additional Reading: A query optimization survey (pdf) An overview of query optimization in oracle (pdf) A detailed discussion of query optimization in oracle (pdf)
Apr. 2, 2024, Tuesday	A typical relational optimizer cont.
Apr. 4, 2024, Thursday	A typical relational optimizer cont.
Apr. 9, 2024, Tuesday	A typical relational optimizer cont.
Apr. 11, 2024, Thursday	Query optimization discussion  (slides)
Apr. 16, 2024, Tuesday	Overview of Transaction Management (slides)
Apr. 18, 2024, Thursday	Schema Refinement (slides)
Apr. 23, 2024, Tuesday	Functional Dependency Examples (slides)
Apr. 25, 2024, Thursday	Security (slides) SQL Injection attacks (slides)
Apr. 30, 2024, Tuesday	Final Exam Review.
May 2, 2024, Thursday	Final Exam during class time.