Case 10-1 As you prepare to teach a class on the fundamentals of databases, you want to create a real-world example that will help define some of the key terms for this concept. You have a table called AutoRepairDetails, which includes columns labeled Make, Model, LicensePlate, RepairCost, and OwnerName. In this table, which term best describes the role that RepairCost plays in the table?
A) row
B) field
C) record
D) id

Question

Quizplus · Accepted Answer

RepairCost is a specific piece of data within the table and therefore best fits the definition of a field. A row represents a complete set of data for a single entry, a record is the entire set of data for a single entry including all of its fields, and an ID is a unique identifier used to distinguish records from one another. None of these choices best describe the role of RepairCost in the table.

Case 10-1 as You Prepare to Teach a Class on the Fundamentals