CSCI 3360 Database Systems
Fall, 2009 1:00 pm - 1:50 pm M/W/F MCSI 338
| Office Hour: | 10:00 am- 1:00 pm Monday, Wednesday, Friday and 2:00 pm-3:00 pm, Monday, Wednesday (by appointments) |
| Office: |
MCSI 304 |
| E-Mail: | bchen [at] uca [dot] edu (You MUST 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
Final Project due on 12/2
Class Slides
Aug 24: Ch1 Introduction
Aug 26: Ch2 Database Systems Concepts and Architecture
Aug 28: Ch3 ER Model
Aug 31: Ch3 ER Model Part2
Sep 2: Ch3 ER Model Part2
Sep 4: Ch4 EER Model
Sep 9: Ch4 EER Model
Sep 14: Ch4 Project Presentation EER Model
Sep 16: Ch4 EER Model
Sep 18: EER Model Case Study
Sep 21: Exam1 Review Quiz2
Sep 23: Exam1
Sep 25: Relational Model Concepts
Sep 28: Relational Model Concepts
Sep 30: Relational Model Concepts Quiz3
Oct 2: Relational Database Design by ER- and EER- to relational Mapping
Oct 7: Relational Database Design by ER- and EER- to relational Mapping
Oct 9: Oracle DDL
Oct 12: Oracle DDL
Oct 14: Oracle DDL
Oct 16: Fall Break ^^ (Not any more T_T)
Oct 19: Oracle DDL Example
Oct 21: Exam2 Review Quiz4
Oct 23: Exam2
Oct 26: Project Presentation
Oct 28: Relational Algebra
Oct 30: Relational Algebra
Nov 2: Relational Algebra
Nov 4: Relational Algebra
Nov 6: Relational Algebra
Nov 9: Relational Algebra part2
Nov 11: Relational Algebra part2
Nov 13: DML
Nov 16: DML Quiz5 part1 part2 Lab example
Nov 18: DML part2
Nov 20: DML part3
Nov 23: DML part4
Nov 30: Final Review
Dec 2: Final Project Presentation
Assignments:
