- Instructor: Prof.
Sung-Hyuk Cha
- CRN: 72169 & 71033
- Course URL: http://www.csis.pace.edu/~scha/DBMSF07/index.html
- Meeting:
- Time: Tuesday 6:00 pm - 8:45 pm, Fall 2007
- 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
- Project: consists of the design and implementation of a
database application of your choice using either MicroSoft Access or
MySQL. It is decomposed into 3 parts. In the first part, choose a
non-trivial application (e.g., an enterprise involving companies,
departments, employees, inventory etc.) and model it by stating the
requirements and using an E-R diagram. The second part is the
implementation of the relational model based upon the E-R diagram of the
first part. The final part is the implementation of the application. This
project is to be done in groups of 3.
click
here for details.
Here
is a
sample project
- Schedule:
| Week |
Topic |
| 1 (9/11) |
Ch 1 Database Systems |
| 2 (9/18) |
Ch 2 Data Models |
| 3 (9/27) |
Ch 3 relational Database Model |
| 4 (10/2) |
Ch 4 ER Modeling |
| 5 (10/9) |
Ch 5 Normalization of Database Tables |
| 6 (10/16) |
Review |
| 7 (10/17) |
Midterm |
| 8 (10/23) |
Ch 7 SQL |
| 9 (10/30) |
Ch 7 SQL |
| 10 (11/6) |
Ch 8 Advanced SQL |
| 11 (11/13) |
Ch 9 Transaction Management & Concurrency control |
| 12 (11/20) |
More on SQL |
| 13 (11/27) |
Image Indexing and Retrieval |
| 14 (12/4) |
Review |
| 15 (12/11) |
Project Presentation |
| 16 (12/18) |
Final Exam |
| |
|
- Evaluation:
- Online Quizzes (10%): There will be five quizzes.
- Midterm Exam (30%):
- Final Exam (30%):
- Project (30%):
|