Question

Which relation is created with a composite primary key (which includes the primary key of the entity on which this weak entity depends) and non-key attributes?

A) Associative entity with additional key
B) Super-type
C) Regular entity
D) Weak entity

Answer 1

The correct answer is D) Weak entity, which is a relation that depends on a composite primary key including the primary key of another entity and its non-key attributes. Option d.

Step-by-step explanation:

The relation created with a composite primary key, which includes the primary key of the entity on which this weak entity depends, complemented by its non-key attributes, is known as a weak entity. This design pattern is typically used in scenarios where an entity cannot be identified by its attributes alone and thus relies on a partial key in addition to the primary key of its parent entity. In the given options, the correct answer is D) Weak entity.

A weak entity is an entity that cannot exist on its own and depends on another entity called the identifying entity or owner entity. A composite primary key is a primary key that consists of more than one attribute. In the context of this question, a weak entity can have a primary key that includes the primary key of the identifying entity as well as other non-key attributes.

So, the relation created with a composite primary key and non-key attributes is a weak entity (option D).