What does the Entity-Relationship (ER) Model primarily represent?

The logical view of the system from a data perspective.

Which of the following is NOT a component of the ER Model? A) Entity B) Attribute C) Identifier D) Relationship

C) Identifier

Riddle: I can be physical like a car or conceptual like a course. What am I?

Entity

True or False: A key attribute is an attribute that can have multiple values for a single entity.

False. A key attribute uniquely identifies each entity in the entity set.

The set of all entities of a particular entity type is known as ______.

Entity Set

Which attribute type can consist of multiple values for a given entity?

Multivalued Attribute

In an ER diagram, how is a composite attribute represented?

By an oval comprising of ovals.

What is the cardinality of a relationship where each entity in each entity set can participate only once?

One to One

Which of the following represents a relationship type? A) Oval B) Diamond C) Rectangle D) Circle

B) Diamond

Riddle: I represent the number of entities participating in a relationship set. What am I?

Degree of a relationship set

True or False: A weak entity type has its own key attribute.

False. A weak entity type does not have a key of its own.

The relationship between a weak entity type and its identifying strong entity type is called ______.

Identifying Relationship

What type of relationship involves more than one entity set?

N-ary Relationship

In a binary relationship with total participation on one side, how many tables are required?

Minimum one table.

Fill in the blank: An attribute that can be derived from other attributes is called ______.

Derived Attribute

Which participation constraint indicates that an entity may or may not participate in a relationship?

Partial Participation

Riddle: I’m a relationship where a student can enroll in multiple courses, and each course can have multiple students. What am I?

Many to Many Relationship

True or False: The minimum number of tables required for a Many to Many relationship is two.

False. The minimum is three.

In the ER model, how is a derived attribute represented?

By a dashed oval.

In a one to one relationship with total participation on both ends, how many tables are required?

Minimum one table.

What is the primary key for the relationship in a one to one relationship with no total participation?

Can be either entity's primary key.

Fill in the blank: A sub-class relationship is total if every super-class entity is associated with some ______ entity.

Sub-class

Which type of subclassing allows an entity to relate to multiple sub-classes?

Overlapped subclassing

True or False: In the Enhanced ER Model, specialization refers to creating a more general category.

False. Specialization refers to creating more specific categories.

Riddle: I’m a union of multiple classes, where members can belong to any of the classes. What am I?

Union relationship