Modern Database Management

13th Edition

ISBN: 9780134773650

Author: Hoffer

Publisher: PEARSON

See similar textbooks

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 …

Videos

Textbook Question

Chapter 3, Problem 3.6RQ

Give an example (other than those discussed in the chapter) of a supertype/subtype relationship.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Chapter 3, Problem 3.5RQ

Chapter 3, Problem 3.7RQ

Students have asked these similar questions

Give an example of each subtype and supertype relationship?

What is the definition of subtype hierarchies?

Give an example of each of the following: a. a supertype/subtype relationship where the disjoint rule applies b. a supertype/ subtype relationship where the overlap rule applies

Chapter 3 Solutions

Modern Database Management

Ch. 3 - Define each of the following terms: supertype...Ch. 3 - Match the following terms and definitions:...Ch. 3 - Contrast the following terms: supertype; subtype...Ch. 3 - State two conditions that indicate when a database...Ch. 3 - Prob. 3.5RQ Ch. 3 - Give an example (other than those discussed in the...Ch. 3 - What is the attribute inheritance? Why is it...Ch. 3 - Give an example of each of the following: a...Ch. 3 - What types of business rules are normally captured...Ch. 3 - What is the purpose of a subtype discriminator?

Ch. 3 - Prob. 3.11RQ Ch. 3 - In what ways is starting a data modeling project...Ch. 3 - Prob. 3.13RQ Ch. 3 - Prob. 3.14RQ Ch. 3 - What do you purchase when you acquire a packaged...Ch. 3 - In Figure 3-5b, why must the minimum cardinality...Ch. 3 - When is a member of a supertype always a member of...Ch. 3 - Examine the hierarchy for the university EER...Ch. 3 - Add a subtype discriminator for each of the...Ch. 3 - For simplicity, subtype discriminators were left...Ch. 3 - Refer to the employee EER diagram in Figure 3-2....Ch. 3 - Refer to the EER diagram for patients in Figure...Ch. 3 - Figure 3-13 shows the development Of entity...Ch. 3 - Refer to Problem and Exercise 2-44 in Chapter 2...Ch. 3 - For a library, the entity type HOLDING has four...Ch. 3 - A bank has three types of accounts: checking,...Ch. 3 - Refer to your answer to Problem and Exercise 2-4...Ch. 3 - Refer to your answer to Problem and Exercise 3-24...Ch. 3 - Prob. 3.29PAE Ch. 3 - Draw an EER diagram for the following situation:...Ch. 3 - Develop an EER model for the following situation,...Ch. 3 - Prob. 3.32PAE Ch. 3 - Prob. 3.33PAE Ch. 3 - Prob. 3.34PAE Ch. 3 - Based on the EER diagram constructed for Problem...Ch. 3 - Prob. 3.36PAE Ch. 3 - Prob. 3.37PAE Ch. 3 - Add the following to Figure 3-16: An EMPLOYMENT...

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.

Give an example (other than those discussed in the chapter) of a supertype/subtype relationship.

Solution Summary: The author explains that Teacher is a supertype entity, which has 3 subtype entities i.e., full-time teacher, contract-based teacher and hourly teacher.

Concept explainers

Videos

Want to see the full answer?

Chapter 3 Solutions