- Instructor: Prof. Sung-Hyuk Cha
- CRN: 22274 & 21333
- Course URL:
http://www.csis.pace.edu/~scha/IT605Su07/index.html
- Meeting:
- Time: Online, Summer I 2007
- Place: Online
- Textbook:
Peter Rob and Carlos Coronel,
Database Systems: Design, Implementation, & Management, 7th edition, thomson Course Technology
- Course Goals:
This course provides an introduction to database concepts, SQL, and web based database design. The major goal is to provide students with an understanding of the basic concepts underlying the use of a database system. A database management system and Perl will be used as a vehicle for illustrating some of the concepts discussed in the course.
- Lecture Notes: can be accessed using the http://blackboard.pace.edu.
Blackboard Login Procedures for Registered Students are available
here
- Schedule:
| Week | Topic |
|---|
| 1 (5/30) | Ch 1 Database Systems &
Ch 2 Data Models |
| 2 (6/7)
| Ch 3 relational Database Model &
Ch 4 ER Modeling
|
| 3 (6/14)
| Ch 7 SQL |
| 4 (6/21)
| Ch 8 Advanced SQL
|
| 5 (6/28)
| Ch 9 Transaction Management & Concurrency control
|
| 6 (7/5)
| font color =
red>Final Exam
|
| | |
- Evaluation:
- Weekly assignments (50%):
- Final Exam (50%):
|