Database Introduction SS1 Digital Technologies Lesson Note

Subject: Digital Technologies 

Class: SS1

What is a Database?

In your school, the principal needs to keep track of hundreds of students. They need to know your name, your class, your house address, and your grades. If they kept all this on random scraps of paper, it would be a mess!

A Database is an organized collection of related information (data) stored in a way that makes it easy to search, change, and manage.

Real-Life Examples:

• A Phonebook: A database of names and phone numbers.
• Contacts app on your phone: A digital database of your friends.
• The School Register: A database of student attendance.
• The Library Card Catalog: A database of books.

Why use a digital database? Because it is much faster than searching through a physical file. In a digital database, you can find one student out of 5,000 in less than a second!

The DBMS (The Manager)

A database is just the “pile” of data. To actually work with it, you need a special tool called a DBMS (Database Management System).

Think of the database as the Bank Vault (where the money is kept) and the DBMS as the Bank Teller (the person who puts money in or takes it out for you). You don’t just walk into the vault; you talk to the teller.

Common DBMS Software:

1. Microsoft Access: Great for beginners and small businesses.
2. MySQL: Used for big websites like Facebook and YouTube.
3. Oracle: Used by giant banks and governments.

What does the DBMS do?

• It lets you Create a new place to store data.
• It lets you Update data (like changing a student’s address).
• It lets you Delete old data.
• It keeps the data Secure so only the right people can see it.

The Building Blocks (Tables)

In a database, information is stored in Tables. A table looks exactly like a grid in a spreadsheet (Excel), but it is much “stricter” about how data is entered.

A database can have many tables. For example, a “School Database” might have:

• A Students Table.
• A Teachers Table.
• A Subjects Table.

By splitting info into different tables, the database stays neat and organized.

Fields and Records (The Details)

To understand how a table works, you need to know about Fields and Records.

1. Fields (The Columns)

A field is a single category of information. In a student table, “First Name” is a field, and “Date of Birth” is another field.

• Vertical: Fields go up and down.
• Think of them as: The “Questions” the database is asking.

2. Records (The Rows)

A record is a complete set of information about one specific person or thing.

• Horizontal: Records go across the page.
• Think of them as: The “Answers” for one person.

Key Terms & Summary

To wrap up our introduction, there is one more special field you must know about:

The Primary Key

Every record in a table needs a way to be unique. Two students might have the same name (e.g., two boys named “John Smith”). How does the computer tell them apart? We use a Primary Key. This is a field that is different for every single person, like an Admission Number or a NIN. No two people can have the same Primary Key.

Summary Checklist:

• Database: The collection of data.
• DBMS: The software that manages the data.
• Table: The grid where data lives.
• Field: A column (one type of info).
• Record: A row (all info for one person).
• Primary Key: The unique ID for each record.

Class Activity

1. Design a Table: If you were making a “Music Database,” what Fields (columns) would you need? (e.g., Song Title, Artist…).
2. Identify: Look at your School ID card. Which information on that card would be the Primary Key?
3. Discussion: Why is it better to store a phone number as a “Field” rather than just writing it in a long paragraph of text?