- Instructor: Prof. Sung-Hyuk Cha
- CRN: 73169 & 71239
- Course URL:
http://www.csis.pace.edu/~scha/IT605F06/index.html
- Meeting:
- Time: Tuesday 6:00 pm - 8:45 pm, Fall 2006
- Place: Graduate Center, GC430
- Textbook:
Peter Rob and Carlos Coronel,
Database Systems: Design, Implementation, and Management, 7th edition, thomson Course Technology, 2007
- 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 (9/12) | Ch 1 Database Systems |
| 2 (9/19) | Ch 2 Data Models |
| 3 (9/26)
| 3 relational Database Model
|
| 4 (10/3)
| Ch 4 ER Modeling
Ch 5 Normalization of Database Tables
|
| 5 (10/10)
| Ch 4 ER Modeling
|
| 6 (2/27)
| Ch 5 Normalization of Database Tables
|
| 7 (10/17)
| Review
|
| 8 (10/24)
| Midterm
|
| 9 (10/31)
| Ch 6 SQL
|
| 10 (11/7)
| Ch 6 SQL
|
| 11 (11/14)
| Ch 7 Advanced SQL
|
| 12 (11/21)
| Ch 9 Transaction Management & Concurrency control
|
| 13 (11/28)
| Ch 12 The data warehouse
|
| 14 (12/5)
| Ch 13 Databases in Electronic Commerce
|
| 15 (12/12)
| Final Exam
|
| | |
- Evaluation:
- Online Quizzes (10%): There will be five quizzes.
- Midterm Exam (30%):
- Final Exam (30%):
- Project (30%):
|