SS1 Third Term Data Processing Lesson Note – Database Management System

The content is just an excerpt from the complete note for SS1 Third Term Data Processing Lesson Note – Database Management System. Check below to download the complete DOCUMENT

WEEK: 4                                                                                

TOPIC: DATABASE MANAGEMENT SYSTEM I

CONTENT: ­

1. Definition of Database Management
2. Uses of Spreadsheet and Ms-Access for Database Management.

SUB-TOPIC 1: Definition of Database Management

A database is an organized collection of data. A database program is software which stores and retrieved data in a structured way.

A Database is a single organized collection of data for one or more purposes stored with minimum duplication of data items so as to provide a consistent and controlled pool of data. For example a school students’ database will contain data relating to the student such as academic results, school fees, accommodation et.c

A Database Management System (DBMS) is software that controls the storage, retrieval and manipulation of data stored in a database. Using a DBMS makes files easy to store, edit and retrieved effectively. Examples of DBMS are: Microsoft Access, Dbase IV, Oracle, MYSQL, MSSQL, and FoxBASE plus, Sybase.

 

Examples of Database management System

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 TERMINOLOGIES

FIELD:            is a single item of data, such as a forename or date of birth. Each field has a field name that is used to identify it within the database. Field is also called ‘attribute’. It is a single unit of information in a table.

To gain full access to the note: DOWNLOAD FILE