Computer Science
Grade 7
20 min
What is a Database?
What is a Database?
Tutorial Preview
1
Introduction & Learning Objectives
Learning Objectives
Define the term 'database' as an organized collection of data.
Explain the purpose of a database is to store, retrieve, and manage data efficiently.
Identify and describe the core components of a simple database: tables, records (rows), and fields (columns).
Differentiate between raw 'data' and meaningful 'information'.
Provide at least three real-world examples of databases they interact with daily.
Explain the concept of a 'primary key' and its role in uniquely identifying records.
Ever wonder how your favorite game saves your high score or how Netflix knows exactly what you watched? 🤔 Let's find out!
In this lesson, you'll discover the secret behind how computers store huge amounts of information. We&...
2
Key Concepts & Vocabulary
TermDefinitionExample
DatabaseAn organized collection of structured data, stored electronically in a computer system. Think of it like a super-smart, digital filing cabinet.Your school's list of all students, their grades, and their contact information is stored in a database.
TableA set of data arranged in rows and columns. A database is usually made up of one or more tables.In a school database, you might have a 'Students' table and a separate 'Classes' table.
Record (or Row)A single entry in a table, containing all the information about one specific item.In a 'Students' table, one record would be all the information for a single student: their ID, name, grade, and homeroom teacher.
Field (or Column)A single piece of information in a record. It defines...
3
Core Syntax & Patterns
The 'One-Thing' Rule (Table Organization)
Each table should store data about only ONE type of thing.
Use this rule when designing a database. Don't mix student information and book information in the same table. Create a 'Students' table and a 'Books' table to keep things organized and prevent confusion.
The 'Unique ID' Rule (Primary Key)
Every record in a table MUST have a unique identifier (a Primary Key).
This is crucial for finding, updating, or deleting a specific record without mistakes. A Student ID is better than a name, because two students could be named 'Alex Chen'.
The 'Consistent Columns' Rule (Data Integrity)
Every record (row) in a table must have the same fields (columns).
This ensures t...
4 more steps in this tutorial
Sign up free to access the complete tutorial with worked examples and practice.
Sign Up Free to ContinueSample Practice Questions
Challenging
You want to create a database for your movie collection. To follow the 'One-Thing' and 'Unique ID' rules, what would be the best structure for a `Movies` table?
A.single field containing the movie title and the director's name.
B.Fields for `Title`, `Genre`, and `Year`, using `Title` as the primary key.
C.Fields for `MovieID` (Primary Key), `Title`, `Director`, `Genre`, and `ReleaseYear`.
D.Fields for `DirectorName` (Primary Key), `MovieTitle`, and `YourRating`.
Challenging
A school needs a `Students` table. Analyze the following designs. Which one is the BEST because it follows all the core database rules taught in the tutorial?
A.Fields: `FullName`, `Grade`, `HomeroomTeacher`. Primary Key: `FullName`.
B.Fields: `StudentID` (Primary Key), `FirstName`, `LastName`, `Grade`.
C.Fields: `StudentID` (Primary Key), `FirstName`, `Grade`, `FavoriteLunch`, `BusNumber`.
D.One table with fields for `StudentID`, `StudentName`, `TeacherName`, `TeacherSubject`.
Challenging
You are given this raw data: 'Pikachu', 'Electric', 25, 'Charmander', 'Fire', 4, 'Squirtle', 'Water', 7. What are the most logical fields (columns) to organize this data into a useful information table?
A.Name, Type, Level
B.Character, Power, Number
C.DataPoint1, DataPoint2, DataPoint3
D.Text, Word, Integer
Want to practice and check your answers?
Sign up to access all questions with instant feedback, explanations, and progress tracking.
Start Practicing Free