Unit: I Introduction to DBMS:
Basic concepts, Advantages of a DBMS over fileprocessing Systems, Data abstraction, Database Languages, Data Models:Introduction to Hierarchical, Network, ER, and Object Relational Model, Data Independence, Components of a DBMS and overall structure of a DBMS, Multi-User DBMS Architecture, System Catalogs Data Modeling: Basic Concepts, entity, attributes, relationships, constraints, keys, E-R and EER diagrams: Components of E-R Model, conventions, converting E-R diagram into tables, EER Model components, converting EER diagram into tables. Relational Model: Basic concepts, Attributes and Domains, Codd's Rules,
Relational Integrity: Domain, Entity, Referential Integrities, Enterprise Constraints, Views, Schema diagram
Unit: II Relational Query Languages:
Relational Algebra Introduction to SQL: Characteristics and advantages, SQL Data Types and Literals, DDL, DML, SQL Operators, Tables: Creating, Modifying, Deleting, Views: Creating, Dropping, Updation using Views, Indexes, Nulls SQL DML Queries: SELECT Query and clauses, Set Operations, Predicates and Joins, Set membership, Tuple Variables, Set comparison, Ordering of Tuples, Aggregate unctions, Nested Queries, Database Modification using SQL Insert, Update and Delete Queries, concept of Stored Procedures, Cursors, Triggers, assertions, roles and privileges Programmatic SQL: Embedded SQL, Dynamic SQL.
Unit: III Relational Database Design:
Purpose of Normalization, Data Redundancy and Update Anomalies, Functional Dependencies: Basic concepts, closure of set of functional dependencies, closure of attribute set, canonical cover, Decomposition: lossless join decomposition and dependency preservation, The Process of Normalization: 1NF, 2NF, 3NF, BCNF, 4NF, 5NF.
Unit: IV File Systems:
File Organization, Organization of records in files, Indices, Static and Dynamic Hashing, B-trees and B+ Trees Introduction to Query Processing: Overview, Measures of query cost, Selection and join operations, Evaluation of Expressions, Introduction to Query Optimization, Estimation, Transformation of Relational Expressions
Unit: V Transaction Management:
Basic concept of a Transaction, Properties of Transactions, Concept of Schedule, Serial Schedule, Serializability: Conflict and View, Cascaded Aborts, Recoverable and Non-recoverable Schedules, Concurrency Control: Need, Locking Methods, Deadlocks, Timestamping Methods, Optimistic Techniques, Multi-Version Concurrency Control, Different Crash Recovery methods such as Shadow-Paging and Log-Based Recovery: Deferred and Immediate, Checkpoints
Unit VI Object-Oriented Databases:
Need of OODBMS, Storing Objects in Relational Database, Introduction to OO Data Models, Persistent Programming Languages, Pointer Swizzling Techniques Database Architectures: Centralized and Client-Server Architectures, 2 Tier and 3 Tier Architecture, Introduction to Distributed Database systems Introduction to data mining using association rules, introduction to data warehousing and its components.
Reference:Syllabus copy - T E I.T.2008 pattern ( unipune.ac.in )