DBMS According to the Programmer PDF

DBMS according the programmer - Introduction to Database - E-R Diagram - Normalization and Functional Dependency - Transaction and Serializability - Indexing - SQL - Relational Algebra and Calculus UNIT-1 - Introduction to Database - Introduction to Database - Data...

DBMS according the programmer - Introduction to Database - E-R Diagram - Normalization and Functional Dependency - Transaction and Serializability - Indexing - SQL - Relational Algebra and Calculus UNIT-1 - Introduction to Database - Introduction to Database - Data - Information - Knowledge - Characteristics of the Database Approach - E-R Diagram - Introduction E-R modeling - Notation for E-R Diagram - Attributes - Relationship - Strong & weak Entity - One to one Relationship - One to many Relationship - Many to many Relationship - Conversion of ER model to Relational Model - Key Concepts - Types of keys - Super key - Candidate key - Primary key - Alternate key/ Secondary key - Composite key - Foreign key - Functional Dependency - Basics of functional Dependency - Types of functional Dependency - Inference Rule/Axioms Rules - Closure set of Attributes - Normalization - Introduction of Normalization - 1NF - 2NF - 3NF - 4NF - Decomposition of relation - Lossless and lossy Decomposition - Dependency preserving Decomposition - Transaction and serializability - Introduction to Transaction processing - Properties of Transaction - Transaction state Diagram - Types of schedules in DBMS - Serial, Non-serial and concurrent schedule - Testing of serializability Conflict View Serializable serializable - Non-serializable Recoverable Non-Recoverable Schedules schedules Cascading Cascadless Strict schedules schedule schedule - Lock base protocols - Two phase locking - Version of 2PL - Timestamp based protocol - Strict timestamp based protocol - Thomas write rule - Indexing - Indexing and Types of of index - Primary - Secondary - Clustering - Multi-level Indexing - Hashed Files - Multi way search Tree:- B,B+ tree - B Tree creation and insertion - B+ Tree creation and insertion - B Tree Deletion - B+ Tree Deletion - Difference between B and B+ Tree - SQL - Introduction to SQL - Data Definition Language(DDL) - Data Manipulation Language(DML) - SQL Basic operations - Aggregate Functions - SQL Constraints - Set operations - The Relational Algebra - Introduction to Relational Algebra - Select operation - Project operation - Rename operation - Union operation - Set difference operation - Cartesian operation - Join Intersection operation - Division - Outer join