The relational model uses some unfamiliar terminology. A tuple is equivalent to a: A. record B. field C. file D. data base E. data item

record
field
file
data base E. data item

The correct answer is A. record.

A tuple is a row in a table. It is a set of values that describes an entity. For example, a table of employees might have a tuple for each employee, with columns for the employee’s name, ID number, department, and salary.

A field is a column in a table. It is a single attribute of an entity. For example, the table of employees might have a field for the employee’s name, a field for the employee’s ID number, a field for the employee’s department, and a field for the employee’s salary.

A file is a collection of records. It is a physical storage unit for data. For example, a table of employees might be stored in a file on a hard drive.

A database is a collection of files. It is a logical storage unit for data. For example, a database of employees might contain files for all of the employees in a company.

A data item is the smallest unit of data. It is a single value that represents an attribute of an entity. For example, the employee’s name is a data item in the table of employees.

Exit mobile version