- Instructor: Prof. Sung-Hyuk Cha
- CRN: 22274 & 21333
- Course URL:
http://www.csis.pace.edu/~scha/IT605Su08
- Meeting:
- Time: Online, Summer I 2008
- 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/28) | Part I: Database Concepts
Ch 1 Database Systems &
Ch 2 Data Models |
| 2 (6/5)
|
Ch 3 relational Database Model &
Ch 4 ER Modeling
|
| 3 (6/12)
|
Ch 5. Normalization of Database Tables
Ch 7. Introduction to Structured Query language (SQL)
|
| 4 (6/19)
|
Ch 8 Advanced SQL
Ch 10. Transaction Management and Concurrency Control
|
| 5 (6/26)
|
Ch 11. Database Performance Tuning and Query Optimization
|
| 6 (7/3)
| Exam
|
| | |
- Evaluation:
- Weekly Reading assignments (quizzes) (30%):
- Weekly Lab assignments (30%):
- Exam (40%):
|