What a single-table database is
Name:
Date:
Class:
A
Quick Questions
Shade in the A or B circle for each question.
1. In a database table, what is a column called?
2. In a database table, what is a row called?
3. A school library keeps all its book details in ONE table. What kind of database is this?
4. Which is a field in a table of students?
5. Which is one record in a pet table with the fields Name, Type and Age?
B
Match the Pairs
Draw a line connecting each item on the left to its match on the right.
| Left column | Right column | |
|---|---|---|
| 1field | AA row in a database table that holds all the information about one person, item or event | |
| 2record | BA single-table database has just one table. Many linked tables is a different kind of database. | |
| 3A single-table database keeps all its data in one table, with fields as column headings | CStudents(StudentID, Name, Year, House) | |
| 4One record about one student is a single row holding a value for each field | DA column in a database table that holds one type of information, such as Name or Age | |
| 5Field = a row holding all the details about one student | EA field is a column, not a row. A row is a record. | |
| 6A single-table database has many tables linked together | F101 | Mia Chen | 7 | Red |
C
Definitions
database table
D
Fill in the Blanks
Complete each line of code by filling in the missing parts.
1.
_____: Pets
Fields: Name, Type, Age
2.
Table: Pets
______: Name, Type, Age
3.
Table: Pets
Fields: Name, Type, Age
______: Rex, Dog, 4
4.
Database: SchoolLibrary
Tables: _
5.
Fields: Name, Type, Age
Field count: _
E
Spot the Error
Shade in the letter of the line that contains an error.
Question 1
A
TABLE Pets
B
FIELDS: Name, Age, Type
C
RECORD 1: Milo, 3
D
RECORD 2: Zoe, 5, Cat
Question 2
A
TABLE Books
B
FIELDS: Title, Author, Year
C
RECORD 1: Holes, Sachar, 1998
D
RECORD 2: Matilda, 1988, Dahl
Question 3
A
DATABASE SchoolClub
B
TABLE Members
C
RECORDS: Name, Year, Sport
D
RECORD 1: Ava, 8, Netball
Question 4
A
FIELD Songs
B
FIELDS: Title, Artist, Length
C
RECORD 1: Hello, Adele, 4.5
Question 5
A
TABLE Games
B
FIELDS: Title, Rating, Price
C
FIELD 1: Minecraft, G, 29
D
RECORD 2: Roblox, PG, 0
Answer Key
What a single-table database is
Section A: Quick Questions
Q1
B — A field
Q2
A — A record
Q3
A — A single-table database
Q4
B — FirstName
Q5
A — Milo, Dog, 4
Section B: Match the Pairs
Q1
field → A column in a database table that holds one type of information, such as Name or Age
Q2
record → A row in a database table that holds all the information about one person, item or event
Q3
A single-table database keeps all its data in one table, with fields as column headings → Students(StudentID, Name, Year, House)
Q4
One record about one student is a single row holding a value for each field → 101 | Mia Chen | 7 | Red
Q5
Field = a row holding all the details about one student → A field is a column, not a row. A row is a record.
Q6
A single-table database has many tables linked together → A single-table database has just one table. Many linked tables is a different kind of database.
Section C: Definitions
Q1
database table — A database table stores data in columns called fields and rows called records. A single-table database keeps all its data in this one table.Section D: Fill in the Blanks
Q1
Table: Pets
Fields: Name, Type, AgeQ2
Table: Pets
Fields: Name, Type, AgeQ3
Table: Pets
Fields: Name, Type, Age
Record: Rex, Dog, 4Q4
Database: SchoolLibrary
Tables: 1Q5
Fields: Name, Type, Age
Field count: 3Section E: Spot the Error
Q1
C — A record needs a value for every field. This table has 3 fields (Name, Age, Type), so the record must be RECORD 1: Milo, 3, Dog.
Q2
D — Values must sit in the same order as the fields. 1988 is in the Author position and Dahl is in the Year position. It should be RECORD 2: Matilda, Dahl, 1988.
Q3
C — Name, Year and Sport are the column headings, so they are fields, not records. The line should start with FIELDS:.
Q4
A — Songs is the name of the whole table. A field is just one column inside the table. The line should be TABLE Songs.
Q5
C — A row of data about one game is a record, not a field. Fields are the columns. The line should be RECORD 1: Minecraft, G, 29.