Unit I: Introduction to Database Management System (DBMS) – Database Management System

Unit I: Introduction to Database Management System (DBMS) – Database Management System

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 bcanotespu@gmail.com.

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:

Unit II: Data Models - Database Management System

Unit III: Relational Model - Database Management System

Unit IV: Relational Database Query Languages - Database Management System

Unit V: Database Constraints and Relational Database Design - Database Management System

Unit VI: Database Security - Database Management System

Unit VII: Query Processing - Database Management System

Unit VIII: File Organization and Indexing - Database Management System

Unit IX: Crash Recovery - Database Management System

Unit X: Transaction Processing and Concurrency Control - Database Management System

Unit XI: Advanced Database Concepts - Database Management System


Hello, I am a BCA graduate. I have good knowledge of Blogger, WordPress, SEO, Content Writing, and Photo Editing. I also have expertise in Article Rewriting, Proofreading, Report Writing, Report Formatting on Microsoft Word, and other pdf files. If anyone needs help regarding these topics they can contact me.

0 Comments: