Question

Which relation is created with a composite primary key using the primary keys of the related entities, plus any non-key attributes associative entity of the relationship or associative entity?

A) Associative entity
B) Associative entity with its own key
C) Associative entity with additional key
D) Weak entity

Answer 1

An Associative entity is the relation that uses a composite primary key of related entities along with non-key attributes to define a many-to-many relationship between those entities.

Step-by-step explanation:

The relation that is created with a composite primary key using the primary keys of the related entities, plus any non-key attributes is known as an Associative entity (Option A). An associative entity, sometimes called a junction table or a linking table, is used to associate two or more entities in a many-to-many relationship where it carries the primary keys of each of the entities it connects as its own composite primary key. If additional attributes are needed to further define the relationship, they are included in the associative entity as non-key attributes.