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