Introduction to Database Design (CS 6360) 
        Time and Location         : TR 5:30-6:45pm  Room: ECSS 2.305

 

 
       Instructor                        : Murat Kantarcioglu
Office Hours & Location : Tuedays: 3-4pm, Wednesday 5:30-6:30pm
@ECSS 3.225

      
Teaching Assistant
: Ali Inan (inan @ student.utdallas.edu)
Office Hours& Location : Mondays: 3PM-5PM @ ECSS 3.403



Prerequisites: 
            CS 5343
                                       

Grading:

  •   Homeworks %15
  •   Project         %15 (Group project (up to 2 people) that requires programming)
  •   Midterm       %35
  •   Final            %35

 

Course Topics: (tentative)

Methods, principles, and concepts that are relevant to the practice of database
software design. Database system architecture; conceptual database
models; relational and object-oriented databases; database system
implementation; query processing and optimization; transaction
processing concepts, concurrency, and recovery; security.

          Textbook:
                        

                  Database Management Systems, Ramakrishnan and Gehrke, Third Edition

 Course Outline:

01.09.07   Tuesday

01.11.07   Thursday
  • The Relational Model and SQL DDL (slides)
01.16.07   Tuesday
  • The Relational Model and SQL DDL
  • Relational Algebra (slides)
01.18.07   Thursday
  • Relational Algebra cont.
01.23.07   Tuesday
  • Relational Algebra cont.
01.25.07   Thursday
01.30.07   Tuesday
  • SQL cont.
02.01.07   Thursday
  • SQL cont.
02.06.07   Tuesday
  • Database Application Development (slides)
02.08.07   Thursday
  • Course TA, Ali Inan, will give a short presentation about Oracle Accounts
  • Homework 1 (pdf) is due 02.22.07
  • Project  Description (pdf) is out. First phase is due 03.01.07
02.13.07   Tuesday
  • Overview of  Storage and Indexing (slides)
02.15.07   Thursday
  • Overview of  Storage and Indexing cont.
02.20.07   Tuesday
02.22.07   Thursday
  • Evaluation of Join Operations (slides)
02.27.07   Tuesday
  • MIDTERM
03.01.07   Thursday
  • Evaluation of Other Operations (slides)
03.06.07   Tuesday
  • SPRING BREAK
03.08.07   Thursday
  • SPRING BREAK
03.13.07   Tuesday
  • A typical relational optimizer (slides)
03.15.07   Thursday
  • A typical relational optimizer cont.
  • Homework Two (pdf) is due 03.29.07
03.20.07   Tuesday
03.22.07   Thursday
  • Concurrency Control cont.
03.27.07   Tuesday
  • Concurrency Control cont.
  • The slides of the additional example(ppt)
03.29.07   Thursday
04.03.07   Tuesday
  • Crash Recovery cont.
04.05.07   Thursday
  • Schema Refinement (slides)
  • Homework Three (pdf) is due 04.19.07 before class.
04.10.07   Tuesday
04.12.07   Thursday
04.17.07   Tuesday
  • Review of the HW2
04.19.07   Thursday
  • Review of the HW3
04.26.07   Thursday         !!! FINAL AT 5PM at ECSS 3.225 !!!