MODERN DATABASE MGMT.(PEARSON CHANNEL)
13th Edition
ISBN: 9780136709299
Author: Hoffer
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
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 solutionStudents 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 MGMT.(PEARSON CHANNEL)
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_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_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_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_forwardWhat is the difference between a weak entity and a strong entity that is necessary to have a connection with another entity?arrow_forward
- What'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_forwardDraw an entity relationship diagram (ERD) for the following situations: 2. Whenever new patients are seen for the first time, they complete a patient information form that asks their name, address, phone number, and insurance carrier, all of which are stored in the patient information file. Patients can be signed up with only one carrier, but they must be signed up EXERCISES 248 Chapter 6 Data Modeling *CIN_name CIN_address CIN_phone CINEMA THEATER SHOWING *THE_number THE_capacity *SHO_time SHO_date SHO_attendance *MOV_ID MOV_title MOV_director MOV_rating is contained in offers is offered in is shown at shows MOVIE contains to be seen by the doctor. Each time a patient visits the doctor, an insurance claim is sent to the carrier for payment. The claim must contain information about the visit, such as the date, purpose, and cost. It would be possible for a patient to submit two claims on the same day. to be seen by the doctor. Each time a patient visits the doctor, an insurance claim is…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