When defining information (fields) for a relation, you should ensure that:
A. the information for this relation cannot be derived from other information.
B. the information for this relation can be found in other relations.
C. the information can be identified by the primary key and by other fields in the relation.
D. the information can be identified by the foreign key in this relation.
A. the information for this relation cannot be derived from other information.
Your goal when defining information (fields) for a relation is to make sure that the information in each relation is indeed in the correct relation and that the information cannot be derived from other information—the second and third rules of normalization.
You might also like to view...
Consumers may evaluate identical products differently depending on how they are branded
Indicate whether the statement is true or false
An understanding of the cost structure of the market provides marketing managers with:
A) an idea of how low some competitors can price. B) the demographics of target markets. C) the behavioral segmentation of target markets. D) an accurate idea of customers' willingness to pay.
Changing and manipulating the data in an information system is called _____.
A. data warehousing B. cloud computing C. data processing D. resource planning
If a job shop is underutilized, then the input rate for a job shop should be?
a. Equal to the daily output rate b. Less than the daily output rate c. More than the daily output rate d. WIP and input rate are unrelated