CSCI 3360 Database Systems

Fall, 2008 9:00 am - 9:50 am M/W/F MCSI

 

Office Hour:  M/W/F 11:00 am - 2:00 pm by appointments
Office:

 MCSI 304

E-Mail:  bchen3[at]cs.gsu.edu  (Remember to put CSCI3360 in Subject)
Textbooks:

Fundamentals of Database Systems 5th edition, Ramez Elmasri and Shamkant B. Navathe, Addison-Wesley, 2006.

Prerequire:  CSCI 2320 DATA STRUCTURES

Announcement  

Project 4  Due Dec 3

DEC 3rd Start class at 8:30

Final Exam is an open book exam on Dec 8th at 2pm

 

 

Class Slides

Aug 22:  Syllabus

Aug 25:  Ch. 1 Database and Database Users

Aug 27:  Ch. 2 Database System Concepts and Architecture

Aug 29:  Ch. 3 ER Model

Sep 1:    No Class (Labor Day)

Sep 3:    Ch. 3 ER Model

Sep 5:    Ch. 3 ER Model

Sep 8:    Ch. 3 ER Model

Sep 10:  Ch. 3 ER Model part 2   Quiz1

Sep 12:  Ch. 4 EER Model

Sep 15:  Ch. 4 EER Model

Sep 17:  Ch. 4 EER MODEL Case Study

Sep 19:  Project 1 Presentation

Sep 22:  Exam1 Review

Sep 24:  First Exam

Sep 26:  First Exam

Sep 29:  Ch 5. The Relational Data Model and Relational Database Constrains

Oct 1:  Ch 5. The Relational Data Model and Relational Database Constrains

Oct 3:  Oracle DDL

Oct 6:  Oracle DDL

Oct 8:  Oracle DDL      LAB

Oct 10:  Quiz2

Oct 13:  Ch 7. Relational Database Design by ER and EER-to-Relational Mapping

Oct 15:  Ch 7. Relational Database Design by ER and EER-to-Relational Mapping

Oct 17:  No Class (Fall Break)

Oct 20:  Project 3 Group Discussion

Oct 22:  Quiz 3

Oct 24:  Ch 6. The Relational Algebra

Oct 27:  No Class

Oct 29:  Ch 6. The Relational Algebra

Oct 31:  Review Exam2

Nov 3:   No class (Study Exam2)

Nov 5:   Exam 2

Nov 7:   Exam 2

Nov 10: Ch 6. The Relational Algebra

Nov 12: Ch 6. The Relational Algebra Part 2

Nov 14: Ch 6. The Relational Algebra Part 2

Nov 17: Ch 6. The Relational Algebra Part 2

Nov 19: Working with Tables  Example

Nov 21: Working with Tables  Quiz 4

Nov 24: Working with Tables Part 2

Dec 1:   Final Exam Review

Dec 3:   Project Presentation (Class Start at 8:30am)

 

 

Assignments:

Project 1  Due Sep 17

Project 2  Due Sep 24

Project 3  Due Oct 22

Project 4  Due Dec 3