Notes for Database Engineering - DE by Abhishek Kumar

Traditional File Oriented Systems,Requirements of database systems,Database Concepts,Limitations of DBMS,Data Abstraction: The three tier DBMS architecture

Types of data models,Record based data models,Network data model,Relational data model,Properties of a relation/table, Properties of relational data base management system (RDBMS) ,Domain and Integrity Constraints,Basic terminologies of relational data model: (RDBMS) ,Entity- Relationship Model

Participation of an entity set in a relationship set,E.R. Diagrams,Aggregation,Generalization,Extended E-R features,E-R Model

Relational Algebra,Summary of operations,Special operations,PROJECTION,The composition of select and project operations,JOIN OPERATION ,Types of join operation,RELATIONAL DATABASE DESIGN (RDD)

OBJECTIVES,INTEGRITY CONSTRAINTS,Successive normal forms of a relation,FUNCTIONAL DEPENDENCY,Keys of relational schema,SECOND NORMAL FORM,Decomposing the relation,Second Normal Form (2NF),THIRD NORMAL FORM (3NF),Summary of Normal Forms

Dependency Preserving,Boyce Code Normal Form (BCNF),Comparison of 3NF and BCNF,Decomposition for BCNF,Multivalued Dependencies,Trivial Multivalues Dependencies,Properties of MVDS,Fourth Normal Form,Join Dependency,Fifth Normal Form: (5 NF)

Normalization sample Questions,Assignment problems

Basic assumption,Simplified view of transactions,Schedules,Rules for locking Technique by DBMS,Shared or Exclusive lock,Techniques of concurrency control,Types of locks

Rules,Somatic of two phase locking (2 PL) ,Strictly two phase locking,Transaction processing & concurrency control,Issues of transaction management,ACID properties of Transactions,States of transaction,Transaction execution with SQL

Time stamp ordering rules,The time stamp ordering algorithm,Basic time stamp ordering (Basic To) ,Strict Time stamp ordering,Multiversion concurrency control technique,Optimistic Concurrency Control,Recovery techniques,Immediate Update,Recovery,Types of recovery,Recovery using check point,Roll Back,Types of ordered indices