Modern Database Management (12th Edition)
12th Edition
ISBN: 9780133544619
Author: Jeffrey A. Hoffer, Ramesh Venkataraman, Heikki Topi
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 3, Problem 3.3RQ
Contrast the following terms:
- supertype; subtype
- generalization; specialization
- disjoint rule; overlap rule
- total specialization rule; partial specialization rule
- PARTY; PARTY ROLE
- entity; entity cluster
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
What is an example of a supertype/subtype connection in which the disjoint rule is applicable?
Subtype discriminators serve what purpose?
Define key term subtype discriminator?
Chapter 3 Solutions
Modern Database Management (12th Edition)
Ch. 3 - Define each of the following terms: supertype...Ch. 3 - Prob. 3.2RQCh. 3 - Contrast the following terms: supertype; subtype...Ch. 3 - State two conditions that indicate when a database...Ch. 3 - Prob. 3.5RQCh. 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.11RQCh. 3 - In what ways is starting a data modeling project...Ch. 3 - Prob. 3.13RQCh. 3 - Prob. 3.14RQCh. 3 - What do you purchase when you acquire a packaged...Ch. 3 - Prob. 3.16RQCh. 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.29PAECh. 3 - Prob. 3.30PAECh. 3 - Develop an EER model for the following situation,...Ch. 3 - Draw an EER diagram for the following description...Ch. 3 - Prob. 3.33PAECh. 3 - Prob. 3.34PAECh. 3 - Based on the EER diagram constructed for Problem...Ch. 3 - Prob. 3.36PAECh. 3 - Prob. 3.37PAECh. 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.Similar questions
- Where do entity supertype stored at.arrow_forwardExplain entity sets.arrow_forwardQuestion 6 In order to make it easier to compare the relation scheme diagram to the UML diagram, we (check all that apply): If we realize that we forgot any attributes, we just add them in to the relation scheme diagram. The order of the attributes in the relation scheme mirrors the order in the UML class. Name the relation schemes the plural form of the UML class name. Attribute names in the relation scheme diagram use snake_case. 0 / 1 pointarrow_forward
- Explain how functional dependencies may be used to indicate: • The entity sets student and teacher have a one-to-one relationship set.• Between entity setsstudent and teacher, there is a many-to-one connection set.arrow_forwardWhen should data modeling use supertype/subtype relationships?arrow_forwardData modeling is most often accomplished through the use of a(n) __________________. a. entity-relationship diagram b. data-flow diagram c. functional decomposition diagram d. activity diagramarrow_forward
- Using a graphics program, develop an entity-relationship diagram for a database application for an Internet bookstore where students buy textbooks from a salesperson and receive invoices for their purchases. Use Figure 5.5 as a guide.arrow_forwardData modelling is most often accomplished through the use of a(an) ________________. a. entity-relationship diagram b. data-flow diagram c. functional decomposition diagram d. activity diagramarrow_forwardClearly define the meaning of two types of relationships in the context of a UML class diagram: aggregation and generalisation, and provide examples.arrow_forward
- TRUE or FALSE - Generalization (is-a) is the relationship established between entities to show that sub-entities that are derived from the generalized entity. Select one: a. TRUE b.FALSEarrow_forwardIt's possible to have a main key and a candidate key for the same characteristic.arrow_forwardWhat are the properties of fuzzy relations?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Fundamentals of Information SystemsComputer ScienceISBN:9781305082168Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781285867168Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:9781305082168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Enhanced Entity Relationship Model; Author: Data Science Center;https://www.youtube.com/watch?v=ocQUtXPumdQ;License: Standard YouTube License, CC-BY