Introduction to Databases

Front

Introduction to Databases

Back

Databases are collections of related data used in everyday life, often without us realizing it.

Front

Database Management System (DBMS)

Back

Software that manages and controls access to the database.

Front

Database Application

Back

A program that interacts with the database during its execution.

Front

Traditional File-Based Systems

Back

Traditional file-based systems are predecessors to database systems, used for managing data through a collection of application programs.

Front

Purpose of File-Based Systems

Back

File-based systems perform services for end-users, such as producing reports, by defining and managing their own data.

Front

Manual Filing System

Back

A manual filing system involves physical files stored in cabinets, often used for organizing documents like receipts and invoices.

Front

Challenges of Manual Filing

Back

Manual filing systems work well with small amounts of data but struggle with cross-referencing or processing large volumes of information.

Front

The Contracts Department handles lease agreements for properties.

Back

The Contracts Department manages client agreements, allocates lease numbers, and completes payment details with the help of the DP Department.

Front

Each department accesses its own files through application programs.

Back

Departmental application programs handle data entry, file maintenance, and generate specific reports.

Front

File-based systems often lead to duplication of data.

Back

Duplication of data is wasteful and takes up additional storage space.