- Instructor: Prof. Sung-Hyuk Cha
- CRN: 21805
- Course URL:
http://www.csis.pace.edu/~scha/IS613/index.html
- Meeting:
- Time: M 6:00~8:45 P.M., Spring 2006
- Place: GC 428 on M
- Textbook:
Peter Rob and Carlos Coronel,
Database Systems: Design, Implementation, & Management, 6th edition, thomson Course Technology, 2004
- 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 (1/23) | Ch 1 Database Systems |
| 2 (1/30) | Ch 2 Data Models & 3 relational Database Model |
| 3 (2/6)
| Ch 4 ER Modeling
|
| 4 (2/13)
| Ch 5 Normalization of Database Tables
|
| 5 (2/20)
| Ch 6 SQL
|
| 6 (2/27)
| Ch 7 Advanced SQL
|
| 7 (3/6)
| Ch 8 Database Design
|
| 8 (3/13)
| Midterm
|
| 9 (3/20)
| Ch 9 Transaction Management & Concurrency control
|
| 10 (3/27)
| Ch 10 Distributed DBMS
|
| 11 (4/3)
| Ch 11 OODB
|
| 12 (4/10)
| Ch 12 The data warehouse
|
| 13 (4/17)
| Ch 13 Databases in Electronic Commerce
|
| 14 (4/24)
| Ch 14 Web Database Development
|
| 15 (5/1)
| Ch 15 Database Administration
|
| 16 (5/8)
| Final Exam
|
| | |
- Evaluation:
- Online Quizzes (10%): There will be six quizzes.
- Midterm Exam (30%):
- Final Exam (30%):
- Project (30%):
|