Introduction to Databases

What is a Database?

• A database is a collection of organized data that makes it easy for a computer program to search and store information.
• It can be thought of as an electronic filing system.

Characteristics of a Database

• A database is a persistent store of data, meaning it will exist even when the power is off or the system has a failure.
• Data is organized into a table structure.

Database Structure

• A table is a collection of records, with each record stored as a row.
• Each record is a collection of information called attributes or fields.
• Fields are elements of a database record in which one piece of information is stored (e.g., 'name' in an electronic address book).

Primary Key

• A primary key is a unique identifying value for records in a database.
• Each record must be uniquely identified in order to access individual record details.
• Examples of primary keys include Customer ID in a shop database or patient ID in a doctor's surgery.

Database Usage

• Databases are used in many different settings, for different purposes.
• Examples of database usage include social networks storing information about users and libraries keeping track of book availability.

Learn about databases, their role in digital technology, and how they are used in different settings to store and manage information. Understand how databases work and their applications.