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.
- NEW: Download the entire term's content in MS Word document format (1-year plan only)
- The complete lesson note and evaluation questions for this topic
- The complete lessons for the subject and class (First Term, Second Term & Third Term)
- Media-rich, interactive and gamified content
- End-of-lesson objective questions with detailed explanations to force mastery of content
- Simulated termly preparatory examination questions
- Discussion boards on all lessons and subjects
- Guaranteed learning