Unit I: Introduction to Database Management System (DBMS) | BCA 4th Semester Database Management System (DBMS) Notes Pdf

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.

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 Database Management System (DBMS) Notes Pdf:

• Unit II: Data Models
• Unit III: Relational Model
• Unit IV: Relational Database Query Languages
• Unit V: Database Constraints and Relational Database Design
• Unit VI: Database Security
• Unit VII: Query Processing
• Unit VIII: File Organization and Indexing
• Unit IX: Crash Recovery
• Unit X: Transaction Processing and Concurrency Control
• Unit XI: Advanced Database Concepts