Computer Science Course Information
Back to CS Home Page


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