Counting fields and records in a table

Name:

Date:

Class:

Quick Questions

Shade in the A or B circle for each question.

1. A table has a heading row and 6 data rows. How many records does it have?

A 7 records, because the heading row counts as a record

B 6 records, because the heading row is not a record

2. A table has the columns StudentID, Name, Age and Form. How many fields does it have?

A 1 field, because it describes one table

B 4 fields, one for each column

3. A table has 4 fields and 6 records. How many rows does it show, including the heading row?

A 7 rows

B 6 rows

4. In a school database table, what does one record describe?

A One item or person, such as a single student

B One column of values, such as all the student names

5. A teacher adds a new student to the table. What has the teacher added?

A A new record

B A new field

Match the Pairs

Draw a line connecting each item on the left to its match on the right.

Left column		Right column
1StudentID \| Name \| Year		AThe table has 4 columns and 6 data rows, which is 7 rows once the heading row is included.
2Table: 4 fields, 6 records		BA new column is a new field, not a record. The number of records stays the same.
3The number of records is the number of data rows, not counting the heading row		C1 heading row + 5 data rows = 5 records
4Adding a new person to a table adds a record, not a field		DAdd a row: records 5 -> 6, fields stay 3
57 rows including the heading = 7 records		EThe heading row was counted as a record. The table has 6 records, because the heading row only holds the field names.
6Added a Phone column = 1 new record		FA heading row that names 3 fields (3 columns). It is not a record.

Definitions

field and record

Fill in the Blanks

Complete each line of code by filling in the missing parts.

Headings: Name | Age | Form | House Number of fields: _

Rows including heading row: 7 Number of records: _

SELECT _____(*) FROM Pet;

A new student joins the table: add a ______

Fields: 4, Records: 6 Add a new field called Email Fields now: _

Spot the Error

Shade in the letter of the line that contains an error.

Question 1

A Table: Students

B Fields: ID, Name, Year, House

C Number of fields: 6

D Rows below heading: 6

E Number of records: 6

Question 2

A Heading row + 5 data rows

B Records = 6

C Fields = 3

Question 3

A Table has 4 fields, 7 records

B Columns = 4

C Data rows = 6

D Total rows with heading = 7

Question 4

A Start: 4 fields, 6 records

B Add one new student record

C Fields: still 4

D Records: still 6

Question 5

A Start: 4 fields, 6 records

B Add a new column: Email

C Records: still 6

D Fields: still 4

Answer Key

Counting fields and records in a table

Section A: Quick Questions

B — 6 records, because the heading row is not a record

B — 4 fields, one for each column

A — 7 rows

A — One item or person, such as a single student

A — A new record

Section B: Match the Pairs

StudentID | Name | Year → A heading row that names 3 fields (3 columns). It is not a record.

Table: 4 fields, 6 records → The table has 4 columns and 6 data rows, which is 7 rows once the heading row is included.

The number of records is the number of data rows, not counting the heading row → 1 heading row + 5 data rows = 5 records

Adding a new person to a table adds a record, not a field → Add a row: records 5 -> 6, fields stay 3

7 rows including the heading = 7 records → The heading row was counted as a record. The table has 6 records, because the heading row only holds the field names.

Added a Phone column = 1 new record → A new column is a new field, not a record. The number of records stays the same.

Section C: Definitions

field and record — A field is a column and a record is one data row. The heading row is not a record. A table with 4 fields and 6 records has 4 columns and 7 rows including the heading.

Section D: Fill in the Blanks

Headings: Name | Age | Form | House
Number of fields: 4

Rows including heading row: 7
Number of records: 6

SELECT COUNT(*) FROM Pet;

A new student joins the table: add a record

Fields: 4, Records: 6
Add a new field called Email
Fields now: 5

Section E: Spot the Error

C — Four field names are listed (ID, Name, Year, House), so the table has 4 fields. The line should say 'Number of fields: 4'. The 6 is the number of records.

B — The heading row is not a record. 5 data rows means 5 records, so the line should be 'Records = 5'.

A — 7 is the total number of rows including the heading. The heading is not a record, so the table has 6 records. The line should be 'Table has 4 fields, 6 records'.

D — Adding a record adds one data row. The records go from 6 to 7 and the fields stay at 4. The line should be 'Records: now 7'.

D — Adding a column adds a field, so the fields go from 4 to 5. The number of records stays at 6. The line should be 'Fields: now 5'.