DBMS Tutorial

Basics

• What is DBMS
• DBMS architecture
• DBMS applications
• Characteristics of database
• Advantages of DBMS
• Disadvantages of a DBMS
• Database schema
• Data independence in dbms
• DBMS vs file system
• Types of DBMS
• Role of DBA

Data Models

• DBMS data models
• Relational model in DBMS
• Entity Relationship model (E-R model) in DBMS
• Constraints in DBMS
• ER diagram in DBMS
• What is generalization in dbms
• DBMS Specialization
• DBMS Aggregation
• Transaction in DBMS
• Concurrency control in DBMS
• Serializability in DBMS

Database Normalization

• Keys in DBMS
• What is relationship in DBMS
• Functional dependency in dbms
• Normalization in dbms
• First normal form
• Second normal form
• Third normal form
• BCNF normal form