BCA Semester 1 – Computer Fundamentals and Applications – Unit 4: Database Management System

| Aspect | Primary Memory | Secondary Memory | |--------|----------------|------------------| | Nature | Volatile (loses data when power off) | Non-volatile (retains data) | | Speed | Very fast access

A database is an organized collection of structured data stored electronically in a computer system, managed by a Database Management System (DBMS). Advantages of Database over File-Based System: 1. D

A Database Administrator (DBA) is a professional responsible for managing, maintaining, and securing an organization's database systems. The DBA ensures the database operates efficiently and remains a

Database Management System (DBMS): DBMS is software that provides an interface to create, manage, and manipulate databases. It allows users to store, retrieve, update, and delete data efficiently whil

1. Who Supervises Databases in an Organization? The Database Administrator (DBA) is the person responsible for supervising and managing the organization’s databases. The DBA ensures that data is sec

1. Definition of DBMS A Database Management System (DBMS) is a software system that allows users to store, manage, retrieve, and manipulate data in a structured way. - Provides an interface between

1. Why Do We Need to Use DBMS? A Database Management System (DBMS) is required to manage data efficiently and effectively. The main reasons are: 1. Data Redundancy Reduction - Avoids storing the