What Is a Database?

What Is a Database?

A database is a place where computers keep lots of information.
Think of it like a big notebook that is very tidy.
Each page in the notebook is called a Table.
A table looks like a grid with rows and columns.
Rows are called Records – they hold one piece of information.
Columns are called Fields – they tell what kind of information is stored, like a name or a score.

How Does a Database Work?

Every record needs a special name so the computer can find it quickly.
That special name is a Primary Key. It is a unique ID for each record.
Sometimes a record needs to point to another table. That link is called a Foreign Key.

When we want to get information from a database, we ask a Query.
A query is a question like “Show me all the scores higher than 90.”
The computer reads the query, looks through the tables, and gives back the answer.

Quick Quiz

1. What Is A Table In A Database?
   a) A piece of furniture
   b) A grid that stores related data
   c) A computer virus

2. Which Term Means A Unique Id For Each Record?
   a) Primary Key
   b) Foreign Key
   c) Field

3. What Do You Call The Question You Ask A Database To Get Information?
   a) A command
   b) A query
   c) A record

Answers

1. B – a grid that stores related data
2. A – primary key
3. B – a query

Great Job! You now know how databases keep information tidy, use keys to stay organized, and answer questions with queries. Keep exploring – data can be a lot of fun!