|Back to CS Home Page|
Computer Science Course Information
|Course No.||CIS 631||Sections||001, 103|
|Title||Data Management Systems Design|
|Instructor|| Dimitri Theodoratos
|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
Database Systems Architecture.
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.
Schema Decomposition. Normalization.
Concurrency Control, Database Recovery.
|Text Book(s)||Fundamentals of Database Systems, 4th Edition,by Elmasri and S.B. Navathe
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|
The midterm, the assignments, the project and the final exam contribute to the course grade as follows:
4% each of the three assignments
4% each of the 1st and the 2nd deliverables, and 15% the 3rd deliverable
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.