Skip to content
logo
  • Home
  • C
    • Programs
    • Tutorials
    • Interview Questions
  • C++
    • Programs
    • Tutorials
    • Interview Questions
  • Java
    • Programs
    • Tutorials
    • Interview Questions
  • Android
  • Python
    • Tutorials
    • Programs
    • Interview Questions
    • Django Tutorials
  • .Net
    • C#
    • VB.Net
      • Tutorials
      • Interview Questions
    • ASP.NET
  • PHP
  • Batch File
  • JavaScript
  • SQL
  • PL/SQL
    • Tutorials
    • Programs
    • Interview Questions
  • Programming
    • Articles
    • Tutorials
    • Projects
  • Interview Q & A
  • Books
  • DSA
  • Design
    • Design
    • HTML Interview Questions
  • Development
  • Review
  • Sponsored
logo

Database Management System (DBMS) Notes

Here are the notes for Database Management System (DBMS). Just click on any topic to download its notes in doc format.

Unit 1

  • DBMS Introduction
  • File System
  • Hierarchical Data Model
  • Network Data Model
  • Relational Data Model
  • Object-Oriented Data Model
  • History of DBMS
  • File System vs DBMS
  • What is Database
  • Data Abstraction
  • Instance and Schema
  • Data Independence
  • Keys in DBMS
  • ER Model & Types of Attributes
  • How to Draw ER Diagram
  • Convert ER Diagram to Table
  • Types of Database Systems
  • Centralized Database System
  • Distributed Database System
  • Parallel Database System
  • Client-Server Database System
  • Database Languages
  • DBMS Interfaces
  • Database Users
  • Overall Structure of DBMS
  • 4th Generation Language
  • What is Metadata
  • Mapping and Participation Constraints
  • Existence Dependency
  • Generalization, Specialization and More
  • Degree of Relationship
  • Cardinality Ratio
  • Integrity Constraints

Unit 2

  • Data Types
  • SQL Notes Video 37 to 45
  • SQL Notes Video 46 to 54
  • SQL Notes Video 55 to 63
  • Relational Algebra
  • Triggers
  • Anomalies in DBMS
  • Decomposition
  • Functional Dependency
  • Normalization – 1NF, 2NF, 3NF, BCNF, 4NF, 5NF
  • Conclusion of Normalization
  • 6NF, DKNF, ETNF, EKNF
  • Prime and Non-Prime Attributes, Armstrong’s Axioms
  • Closure of a Set of Functional Dependencies
  • Canonical Cover and Minimal Cover

More notes coming soon!

Important Pages

  • About
  • Contact
  • Advertise
  • Privacy Policy  
  • IT Jobs  

Categories

  • Home
  • C
    • Programs
    • Tutorials
    • Interview Questions
  • C++
    • Programs
    • Tutorials
    • Interview Questions
  • Java
    • Programs
    • Tutorials
    • Interview Questions
  • Android
  • Python
    • Tutorials
    • Programs
    • Interview Questions
    • Django Tutorials
  • .Net
    • C#
    • VB.Net
      • Tutorials
      • Interview Questions
    • ASP.NET
  • PHP
  • Batch File
  • JavaScript
  • SQL
  • PL/SQL
    • Tutorials
    • Programs
    • Interview Questions
  • Programming
    • Articles
    • Tutorials
    • Projects
  • Interview Q & A
  • Books
  • DSA
  • Design
    • Design
    • HTML Interview Questions
  • Development
  • Review
  • Sponsored

Copyright © 2023 The Crazy Programmer