Database Fundamentals: DBMS Characteristics & Advantages, Database Environment,
Database Users, Database Architecture, Data Independence, Languages, Tools and Interface in
DBMS, DBMS types.
Data Modeling: ER Model, Notation used in ER Diagram, Constraint, Types, Relationships
in ER Model and other considerations in designing ER diagram. Enhanced ER data Model,
EER Diagram, Specialization and Generalization, Lattice, Union, Disjoint Properties,
Constraints and relationships, Other issues in designing EER diagrams, Algorithms for ER to
SQL: Data Definition and other languages in SQL, Creating tables and Data types,
Constraints, DML statements, Functions and writing SQL statements using nested sub queries,
complex queries, joining relations, Embedded SQL- Writing functions and procedures with
PL/SQL, Relational Model, Relational Algebra, Operators in relational algebra.
Normalization: Guidelines for good database design, Normalization- Normal Forms, First,
Second, Third Normal Forms, BCNF, Multi value and join dependencies, 4th and 5th normal
forms. Decomposition algorithms for normalization. File and storage structures: File storage,
Index structures, Indexing and hashing. Query Processing: Issues in query processing, simple
algorithms for insert, project, join and other operators.
Transaction Processing: Transaction processing issues, Transaction states, problems
during multiple transactions processing, ACID properties, system log, Concurrency control
techniques: binary locks, exclusive locks, Lock based techniques, Timestamp based techniques,
versioning in locks, Multi-version locking techniques.
Textbooks: "Fundamentals of data base systems" 4th eddition Elmasri Navathe, publisher:
1. Database management systems -3rd, illustrated mcgraw-hill raghu ramakrishnan
2. Database management system by korth. Publisher: tata mcgraw hill by abraham
silberschatz, henry f. Korth and s. Sudarshan
?An introduction to database systems?, C j Date,6th edition, addison wesley longman inc1999.
:: DATABASE AND DATABASE USERS
********TVSN KLU ECM*********