Dr. Orest Pilskalns
CS451 - Database Systems
Fall 2006

 

Announcements:

   
    Final Grades! Click Here

Power Point Slides:


       Chapter 1
       Chapter 2
       Chapter 3
       Chapter 5
       Chapter 6
       Chapter 7
       Chapter 8
       Chapter 10

      
 Chapter 11
       
Chapter 26

Important Links:

       1. MySql Database
       2. Assignment Submission Site

 

Examples, Papers, and Supplemental Documents:

       
Midterm Review!
       
Peer Review Form

Teams:

        Team1
        Team2
        Team3
        COMPOSITE ER v1 , FDs   
       
COMPOSITE ER v2, changes


Homework:

       Assignment 1:  Due Wednesday 9/6/06
              
1.3
               1.9 (give at least one example (not the one in the book))
               1.12 (give two examples)
               1.13 (give two examples and explain why)
               1.14

In addition, look at 1.1 to review the terminology.  Do not turn in 1.1 but make sure you know all the terms.

        Assignment 2:  Due Monday 9/18/06
              
3.16
               3.19
               3.23
               3.27 (explain your reasoning as well)

        Assignment 3: Due Monday 10/2/06
              
5.11
               5.14
               5.15
               5.20

        Assignment 4: Due Monday 10/16/06
               
6.16 (10 points)
                6.22 (6 points)
                6.24 (7 points)
                6.30 (8 points)
                6.32 (3 points)

       
Assignment 5: Due Friday 11/10/06
        Assignment 6: Due Friday 12/01/06              
       
Assignment 7: Due Monday 12/11/06
Exams:
       

        Midterm: October 30, 2006
        Final: December 11, 2006, 1:00 - 3:00 (ELS 104)

Other Documents:

        Syllabus