Objectives of the course:
•   This   course   aims   to   provide   continuum   to   where   the  first   course   of   databases   left   off.   Design   aspects  of
    relational databases are covered.
•   Complex data models like OO OR parallel and distributed are introduced.
•   The   course   provides   students   a   good   overview   of   the  ideas   and   the   techniques,   which   are   behind   recent
    developments in the fields of data warehousing and Online Analytical Processing (OLAP).  
1.  Overview
Review of relational database systems, ER diagram, SQL.

2.  Integrity and Security
Domain constraints; referential integrity, assertions; triggers; triggers and
Assertions in SQL. Security and Authorization; Authorization in SQL.

3.  Relational database Design
First normal form; pitfalls in relational database design, functional
dependencies; decomposition. Desirable properties of decomposition. Boyce-
Code normal form; 3rd
 and 4th
 normal form. Mention of other formal forms.

4.  The ER Model Revisited
Motivation for complex data types, User Defined Abstract Data Types And
Structured Types, Subclasses, Super classes, Inheritance, Specialization and
Generalization, Relationship Types of Degree Higher Than Two.

5.  Object-Oriented & Object relational databases
Object Identity, Object Structure, and Type Constructors, Encapsulation of
Operations, Methods, and Persistence, Type Hierarchies and Inheritance,
Type extents and Queries, Database Design For An ORDBMS- Nested
Relations and Collections; Storage And Access methods, Overview of SQL 3

6.  Parallel and Distributed Databases  

Parallel y Evaluation; Parallelizing Individual Operations, Sorting, Joins;
        Distributed Databases Concepts, Data Fragmentation, Replication, and
        Allocation technique for Distributed Database Design; Query Processing in
        Distributed Databases; Concurrency Control and Recovery in Distributed

    7.  Enhanced Data Models for Advanced Applications.
        (Overview and Design issues)
        Temporal Databases; Spatial Databases & Geographic Information Systems,
        Mobile Databases.

    8.  Data Warehousing and OLAP

            a)  Data Warehousing Basics : Data Warehousing (DW) Introduction &
                Overview; Data Marts, DW components; Data warehouse
                architecture; ETL – Data Transformation-Extracting , Conditioning,
                cleansing, Scrubbing, Merging, etc.
            b)  OLAP: Multidimensional modeling- Fact table, dimensions,
                measures, ROLAP, MOLAP, HOLAP; tools. OLAP Operations-
                Rollup, Drill-down, Dice slice, pivot.

Text Books:
              1.  Elmasri and Navathe, “ Fundamentals of Database System”,
                  Pearson Education
              2.  Raghu Ramakrishna , Johannes Gerhke , “Database management
                  Systems” McGraw Hill
              3.  Kimball, Ralph; Reeves, Laura et al Data warehousing lifecycle
                  Toolkit: expert methods for designing, developing, and deploing
                  data warehouses _ Wiley publications.

    1.  Korth, Silberchatz, Sudarshan, “Database System concepts” Mcgraw Hill
    2.  K. J. Data, Longman, “Introduction to Database Systems”, Pearson Education
    3.  Paulraj Ponnian, “Data Warehousing Fundamentals”, John Wiley.