Computer Science Course Information

Level >Graduate >FALL_2005 >List >

Data Management Systems Design

Course No. CIS 631

Sections 001, 103

Title Data Management Systems Design

Course Website http://web.njit.edu/~dth/db631.htm

Prerequisite(s) None

Instructor Dimitri Theodoratos
Office Room No. : GITC 4207
Office Phone : 973-596-5213
Fax : 973-596-5777
Email : dimitri.theodoratos@njit.edu
Website: http://web.njit.edu/~dth/
Lab : N/A

Instructor Office Hours

Description The objective of the course is to give a thorough introduction to the concepts of designing, organizing, querying and managing relational databases. It will be well balanced between theory and practice.
The course covers eight topics: Conceptual Modeling (the Entity-Relationship model and the Enhanced Entity-Relationship model), the Relational Model (Concepts, Integrity Constraints, Update Operations, Relational Algebra, Relational Calculus), From Conceptual Models to Logical Models (Mapping the ER model to the Relational model), the Commercial Database Language SQL (Data Definition, Basic Integrity Constraints, Schema Changes, Basic and Complex Queries, Aggregate Functions and Grouping, Data Change Statements, Views, Complex Constraints, Embedded SQL, Cursors, Dynamic SQL, JDBC), Active Databases (Active Database Rules, Triggers), Database Physical Organization (File Organizations, External Hashing, Indexing), Database Design Theory (Functional and Other Dependencies, Dependency Inference, Normal Forms, Schema Decomposition, Normalization), and Database Management Systems Implementation Issues (Transaction Processing, Concurrency Control).
You will learn the latest of the SQL:1999 standard and you will get hands on experience on creating, populating, querying, maintaining and managing a relational database using the commercial database management system Oracle

Topics Introduction.
Database Systems Architecture.
Database Design.
Conceptual Modeling.
The Entity-Relationship and Extended Entity-Relationship Models.
The Relational Model -- Basic Definitions, Integrity Constraints, Update Operations.
Relational Algebra and Relational Calculus.
Mapping Entity-Relationship to Relational Schemas.
Commercial Query Languages. SQL -- Data Definition and Simple SQL
More Complex Queries, Updates, Views, Constraints
Embedding SQL into a host language. Oracle.
Active Databases and Triggers.
Primary File Organizations.
External Hashing.
Indexing.
Schema Decomposition. Normalization.
Transaction Processing.
Concurrency Control, Database Recovery.

Text Book(s) Fundamentals of Database Systems, 4th Edition,by Elmasri and S.B. Navathe
Addison Wesley,2004.
Oracle9i Programming, A Primer by R. Sunderraman
Addison Wesley, 2004.

Time & Place Thursday 6:00 PM - 9:05 PM Kupf 117 Wednesday: 8:30am - 11:25am Culm Lect # 3

Other Info Grading

The midterm, the assignments, the project and the final exam contribute to the course grade as follows:

Midterm
30%

Assignments
12%
4% each of the three assignments

Project
23%
4% each of the 1st and the 2nd deliverables, and 15% the 3rd deliverable

Final
35%

Academic Honor Code

The NJIT academic honor code
(http://www.njit.edu/academics/honorcode.php)applies in full to this
class. Note in particular that copying programs, in full or in part, is
forbidden. You may discuss ideas and concepts with your fellow
students, but you may NOT copy any code.

Registrar's Website

Course No.	CIS 631
Sections	001, 103
Title	Data Management Systems Design
Course Website	http://web.njit.edu/~dth/db631.htm
Prerequisite(s)	None
Instructor	Dimitri Theodoratos Office Room No. : GITC 4207 Office Phone : 973-596-5213 Fax : 973-596-5777 Email : dimitri.theodoratos@njit.edu Website: http://web.njit.edu/~dth/ Lab : N/A
Instructor Office Hours
Description	The objective of the course is to give a thorough introduction to the concepts of designing, organizing, querying and managing relational databases. It will be well balanced between theory and practice. The course covers eight topics: Conceptual Modeling (the Entity-Relationship model and the Enhanced Entity-Relationship model), the Relational Model (Concepts, Integrity Constraints, Update Operations, Relational Algebra, Relational Calculus), From Conceptual Models to Logical Models (Mapping the ER model to the Relational model), the Commercial Database Language SQL (Data Definition, Basic Integrity Constraints, Schema Changes, Basic and Complex Queries, Aggregate Functions and Grouping, Data Change Statements, Views, Complex Constraints, Embedded SQL, Cursors, Dynamic SQL, JDBC), Active Databases (Active Database Rules, Triggers), Database Physical Organization (File Organizations, External Hashing, Indexing), Database Design Theory (Functional and Other Dependencies, Dependency Inference, Normal Forms, Schema Decomposition, Normalization), and Database Management Systems Implementation Issues (Transaction Processing, Concurrency Control). You will learn the latest of the SQL:1999 standard and you will get hands on experience on creating, populating, querying, maintaining and managing a relational database using the commercial database management system Oracle
Topics	Introduction. Database Systems Architecture. Database Design. Conceptual Modeling. The Entity-Relationship and Extended Entity-Relationship Models. The Relational Model -- Basic Definitions, Integrity Constraints, Update Operations. Relational Algebra and Relational Calculus. Mapping Entity-Relationship to Relational Schemas. Commercial Query Languages. SQL -- Data Definition and Simple SQL More Complex Queries, Updates, Views, Constraints Embedding SQL into a host language. Oracle. Active Databases and Triggers. Primary File Organizations. External Hashing. Indexing. Schema Decomposition. Normalization. Transaction Processing. Concurrency Control, Database Recovery.
Text Book(s)	Fundamentals of Database Systems, 4th Edition,by Elmasri and S.B. Navathe Addison Wesley,2004. Oracle9i Programming, A Primer by R. Sunderraman Addison Wesley, 2004.
Time & Place	Thursday 6:00 PM - 9:05 PM Kupf 117 Wednesday: 8:30am - 11:25am Culm Lect # 3
Other Info	Grading The midterm, the assignments, the project and the final exam contribute to the course grade as follows: Midterm 30% Assignments 12% 4% each of the three assignments Project 23% 4% each of the 1st and the 2nd deliverables, and 15% the 3rd deliverable Final 35% Academic Honor Code The NJIT academic honor code (http://www.njit.edu/academics/honorcode.php)applies in full to this class. Note in particular that copying programs, in full or in part, is forbidden. You may discuss ideas and concepts with your fellow students, but you may NOT copy any code.