Name: Notes for Database Engineering - DE by Abhishek Kumar
Rating: 2 (1 reviews)
Author: Abhishek 146

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

Introduction To Database Systems And Its Application

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

Data Models

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

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)

Relational Query Language

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

Normailization

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)

Lossless Join And Dependency Preserving Decomposition

Normalization sample Questions,Assignment problems

Normalization Sample Questionsassignment 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

Serializability

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

Two Phase Locking 2pl

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