Modern Database Management
13th Edition
ISBN: 9780134773650
Author: Hoffer
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 2, Problem 2.14RQ
Give an example (Other than those described in this chapter) for each of the following, and justify your answer:
- derived attribute
- multivalued attribute
- atomic attribute
- composite attribute
- composite identifier attribute
- optional attribute
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
What do you mean specifically by attribute interpolation?
What's the difference between a simple multivalued attribute and a repeating group?
What are the key distinctions between a straightforward multivalued attribute and a repeating group?
Chapter 2 Solutions
Modern Database Management
Ch. 2 - Define each of the following terms: entity type...Ch. 2 - Match the following terms and definitions....Ch. 2 - Contrast the following terms: stored attribute;...Ch. 2 - Prob. 2.4RQCh. 2 - Prob. 2.5RQCh. 2 - Prob. 2.6RQCh. 2 - State six general guidelines for naming data...Ch. 2 - Prob. 2.8RQCh. 2 - Prob. 2.9RQCh. 2 - State three conditions that suggest the designer...
Ch. 2 - List the four types of cardinality constraints,...Ch. 2 - Give an example, Other than those described in...Ch. 2 - What is the degree of a relationship? List the...Ch. 2 - Give an example (Other than those described in...Ch. 2 - Give an example of each of the following, other...Ch. 2 - Give an example of the use of effective (or...Ch. 2 - State a rule that says when to extract an...Ch. 2 - Prob. 2.18RQCh. 2 - In addition to explaining what action is being...Ch. 2 - For the Manages relationship in Figure 2-12a,...Ch. 2 - Explain the distinction between entity type and...Ch. 2 - Why is it recommended that every ternary...Ch. 2 - A cellular operator needs a database to keep track...Ch. 2 - Prob. 2.24PAECh. 2 - Answer the following questions concerning Figure...Ch. 2 - Prob. 2.26PAECh. 2 - You may have been assigned a CASE or a drawing...Ch. 2 - Consider the two E-R diagrams in Figure 2-25 Q,...Ch. 2 - Prob. 2.29PAECh. 2 - Are associative entities also weak entities? Why...Ch. 2 - Because Visio does not explicitly show associative...Ch. 2 - Figure 2-26 shows a grade report that is mailed to...Ch. 2 - Prob. 2.33PAECh. 2 - The Is Married To relationship in Figure 2-12a...Ch. 2 - Figure 2-27 represents a situation of students who...Ch. 2 - Figure 2-28 shows two diagrams (A and B), both of...Ch. 2 - Prob. 2.37PAECh. 2 - Review Figure 2-8LQ and Figure 2-22. Identify any...Ch. 2 - Prob. 2.39PAECh. 2 - Prob. 2.40PAECh. 2 - Prob. 2.41PAECh. 2 - Prob. 2.42PAECh. 2 - Prob. 2.43PAECh. 2 - Prob. 2.44PAECh. 2 - Prob. 2.45PAECh. 2 - Prob. 2.46PAECh. 2 - Prob. 2.47PAECh. 2 - Prob. 2.48PAECh. 2 - Draw an ERD for the following situation. (State...Ch. 2 - Prob. 2.50PAECh. 2 - Prob. 2.51PAECh. 2 - Review your answer to Problem and Exercise 2-49 if...
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
- Subtype discriminators serve what purpose?arrow_forwardWhat is the distinction between a repeated group and a straightforward multivalued attribute?arrow_forwardGive 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 appliesarrow_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_forwardWhat is the difference between single-valued attribute and multi-valued at attribute and how are these one-of-a-kind from composite attribute and easy attribute?arrow_forwardPlease clear and correct answer.arrow_forward
- Given the following ERD. ID name salary Instructor Grades teaches ID name salary Student 1) What is the descriptive attribute of the relationship between instructor and student? 2) Is this relationship a one-to-one, a one-to-many, or a many-to-many relationship?arrow_forwardExplain Descriptive attributes become more refined?arrow_forwardWhat Are The Feature Selection with Attributes Clustering by Maximal Information Coefficient?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781285867168Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Enhanced Entity Relationship Model; Author: Data Science Center;https://www.youtube.com/watch?v=ocQUtXPumdQ;License: Standard YouTube License, CC-BY