CIA 592 III.32 – Database – views and records
- This topic has 1 reply, 2 voices, and was last updated 5 months ago by Kevin Hock.
Question ID: CIA 592 III.32 (Topic: Databases)An inventory clerk, using a computer, views the following on screen: part number, part description, quantity on-hand, quantity on-order, order quantity, and reorder point for a particular inventory item. Collectively, these data make up a
- A. Field.
- B. File.
- C. Record.
- D. Database.
The stated answer to this question is “C. Record”, however, this is not the best answer to the question. I will explain:
The part number, part description, and maybe the order quantity and reorder point would be sourced from the item master table; if there were multiple facilities with different reorder points and quantities, these would likely source from a separate table due to the many to one relationship that would exist between the varying reorder points and the item master. The on-hand balance is a field that would be derived from an inventory transaction history file; it is the sum of the inventory transactions. The quantity on order field would be derived from a purchase order table; it is the sum of open purchase orders.
So what this question describes is actually a view, not a record. The fields in this view, coming from multiple tables, collectively would make up a database.
In order for these fields to comprise a record, a multitude of redundancies and inefficiencies would need to exist in the design of the database home to the table in which this record exists.
- You must be logged in to reply to this topic.