"Create a relation with primary key and nonkey attributes" is the relational representation for which E-R structure?
A) Weak entity
B) Regular entity
C) Gerund
D) IS-A relationship
E) Transitive dependency

Question

Quizplus · Accepted Answer

The E-R structure of a regular entity is represented as a relation in a relational database. The primary key uniquely identifies each record in the relation, and nonkey attributes are all other attributes that provide additional information about the record but are not used to identify it. Therefore, creating a relation with primary key and nonkey attributes is the correct way to represent a regular entity in a relational database. Choice A (Weak entity) would also have a primary key, but it would be a composite key consisting of the primary key of the related strong entity along with a discriminator attribute. Choices C, D, and E are not related to creating relations in a relational database.

"Create a Relation with Primary Key and Nonkey Attributes" Is