UPS 2-DC014: Database Concepts - Fields and Records

Vocabulary flashcards covering the components of a database table, including fields and records, based on Question 6 of the UPS 2-DC014 assessment.

Table 2 (School Database)

A table representing part of a database used by a school to store student information, containing columns for Matric No., Student Name, Class, and State.

Field (in Table 2)

A column in the database table that stores a specific category of student information; Table 2 contains a total of $4$ fields.

Record (in Table 2)

A complete horizontal row in the database table representing an individual student entry; Table 2 contains a total of $3$ records.

Number of fields in Table 2

$4$ (specifically: Matric No., Student Name, Class, and State).

Number of records in Table 2

$3$ (representing the entries for Ahmad Hakimi, Siti Nurul, and Wong Jia Hui).

Examples of fields in Table 2

Matric No. and Class (as well as Student Name and State).

Examples of records in Table 2

"MS24001, Ahmad Hakimi, S1K1, Selangor" and "MS24002, Siti Nurul, S1K2, Johor".