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
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--------?
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_ID
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
Computers process data under the control of sets of instructions called
Java How to Program, Early Objects (11th Edition) (Deitel: How to Program)
Look at the following description of a problem domain:
Starting Out with Java: From Control Structures through Data Structures (3rd Edition)
Convert each of the following binary representations to its equivalent base ten form: a. 101010 b. 100001 c. 10...
Computer Science: An Overview (12th Edition)
Explain the difference between using a computer program and programming a computer.
Big Java Late Objects
What are the design issues for character string types?
Concepts Of Programming Languages
PERSON AND CUSTOMER Classes Design a class named Person with properties for holding a persons name, address, an...
Starting Out With Visual C# (5th Edition)
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
- Draw 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_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_forwardThe cardinality ratio depends on the real-world meaning of the entity types involved and is defined by the specific application. For the binary relationships below, suggest the cardinality ratios based on your understanding. Clearly state any assumptions you make. # Entity 1 Cardinality Ratio Entity 2 1 Student Social Security No. 2 Student Teacher 3 Classroom Wall 4 Course Text Book 5 Class Instructorarrow_forward
- What distinguishesa weak entity from a strong entity that has a required relationshipto 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_forwardGeneralization is the process of defining a general entity type from a collection of specialized entity types Select one: O a. FALSE O b. TRUEarrow_forward
- What is the difference between a weak entity and one that requires communication?arrow_forwardWhy 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_forward
- What is the difference between a weak entity and a strong entity that is necessary to have a connection with another entity?arrow_forwardWhat's the difference between a weak entity and a strong entity that needs to communicate with another?arrow_forwardWhen is it important to use an associative entity to express a many-to-many relationship?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