In an electronic database, which statement about fields is accurate?

In an electronic database, which statement about fields is accurate?

• A. contain many facts about a person or item
• B. contain all collected facts about many items or people
• C. can have duplicate names
• D. contain one fact about a person or item

Answer: (D)

Fields in a database represent a single data item for each record. For a given person or item, a field stores one fact, such as a last name or a product code. Because of that, a field cannot hold multiple facts; it holds one value per record. This is why the statement that a field contains one fact about a person or item is correct. By contrast, a field does not hold all facts about many items—that would be the role of a table or dataset containing many records with many fields. Also, field names must be unique within a table, so the idea that a field can have duplicate names isn’t correct. In short, fields define single data items for each record, making the one-fact description the accurate one.

Fields in a database represent a single data item for each record. For a given person or item, a field stores one fact, such as a last name or a product code. Because of that, a field cannot hold multiple facts; it holds one value per record. This is why the statement that a field contains one fact about a person or item is correct. By contrast, a field does not hold all facts about many items—that would be the role of a table or dataset containing many records with many fields. Also, field names must be unique within a table, so the idea that a field can have duplicate names isn’t correct. In short, fields define single data items for each record, making the one-fact description the accurate one.