Question

8. there is a class entity where the first attribute class code is used as its entity identifier. the other attributes are crs code, class section, class time, room code, prof num. if a designer would like to include an alternate composite primary key in case class code is deleted, what would be the most appropriate composite primary key? a. crs code b. class section and class time c. crs code and class section d. class section

Answer 1

The most appropriate composite primary key would be crs code and class section.

Step-by-step explanation:

If a designer wants to include an alternate composite primary key in case the class code is deleted, the most appropriate composite primary key would be option C: crs code and class section.

An alternate composite primary key is a set of attributes that can uniquely identify each record in a table. In this case, using the crs code and class section as the composite primary key ensures that each combination of the crs code and class section is unique within the table. This would allow the designer to identify each record even if the class code is deleted.