DATABASE MANAGEMENT SYSTEM

CONTENT

  • Definition of Database and Database Management
  • Examples of Database Management Systems
  • Basic Terminology
  • Microsoft Access
  • Uses of Microsoft Access for Database Management

 

Definition of Database and Database Management

A database is a meticulously organized collection of data. A database program is software designed to store and retrieve data in a structured manner.

A Database, in essence, is a unified collection of data serving one or multiple purposes while minimizing data duplication. It ensures a consistent and controlled repository of information. For instance, a school’s student database comprises data related to students, including academic records, tuition fees, and accommodation details.

A Database Management System (DBMS) is software that governs the storage, retrieval, and manipulation of data stored within a database. Utilizing a DBMS streamlines the processes of storing, editing, and retrieving files effectively. Some examples of DBMS include Microsoft Access, Dbase IV, Oracle, MYSQL, MSSQL, FoxBASE Plus, and Sybase.

Examples of Database Management Systems

  • MySQL
  • MariaDB
  • PostgreSQL
  • SQLite
  • Microsoft SQL Server
  • Oracle
  • SAP HANA
  • dBASE
  • FoxPro
  • IBM DB2
  • LibreOffice Base
  • FileMaker Pro
  • Microsoft Access
  • InterSystems Caché
  • Paradox
  • SYBASE
  • SYSTEM 2000
  • FileMaker
  • INFORMIX

Basic Terminology

Field: A field, also known as an attribute, represents a single data item, such as a first name or date of birth.

Lesson tags: Data Processing Third Term, Data Processsing, SS1 Data Processing Evaluation Questions Third Term, SS1 Data Processing Lesson Notes Third Term, SS1 Data Processing Objective Questions Third Term, SS1 Data Processing Questions and Answers, SS1 Data Processing Third Term
Back to: Data Processing – SS1 > Third Term
© [2022] Spidaworks Digital - All rights reserved.