Question 13 Which of the following about enhanced entity relationship modeling is/are correct? Select all that apply (note: partial (positive or negative) credits are assigned to partially correct or incorrect answers respectively; minimum score of the question is zero). When subtypes are overlapping, an additional field must be added to the supertype to act as a discriminator. Subtypes at the lowest level of a hierarchy do not inherit attributes from their ancestors. ✔ In a supertype / subtype hierarchy, attributes are assigned at the highest logical level that is possible in the hierarchy. Regardless of the business situation, a member of the supertype is always a member of more than one subtype. A subtype can become a supertype if the subtype has other subtypes beneath it.

Question 13 Which of the following about enhanced entity relationship modeling is/are correct? Select all that apply (note: partial (positive or negative) credits are assigned to partially correct or incorrect answers respectively; minimum score of the question is zero). When subtypes are overlapping, an additional field must be added to the supertype to act as a discriminator. Subtypes at the lowest level of a hierarchy do not inherit attributes from their ancestors. ✔ In a supertype / subtype hierarchy, attributes are assigned at the highest logical level that is possible in the hierarchy. Regardless of the business situation, a member of the supertype is always a member of more than one subtype. A subtype can become a supertype if the subtype has other subtypes beneath it.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Q: n the attached diagram, which of the following statements are true? primary key for section…

A: Weak entities are represented with double rectangular box in the ER Diagram and the identifying…

Q: Define a weak entity set and a strong entity set

A: (1) An entity set refers to a collection of similar objects, concepts, or ideas that can be uniquely…

Q: What are the principles for deciding how to identify and construct connections between entities in…

A: The ER model is a conceptual tool used to illustrate system data models. It's a graphical…

Q: What is an explanation of the EER (Enhanced Entity-Relationship) framework?

A: To be determine: Improved entity-relationship (EER) model has to be defined.

Q: What exactly is meant by the term "partial dependence," and how does it function? What is the…

A: Introduction: It is related to the second standard form (2NF).

Q: . What are the distinctions between smooth models and layered models when it comes to VES modeling

A: Introduction Virtual Network Functions (VNFs) are virtual network services running on open computing…

Q: List all of the many properties that the Entity-Relationship (ER) model has.

A: 1. Describe the different kinds of characteristics in the Entity-Relationship (ER) model. Solution:…

Q: List the Entity-Relationship (ER) model's various characteristics.

A: - We need to list the characteristics of Entity-Relationship model.

Q: Explain what it is that the Entity-Relationship model does.

A: Entity Relationship model is a simple diagram which depicts the structure of tables and the…

Q: Why are weak and strong entity sets different?

A: Entity sets in database design refer to collections of related entities or objects. Weak entity sets…

Q: 12. Which four types of relationships are valid in Use case Diagram a. Association b. Generalization…

A: Different relationships show connections and interactions between distinct elements in a use-case…

Q: The difference between a weak entity set and a strong entity set should be explained.

A: Strong Entity: A powerful entity does not rely on any other entity in the schema for its existence.…

Q: An entity is represented in an E-R model as a(n):a. arrowb. crow’s footc. dashed lined. none of the…

A: Entity in an E-R model An entity is an object that exists. An entity can be a single thing, person,…

Q: What is weak entity type? The formula? For instance. Alternative specialisation?What does the ER…

A: A weak entity kind in an Entity-Relationship (ER) replica is an entity that cannot be Exclusively…

Q: 3.4. Which statements are correct? a. A weak entity type can only have one attribute type. b. A weak…

A: The solution to the given problem is below.

Q: Are associative entities also weak entities? Why or why not? If yes, is there anything special about…

A: Associative entity: • An associative entity associates the instances of one or more entity types. •…

Concept explainers

Enhanced ER Model

The enhanced ER model is an abbreviation for Enhanced Entity-Relationship (EER) model. As you know, the entity-relationship (ER) model is a pictorial illustration of the relationship between various entities of a domain. In the case of a large amount of data with multiple interrelated entities, the ER diagrams become complex and tough to interpret. For such cases, the need for enhancement in the ER model was observed, and thus, the EER model was designed.

Question

Which of the following about enhanced entity relationship modeling is/are correct?

Question 14
Which of the following about modeling business constraints in EER modeling is/are correct? Select all that apply (note: partial (positive or negative) credits are assigned to partially correct or
incorrect answers respectively; minimum score of the question is zero).
The disjoint rule specifies that if an entity instance of the supertype is a member of one subtype, it MUST simultaneously be a member of another subtype.
Generalization is a top-down process.
A member of a subtype does NOT necessarily have to be a member of the supertype.
A completeness constraint may specify that each entity of the supertype must be a member of some subtype in the relationship.
The overlap rule specifies that if an entity instance of the supertype is a member of one subtype, it can simultaneously be a member of two (or more) subtypes.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

What is an explanation of the EER (Enhanced Entity-Relationship) framework?
What does an associative entity model? a.) Associative entities model pure relationships rather than entities. b.) Associative entities model entities that are independent. c.) Associative entities model the real-world scenarios of ways to look up data. d.) Associative entities model attributes and how they are linked to entities.
What is the difference between a feeble entity set and a robust entity set?
What is NOT another name for an associative entity? Linking table Bridge entity Composite entity Strong entity
a. What is Attribute Driven Design? Describe the process. b. What resources are needed before Attribute Driven Design process can start? c. What is the output of the Attribute Driven Design process?
What exactly is meant by the term "Enhanced Entity-Relationship" (EER) model?
What does it mean to be a weak entity? Give an illustration.