Textbook: Silberschatz, Korth, and Sudarshan, Database System
Concepts, 4th edition, McGraw-Hill, 2001
Course Goals: This course provides an introduction to
database concepts, data models, SQL, and database design. The major goal
is to provide students with an understanding of the basic concepts
underlying the design and use of a database system. A database
management system 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 Oracle 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.
click here for
details. Here is a
sample project
Quizzes (20%): There will be 10-minutes quizzes given at
the beginning of most lecture classes. Topics will be those covered
most recently. Your lowest score on the quizzes will be dropped.
Project (30%): Presentation with
demonstration is required.
Class cancelled