Home » mcq » Database systems » 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
Answer is Wrong!
Answer is Right!
The correct answer is A. record.
A tuple is a row in a table.
288 64 288 64S117.2 64 74.6 75.5c-23.5 6.3-42 24.9-48.3 48.6-11.4 42.9-11.4 132.3-11.4 132.3s0 89.4 11.4 132.3c6.3 23.7 24.8 41.5 48.3 47.8C117.2 448 288 448 288 448s170.8 0 213.4-11.5c23.5-6.3 42-24.2 48.3-47.8 11.4-42.9 11.4-132.3 11.4-132.3s0-89.4-11.4-132.3zm-317.5 213.5V175.2l142.7 81.2-142.7 81.2z"/>
Subscribe on YouTube
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.