DBMS Tutorial – Database Management System notes

DBMS stands for Database Management System. We can break it like this DBMS = Database + Management System. Database is a collection of data and Management System is a set of programs to store and retrieve those data. Based on this we can define DBMS like this: DBMS is a collection of inter-related data and set of programs to store & access those data in an easy and effective manner. Here are the DBMS notes to help you learn database systems in a Systematic manner. Happy Learning!!

• Introduction to DBMS
  • DBMS Applications
  • Advantages of DBMS over file processing system
• DBMS Architecture
• Three level DBMS Architecture
• View of Data
  • Data Abstraction
  • Instances and Schemas
• Data Models in DBMS
  • E-R Model in DBMS
  • DBMS Generalization
  • DBMS Specialization
  • DBMS Aggregation
  • Relational Model in DBMS
    • RDBMS concepts
  • Hierarchical data Model in DBMS
  • Network Model in DBMS
• Database languages
• Relational Algebra
• Relational Calculus
• Keys in DBMS
  • Primary key
  • Super key
  • Candidate key
  • Alternate key
  • Composite key
  • Foreign key
• Constraints in DBMS
  • Domain constraints
  • Mapping constraints
• Cardinality in DBMS
• Functional dependencies in DBMS
  • Trivial functional dependency
  • non-trivial functional dependency
  • Multivalued dependency
  • Transitive dependency
• Normalization in dbms – This covers all the normal forms: First Normal Form(1NF), Second Normal Form(2NF), Third Normal Form(3NF), Boyce–Codd Normal Form(BCNF)
• Transaction Management in DBMS
  • • ACID Properties
    • Transaction States
    • DBMS Schedules
    • Serializability
    • DBMS Conflict Serializability
    • DBMS View Serializability
    • Deadlock
    • Concurrency Control