Databases

Information system

A software that can organise and analyse business data that helps to streamline day to day business data

Database

A collection of structured , organised data which makes the data easily retrievable and efficiently maintained

Benefits of databases

-They can store large amounts of data

-They hold data in an organised way

-Many users can access the data at the same time

-They can be used in many different types of systems

Flat file database

Simplest form of a database that consists of a single table

Record

One entry in a database that consists of data about someone or something

Database Management System (DBMS)

The software that creates and manages databases

Relational database

A database that stores and provides access to data points that are related to one another

Data redundancy

When data is duplicated, it wastes storage space and time and effort required to enter and update data that is duplicated

Primary key

A unique key that is given to a record when it is inserted in a data base

Foreign key

A column that links two databases together by referencing the primary key of another database and ensures that data relationships remain constant

Entity Relationship Diagram (ERD)

A visual representation of a database that shows tables and the relationship between them

Structured Query Language (SQL)

The programming language of creating databases and their tables and querying databases to extract useful information and delete unnecessary data