Computer Science
Grade 4
20 min
Tables, Fields, and Records: The Building Blocks of a Database
Learn the key components of a database: tables, fields (columns), and records (rows).
What you'll learn
- Identify at least three real-world examples where tables, fields, and records are used to organize information, such as in a classroom roster or a sports team roster.
- Explain the difference between a table, a field, and a record in a database using their own words and providing a simple example for each.
- Create a simple table with at least 3 records, each containing 3 fields, to organize information about their favorite animals, ensuring each field has a clear label.
- Given a pre-made table with incomplete records, apply their understanding to fill in the missing field data correctly for at least 2 out of 3 records.
Tutorial Preview
1
Introduction & Learning Objectives
Learning Objectives
Define the terms table, field, and record.
Identify the fields (columns) and records (rows) in a simple data table.
Explain that a table is used to organize related information.
Create a simple table with appropriate fields for a given topic.
Add a new record with correct information to an existing table.
Explain why organizing information in a database is useful.
Have you ever collected stickers, trading cards, or toys? 🧐 How do you keep track of them all so you can find your favorite one fast?
Today, we're going to become 'Database Detectives'! We'll learn how computers organize information using special building blocks called tables, fields, and records. This is the secret to how websites and apps can find things so quickly!
Real...
2
Key Concepts & Vocabulary
TermDefinitionExample
DatabaseA special, organized collection of information, like a super-smart digital filing cabinet.A school's database holds all the information about students, teachers, and classes.
TableA chart inside a database that holds a list of similar things. It's made of columns and rows, just like a spreadsheet.A 'Students' table in the school database would list all the students.
FieldOne column in a table. It describes one specific piece of information about every item in the list.In the 'Students' table, 'First Name' would be one field, and 'Grade' would be another field.
RecordOne row in a table. It's all the information about one single item in the list.In the 'Students' table, the row with 'Maria�...
3
Core Syntax & Patterns
The Field Rule
One Field = One Type of Information
Every column (field) should only hold one kind of data. For example, a 'Birthday' field should only have dates, and an 'Age' field should only have numbers.
The Record Rule
One Record = One Thing
Every row (record) should contain all the information about one single person, place, or thing. Don't mix information about two different pets in the same row!
The Structure Pattern
Records are Rows, Fields are Columns
This is the most important pattern to remember! When you look at a table, look side-to-side (horizontally) to read a record. Look up-and-down (vertically) to see what a field is.
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
A database for a zoo has a table called 'Animals' with fields for `Name`, `Species`, and `Food`. The zookeeper wants to add information about which habitat each animal lives in (like 'Jungle' or 'Desert'). What is the BEST way to do this?
A.Make a new, separate table for every single animal
B.Add a new field to the 'Animals' table called 'Habitat'
C.Write the habitat next to the animal's name in the `Name` field
D.Create a new database just for habitats
Challenging
Imagine a table where each record is a different country. The fields are `CountryName`, `Continent`, and `Population`. To find all the countries in 'Asia', what is the most important part of the table to look at?
A.The `CountryName` field, to see if it has 'Asia' in the name
B.The `Population` field, to find the biggest number
C.The `Continent` field, to find all records where the data is 'Asia'
D.The total number of records in the table
Challenging
A table for a bake sale has fields: `Item`, `Price`, `BakerName`. Someone suggests adding a field called `DeliciousnessScore` (from 1 to 5). Why might this be a difficult or bad field to add?
A.Numbers are not allowed in a database
B.The table is already full
C.The field name is too long
D.Everyone might have a different opinion on what is delicious
Want to practice and check your answers?
Sign up to access all questions with instant feedback, explanations, and progress tracking.
Start Practicing FreeMore from Database Detectives: Organizing Information Like a Pro
Computer Science for other grades
Frequently asked questions
What grade level is "Tables, Fields, and Records: The Building Blocks of a Database"?
Tables, Fields, and Records: The Building Blocks of a Database is a Grade 4 Computer Science lesson on ExcelOS.
What will I learn in Tables, Fields, and Records: The Building Blocks of a Database?
You'll be able to: Identify at least three real-world examples where tables, fields, and records are used to organize information, such as in a classroom roster or a sports team roster; Explain the difference between a table, a field, and a record….
Is "Tables, Fields, and Records: The Building Blocks of a Database" free to practice?
Yes. You can read the tutorial preview for free, and signing up for a free ExcelOS account unlocks the full tutorial and all practice questions with instant feedback.
How many practice questions are included with Tables, Fields, and Records: The Building Blocks of a Database?
This lesson includes 27 practice questions across multiple difficulty levels, each with instant feedback and explanations.