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.

Question

Quizplus · Accepted Answer

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.

When Defining Information (Fields)for a Relation,you Should Ensure That