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
  • ER Design issues
  • ER To table conversion
  • 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