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.2RQ
Match the following terms and definitions.
_____composite attribute
_____associative entity
_____unary relationship
_____weak entity
_____attribute
_____entity
_____relationship type
_____cardinality constraint
_____degree
_____identifier
_____entity type
_____ternary
_____optional attribute
- uniquely identifies entity instances
- relates instances of a single entity type
- specifies maximum and minimum number of instances
- relationship modeled as an entity type
- association between entity types
- collection of similar entities
- number of participating entity types in relationship
- property of an entity
- can be broken into component parts
- depends on the existence of another entity type
- relationship of degree 3
- may not have a value
- person, place, object, concept, or event
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Instructions: Create an Entity Relationship Model (focus on the 2 processes only)
What is NOT another name for an associative entity?
Linking table
Bridge entity
Composite entity
Strong entity
A entity instance of one type related to exactly one-entity instance of another type is------?
Many entity instances of one type related to one entity instance of another type is-------?
An entity instance of one type related to many entity instance of another type is--------?
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...
Additional Engineering Textbook Solutions
Find more solutions based on key concepts
The solid steel shaft AC has a diameter of 25 mm and is supported by smooth bearings at D and E. It is coupled ...
Mechanics of Materials (10th Edition)
How does a computers main memory differ from its auxiliary memory?
Java: An Introduction to Problem Solving and Programming (8th Edition)
What is an uninitialized variable?
Starting Out with Programming Logic and Design (5th Edition) (What's New in Computer Science)
What types of coolant are used in vehicles?
Automotive Technology: Principles, Diagnosis, And Service (6th Edition) (halderman Automotive Series)
How are relationships between tables expressed in a relational database?
Modern Database Management
17–1C A high-speed aircraft is cruising in still air. How does the temperature of air at the nose of the aircra...
Thermodynamics: An Engineering Approach
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
- Based on Entity Relationship Diagram (ERD) below; a) Write the correct business rules for all entities. b) Write the suitable relationship name for (a) and (b). RESERVATION GUEST ROOM PK RSV_ID PK GUEST_ID RSV_DATE PK ROOM_ID GUEST_NAME ARRIVAL_DATE (b) ROOM_TYPE GUEST_PHONENO (a) DEPART_DATE ROOM_RATE GUEST_ADDRESS NO_OF_GUESTS FK1 RSV_ID NO_OF_ROOMS FK1 GUEST_IDarrow_forwardWhen an attribute of one entity type references another entity type's attribute, this means that: O it is a derived attribute O weak entity type exists O a relationship exists O it means nothingarrow_forwardDraw an ER diagram with the following data: Entities: Student, Exam, Course ⚫ Relationships: • Student takes at least one exam o An exam is given to at least one student. 。 An exam concerns only one course o A course has a least one exam ■ Attributes: Stud_Roll No, Stud Name, Stud Age, Course_No, Course_Name, Course Hours, Exam_No, Exam date, Exam Duration, Exam_Mark.arrow_forward
- In what way is it different between a weak entity and a strong entity that must have a connection with another entity?arrow_forwardQ.No.1.a. Draw ER- notation for the given elements of ER-Model. Entities Strong Entity Weak Entity Associative Entity Relationship Degree Unary Binary Ternary Relationship Cardinality Mandatory One Mandatory Many Optional One Optional Many Answer: b.Separate Entities and Attributes from the list given below: Skill Student Course Regno DepartmentName ProductID Salary Project DateCompleted Hobby Answer:arrow_forwardWhat distinguishesa weak entity from a strong entity that has a required relationshipto another entity?arrow_forward
- Generalization is the process of defining a general entity type from a collection of specialized entity types Select one: O a. FALSE O b. TRUEarrow_forwardWhat is the difference between a weak entity and one that requires communication?arrow_forwardWhat is the difference between a weak entity and a strong entity that is necessary to have a connection with another entity?arrow_forward
- Why is it recommended that every ternary relationship be converted into an associative entity?arrow_forwardComputer Science You are to ignore attributes and provide ER diagrams that represent the relationship between entities correctly. The entities will be Foo, Bar and Baz. Draw a single ER diagram for the following as described above: A Foo is related to at least one Bar.A Bar is related to at most one Foo.arrow_forwardWhat's the difference between a weak entity and a strong entity that needs to communicate with another?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Enhanced Entity Relationship Model; Author: Data Science Center;https://www.youtube.com/watch?v=ocQUtXPumdQ;License: Standard YouTube License, CC-BY