Search Header Logo

Practice Exam: Enhanced Entity-Relationship (EER) Model

Authored by Johnathan Payan

Information Technology (IT)

University

Used 8+ times

Practice Exam: Enhanced Entity-Relationship (EER) Model
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

51 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec โ€ข 1 pt

What is the primary purpose of the Enhanced Entity-Relationship (EER) model?

To replace the traditional E-R model

To extend the E-R model with additional modeling constructs

To simplify database design by removing relationships

To enforce strict one-to-one relationships in all cases

2.

MULTIPLE CHOICE QUESTION

30 sec โ€ข 1 pt

Which of the following best describes a supertype in the EER model?

A generic entity type with common attributes shared by its subtypes

A subgrouping of entities with distinct attributes

A relationship between two entities

A constraint that ensures uniqueness in a database

3.

MULTIPLE CHOICE QUESTION

30 sec โ€ข 1 pt

In the context of supertype/subtype relationships, attribute inheritance means:

Subtypes do not inherit any attributes from the supertype

Subtypes inherit all attributes and relationships from the supertype

Only unique attributes are inherited by the subtypes

Each subtype must have completely different attributes from the supertype

4.

MULTIPLE CHOICE QUESTION

30 sec โ€ข 1 pt

What symbol represents a Total Specialization constraint in an EER diagram?

A single line

A dashed line

A double line

A diamond shape

5.

MULTIPLE CHOICE QUESTION

30 sec โ€ข 1 pt

If an instance of a supertype must be a member of at least one subtype, which rule applies?

Partial Specialization Rule

Total Specialization Rule

Disjoint Rule

Overlap Rule

6.

MULTIPLE CHOICE QUESTION

30 sec โ€ข 1 pt

Specialization is the process of:

Combining multiple entities into one supertype

Dividing an entity into multiple subtypes

Ensuring that an entity belongs to a subtype

Eliminating redundancy in a database

7.

MULTIPLE CHOICE QUESTION

30 sec โ€ข 1 pt

A supertype/subtype hierarchy is used when:

All attributes are unique to individual entities

An entity has multiple categories with shared and unique attributes

Every entity is independent and has no common attributes

All relationships must be one-to-one

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?