III B.E. (Information Technology)

V SEMESTER

5 IT5 DATA BASE MANAGEMENT SYSTEMS

  1. Introduction to Database Systems: Overview and History of DBMS, File System vs DBMS, Advantages of DBMS, Describing and storing Data in a DBMS, Queries in DBMS, Transaction Management and Structure of DBMS.

  2. Entity Relationship Model: Overview of Data Design, Entities, Attributes and Entity Sets, Relationship and Relationship Sets Features of the ER Model – Key constraints, Participation Constraints, Weak Entities Class hierarchies, Aggregation, Conceptual Data base Design with ER Model Entity vs Attribute, Entity vs Relationship Binary vs Ternary Relationship and Aggregation vs ternary Relationship. Conceptual Design for a large Enterprise.

  3. Relational Algebra and Claculus: Relational Algebra Selection and Projection, set Operations, Set Operations, Renaming, Joins, Division Relational Calculus, Expressive Power so Algebra and Calculus.

  4. SQL Queries, Programming and Triggers: The forms of a basic SQL, Query, Union, Intersect and Except, Nested Queries, Correlated Nested Queries, Set Comparison, Operations, Operations, Aggregate Operators, Null Values and Embedded SQL. Dynamic SQL, ODBC and JDBC. Triggers and Active Databases.

  5. Schema Refinement and Normal Forms: Introduction to scheme refinement Functional dependencies, Boyce Codd Normal Forms. Third Normal Form. Normalization – Decomposition into B00CNF. Decomposition into 3 – NF.

  6. Internet Databases: Databases and the Web, Architecture Application Server and server Side Java, XML-DTD’s, XML-QL.

  7. Object Oriented Database Systems: Object, Object identity and Reference Types. Inheritance and Data Base Design for ORDBMS.                      

Recommended Books:

  1. Raghu Rama Krishnan – Database Management Systems, 2nd ed. Tata McGraw Hill.

  2. Elmassari – Fundamentals of Data Base Systems, Pearson Education.

  3. Silverschatz Korth and Sudarshan – Database System Concepts, 4th ed. Tata McGraw Hill.

  4. Gordon C. Everest – Database Management Objectives, System Functions and Administration Tata McGraw Hill.