Use Table 1 to answer questions 35 and 36. Table 1: TableStudent  Reg No  House…

Data Processing WAEC 2023

Use Table 1 to answer questions 35 and 36.

Table 1: TableStudent

 Reg No  House

 Age
 18/001  Yellow  14
 18/002  Blue  15
 18/003  Yellow  15

Columns 2 and 3 in Table 1 cannot be used as primary key because both fields contain

  • different datatypes
  • duplicate values checkmark
  • the same datatype
  • only strings and numbers respectively

The correct answer is: B

Explanation

Columns 2 and 3 in Table 1 cannot be used as a primary key because both fields contain duplicate values.

A primary key is a unique identifier for each record in a database table. It ensures that each record has a distinct value, allowing for efficient data retrieval and maintaining data integrity. In the given TableStudent, the "House" column (Column 2) and the "Age" column (Column 3) both contain duplicate values. For example, the House column has two records with the value "Yellow" and the Age column has two records with the value "15". Since a primary key must have unique values, neither of these columns can be used as the primary key.

Previous Question Next Question

Leave A Comment