Database Management System (DBMS) Last Updated : 29 Feb, 2020 ‘Recent Articles’ on DBMS ! Introduction Entity Relationship Model Relational Model Relational Algebra Functional Dependencies Normalisation Transactions and Concurrency Control Indexing, B and B+ trees File Organization Advanced Topics SQL Quick Links Introduction : DBMS Introduction | Set 1 DBMS Introduction | Set 2 (3-Tier Architecture) DBMS Architecture 2-level 3-level Need For DBMS Data Abstraction and Data Independence Database Objects Multimedia Database Interfaces Categories of End Users Use of DBMS in System Software Choice of DBMS | Economic factors Disadvantages of DBMS Entity Relationship Model : ER Model Enhanced ER Model Minimization of ER Diagram ER Model: Generalization, Specialization and Aggregation Recursive Relationships Impedance Mismatch Relational Model : Relational Model and CODD Rules Relational Model Keys in Relational Model (Candidate, Super, Primary, Alternate and Foreign) Number of possible Superkeys Anomalies in Relational Model Mapping from ER Model to Relational Model Strategies for Schema design Schema Integration Star Schema in Data Warehouse modeling Data Warehouse Modeling | Snowflake Schema Dimensional Data Modeling >> Quiz on ER and Relational Model Relational Algebra : Introduction Basic Operators Extended Operators Inner Join vs Outer Join Join operation Vs nested query DBMS | Tupple Relational Calculus Row oriented vs. column oriented data stores How to solve Relational Algebra Problems for GATE How to Solve Relational Algebra Problems for GATE Functional Dependencies : Functional Dependency and Attribute Closure Finding Attribute Closure and Candidate Keys using Functional Dependencies Armstrong’s Axioms in Functional Dependency Equivalence of Functional Dependencies Canonical Cover Normalisation : Introduction Normal Forms Minimum relations satisfying 1NF The Problem of redundancy in Database Dependency Preserving Decomposition Lossless Join Decomposition LossLess Join and Dependency Preserving Decomposition How to find the Highest Normal Form of a Relation Domain Key normal form Introduction of 4th and 5th Normal form Denormalization in Databases DBMS | Data Replication >> Quiz on Normal Forms Transactions and Concurrency Control : Introduction ACID Properties Concurrency Control -Introduction Implementation of Locking in DBMS Concurrency Control Protocols – Lock Based Protocol Concurrency Control Protocol | Graph Based Protocol Concurrency Control Protocol | Two Phase Locking (2-PL)-I Concurrency Control Protocol | Two Phase Locking (2-PL)-II Concurrency Control Protocol | Two Phase Locking (2-PL)-III Concurrency Control Protocol | Multiple Granularity Locking Concurrency Control Protocol | Thomas Write Rule Concurrency Control | Polygraph to check View Serializabilty DBMS | Log based recovery Timestamp Ordering Protocols Introduction to TimeStamp and Deadlock Prevention Schemes Dirty read in SQL Types of Schedules Conflict Serializability View Serializability How to test if two schedules are View Equal or not ? Recoverability of Schedules Precedence Graph for testing Conflict Serializabilty Transaction Isolation Levels in DBMS Database Recovery Techniques Starvation in DBMS Deadlock in DBMS DBMS | OLAP vs OLTP Types of OLAP Systems DBMS | Types of Recoverability of Schedules and easiest way to test schedule | Set 2 Web Information Retrieval | Vector Space Model Why recovery is needed? >> Quiz on Transactions and concurrency control Indexing, B and B+ trees : Indexing and its Types B-Tree | Set 1 (Introduction) B-Tree | Set 2 (Insert) B-Tree | Set 3 (Delete) B+ Tree (Introduction) Bitmap Indexing Inverted Index Difference between Inverted Index and Forward Index SQL queries on clustered and non-clustered Indexes >> Practice questions on B and B+ Trees >> Quizzes on Indexing, B and B+ Trees File Organization: File Organization – Set 1 File Organization – Set 2 (Hashing in DBMS) File Organization – Set 3 File Organization – Set 4 >> Quiz on File structures Advanced Topics : RAID Query Optimization How to store a password in database? Storage Area Networks Network attached storage Data Warehousing Data Warehouse Architecture Characteristics and Functions of Data warehouse Difficulties of Implementing Data Warehouses Data Mining Data Mining | KDD process Data Mining | Sources of Data that can be mined Data Marts ODBMS – Definition and overview Architecture of HBase Apache HBase Architecture and Working of Hive Apache Hive Difference between Hive and HBase Difference between RDBMS and HBase Challenges of database security Federated database management system issues Distributed Database System Functions of Distributed Database System Semantic Heterogeneity Advantages of Distributed database Comparison – Centralized, Decentralized and Distributed Systems Characteristics of Biological Data (Genome Data Management) Data Management issues in Mobile database Future Works in Geographic Information System Difference between Structured, Semi-structured and Unstructured data SQL Tutorial SQL | Tutorials Quiz on SQL DBMS practices questions : Database Management Systems | Set 1 Database Management Systems | Set 2 Database Management Systems | Set 3 Database Management Systems | Set 4 Database Management Systems | Set 5 Database Management Systems | Set 6 Database Management Systems | Set 7 Database Management Systems | Set 8 Database Management Systems | Set 9 Database Management Systems | Set 10 Database Management Systems | Set 11 Quick Links : Last Minutes Notes(LMNs) on DBMS Quizzes on DBMS ! ‘Practice Problems’ on DBMS ! DBMS interview questions | Set 1 DBMS interview questions | Set 2 Please write comments if you find anything incorrect, or you want to share more information about the topic discussed above. My Personal Notes arrow_drop_up Save Share your thoughts in the comments Add Your Comment Please Login to comment... Similar Reads DBMS Learn SQL and Database Grokking Modern System Design Interview Guide Introduction of DBMS (Database Management System) - Set 1 Purpose of Database System in DBMS Database Management System - GATE CSE Previous Year Questions Federated database management system issues Personnel involved in Database Management System Structure of Database Management System Employee Database Management System using HTML CSS and JavaScript 4.7 110k+ interested Geeks Mastering System Design: From Low-Level to High-Level Solutions View Details Enroll 4.5 616 interested Geeks Become a Great Product Manager View Details Enroll 4.9 277k+ interested Geeks Tech Interview 101 - From DSA to System Design for Working Professionals View Details Enroll We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy Got It ! × View Detailed Syllabus Registering for × Full Name* Email Id* Graduation Year* Country* India : +91 Phone Number* By Registering, you agree to our Privacy Policy and Terms & Conditions Save and Next × Thank you for registering You are one step away from the course Pay Online What kind of Experience do you want to share? Interview Experiences Admission Experiences Engineering Exam Experiences Work Experiences Campus Experiences Add Other Experiences Can't choose a topic to write? click here for suggested topics Write and publish your own Article