Database Management System (DBMS) is the collection of software programs that is used to manage the database effectively and conveniently. DBMS interface with application programs so that database can be shared by multiple users or application programs.

Introduction to Database Management System (DBMS) – Database Management System

In this “Introduction to Database Management System (DBMS) – Database Management System” you will learn about following topics:

  1. Basic Terminologies
  2. Introduction to Database Management System (DBMS)
  3. Advantages of DBMS
  4. Brief History of Database Management System Approach
  5. File-Based Model
  6. Hierarchical Data Model
  7. Network Data Model
  8. Relational Database
  9. Cloud Database
  10. NoSQL Database
  11. Object-Oriented Databases
  12. Graph Databases
  13. Application Areas of DBMS
  14. Components of a Database Management System
  15. Hardware, Software, Data, Procedures, Database Access Languages, Users
  16. DBMS vs. File System
  17. Difference between DBMS and RDBMS
  18. Data Model Schema and Instance
  19. Three Schema Architecture/ Views of Data – Data Abstraction
  20. Internal Schema/Physical Level
  21. Conceptual Schema/Logical Level
  22. External Schema/User View Level
  23. Goal of 3 Level/Schema of Database
  24. Advantages Database Schema
  25. Disadvantages Database Schema
  26. Data Independence
  27. Types of Data Independence
  28. Database Language
  29. Types of Database Languages
  30. Data Definition Language (DDL)
  31. Data Manipulation Language (DML)
  32. Data Control Language (DCL)
  33. Transaction Control Language (TCL)
  34. Database Administrator
  35. Function of DBA (Database Administrator)




==== Point to Note ====

This article Introduction to Database Management System (DBMS) – Database Management System is contributed by Rashita Gurung, a student of LA GRANDEE International College.

If you like to contribute, you can mail us BCA Notes, BCA Question Collections, BCA Related Information, and Latest Technology Information at [email protected].

See your article appearing on BCA Notes (Pokhara University) main page with your designation and help other BCA Students to excel.

Please write comments if you find anything incorrect, or you want to share more information about the topic discussed above.

BCA 4th Semester DBMS (Database Management System) Notes Pdf:

  1. Unit II: Data Models - Database Management System
  2. Unit III: Relational Model - Database Management System
  3. Unit IV: Relational Database Query Languages - Database Management System
  4. Unit V: Database Constraints and Relational Database Design - Database Management System
  5. Unit VI: Database Security - Database Management System
  6. Unit VII: Query Processing - Database Management System
  7. Unit VIII: File Organization and Indexing - Database Management System
  8. Unit IX: Crash Recovery - Database Management System
  9. Unit X: Transaction Processing and Concurrency Control - Database Management System
  10. Unit XI: Advanced Database Concepts - Database Management System