Introduction to Database Design (CS/SE 4347) 
        Time and Location         : TR 5:30-6:45pm  @ ECSS 2.410


 
  

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


 
      
Teaching Assistant
: Ali Inan ( inan at student.utdallas.edu)
Office Hours& Location : Mondays: 7-9pm, Wednesdays: 2:00-4:00 pm@ECSS 3.403



Prerequisites:    CS/SE 3345 
            
 

                                      

Grading:

  •   Homeworks  %15
  •   Project          %15 (Group project (up to 2 people) that requires programming)
  •   Midterm        %35
  •   Final             %35
  •   Participation %5  (Bonus for class participation)

 


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; transaction processing concepts, concurrency, and recovery; security.


          Textbook:
                        

                  Database Management Systems, Ramakrishnan and Gehrke, Third Edition


 Course Outline:

08.16.07   Thursday

08.21.07   Tuesday
08.23.07   Thursday
  • ER Model cont.
08.28.07   Tuesday
  • The Relational Model and SQL DDL (slides)
08.30.07   Thursday
09.04.07   Tuesday
  • Relational Algebra cont.
09.06.07   Thursday
09.11.07   Tuesday
  • SQL cont.
  • Homework one is now available on WebCT
  • Homework one is due 09.25.07 before classNo late submission is accepted!!!
09.13.07   Thursday
  • SQL cont.
  • Project description is now avialable on WebCT
  • 1st  phase deadline is 10.02.07 before class
  • 2nd phase deadline is 10.16.07 before class
  • 3rd  phase deadline is 11.13.07 before class
09.18.07   Tuesday
09.20.07   Thursday
  • Database Application Development (slides)
  • Only PL/SQL and JDBC will be covered...
09.25.07    Tuesday
  • Review of Homework One  
09.27.07   Thursda
  • MIDTERM in the class....
10.02.07   Tuesday
  • Overview of  Storage and Indexing
10.04.07   Thursday
  • Overview of  Storage and Indexing (slides)
10.09.07   Tuesday
  • Tree-Structured Indexing  (slides)
  • Only Sections 10.3--10.7 are covered
10.11.07   Thursday
  • Overview of Query Processing (slides)
  • Homework two is now available on WebCT
  • Homework two is due 10.25.07 before classNo late submission is accepted!!!
10.16.07   Tuesday
  • Overview of Query Processing
10.18.07   Thursday
  • Overview of Query Processing
10.23.07   Tuesday
  • Overview of Transaction Management
10.25.07   Thursday
  • Overview of Transaction Management
10.30.07   Tuesday
  • Concurrency Control (slides)
  • Only Sections 17.1-17.4 will be covered.
11.01.07   Thursday
  • Concurrency Control cont.
  • The slides of the additional example(ppt)
11.06.07   Tuesday
  • Schema Refinement (slides)
  • Sections 19.1-19.6  will be covered.
  • Additional Slides about FDs (slides)
  • Homework three is now available on WebCT
  • Homework three is due 11.20.07 before classNo late submission is accepted!!!
11.08.07   Thursday
  • Schema Refinement cont.
11.13.07   Tuesday
  • Schema Refinement cont.
  • Questions solved in class in .mhtml format
11.15.07   Thursday
11.20.07   Tuesday
  • Review of Homework Two and Three
11.22.07   Thursday
  • No class.  Happy Thanksgiving.
11.29.07   Thursday
  • FINAL Exam in ECSS 2.410 at 5pm