In an inventory system on a database management system DBMS), one stored record contains part number, part name, part color, and part weight. These individual items are called:
Answer(s): A
A record is a collection of related data items fields). A field data item) is a group of characters representing one unit of information.
An inventory clerk, using a computer terminal, 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:
Answer(s): D
A record is a collection of related data items fields). A field data item) is a group of characters representing one unit of information. The part number, part description, etc., are represented by fields.
Which of the following is the elementary unit of data storage used to represent individual attributes of an entity?
Answer(s): B
A data item or field) is a group of characters. It is used to represent individual attributes of an entity, such as an employee's address. A field is an item in a record.
A file-oriented approach to data storage requires a primary record key for each file.Which of the following is a primary record key?
The primary record key uniquely identifies each record in a file. Because there is only one record for each vendor in an accounts payable master file the vendor number would be the appropriate key.
A business is designing its storage for accounts receivable information.What data file concepts should be used to provide the ability to answer customer inquiries as they are received?
Answer(s): C
A record key is an attribute that uniquely identifies or distinguishes each record from the others. An index is a table listing storage locations for attributes, often including those other than the unique record key attribute. A pointer is a data item that indicates the physical address of the next logically related record.
Post your Comments and Discuss IIA IIA-CIA-PART3-3P exam prep with other Community members:
Our website is free, but we have to fight against AI bots and content theft. We're sorry for the inconvenience caused by these security measures. You can access the rest of the IIA-CIA-PART3-3P content, but please register or login to continue.