Introduction to Databases

Welcome to DTS Tech Fit Edu! In this blog post, we will introduce you to databases. If you’re new to databases, this guide is perfect for you. We'll explain what databases are, their uses, key terms, and a simple activity to help you get started.

What Is a Database?

A database is a tool to store and manage information. It organizes data so you can easily find, update, or delete it. Think of it as an advanced version of a spreadsheet.

What Are Databases Used For?

Databases are everywhere. Here are some common uses:

1. Storing customer information for businesses (e.g., names and contact details).

2. Tracking sales and inventory in shops.

3. Managing student records in schools.

4. Organizing medical records in hospitals.

5. Running websites like online stores and social media platforms.

Key Database Terms

Here are some words you should know:

Term	Definition
Database	A collection of organized data.
Table	Stores data in rows and columns, like a spreadsheet.
Row	A single entry in a table; also called a record.
Column	Represents a type of data in a table (e.g., name or age).
Field	The value found where a row and column meet.
Primary Key	A unique identifier for each row in a table.
Foreign Key	Links one table to another using a common field.
Query	A way to ask the database for specific information.
SQL	The language used to work with databases.
Schema	The structure of the database, including tables and fields.
CRUD	Basic actions: Create, Read, Update, Delete.

Activity: Create Your First Database

Let’s try a simple activity.

1. Choose a tool. Use Microsoft Excel, Google Sheets, or any free database software like MySQL.

2. Plan your table. Decide what information you want to store. For example, create a table for your favorite movies.

   • Columns: Title, Genre, Release Year, Rating.

3. Add rows. Fill in your table with a few entries. For example:

   • Row 1: The Lion King, Animation, 1994, 9/10.

   • Row 2: Avengers: Endgame, Action, 2019, 8.5/10.

4. Think about questions. What do you want to find out from your table? For example, “What movies are rated higher than 8?”