The following data apply to the next two questions:Consider the following open purchase order file in which each record contains the following fields:delivery instructionspurchase order datepart numberpurchase order numberquantity orderedunit pricevendor number
Consider the following open purchase order file in which each record contains the following fields:
delivery instructions
purchase order date
part number
purchase order number
quantity ordered
unit price
vendor number
-What data elements should be moved to a separate file to put the open purchase order file in the first normal form?
A) Part number, unit price, quantity ordered
B) Part number, vendor number, purchase order number, quantity ordered
C) Purchase order number, quantity ordered, part number
D) Purchase order number, unit price, quantity ordered

Question

The following data apply to the next two questions:Consider the following open purchase order file in which each record contains the following fields:delivery instructionspurchase order datepart numberpurchase order numberquantity orderedunit pricevendor number
 Consider the following open purchase order file in which each record contains the following fields:
 delivery instructions
 purchase order date
 part number
 purchase order number
 quantity ordered
 unit price
 vendor number
-What data elements should be moved to a separate file to put the open purchase order file in the first normal form?
A) Part number, unit price, quantity ordered
B) Part number, vendor number, purchase order number, quantity ordered
C) Purchase order number, quantity ordered, part number
D) Purchase order number, unit price, quantity ordered

Quizplus · Accepted Answer

First normal form (1NF) requires that the table has no repeating groups or arrays. The given fields do not inherently suggest repeating groups or arrays within a single record; thus, no fields need to be moved to a separate file to achieve 1NF. The options provided do not directly relate to the principles of 1NF, which primarily concerns itself with the atomicity of the data, not the separation based on type or category. My previous response was incorrect in suggesting a choice that implied a need for normalization to achieve 1NF by separating fields into a different table, which is not a requirement for 1NF in the context provided.

The Following Data Apply to the Next Two Questions:Consider the Following