Modern Database Management
13th Edition
ISBN: 9780134773650
Author: Hoffer
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Question
Chapter 2, Problem 2.8RQ
Program Plan Intro
Four criteria for selecting identifiers for entities
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
what is another term for an entity unique identifier?
a) local key
b) primary key
c) association
d) foreign key
State four criteria for selecting identifiers for entities.
Use the XYZ Apartment Rental Company ERD shown on Figure 1 to answer questions 9 through 12:
According to the XYZ Apartment Rental Company ER diagram, which of the following is true?
Each building must have more than one builder
Each building must have multiple apartments
Each building must have at least 8 apartments
Each building must have more than 2 apartments
Answer: ____
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
Similar questions
- What is a relation?arrow_forwardUse the XYZ Apartment Rental Company ERD shown on Figure 1 to answer questions 9 through 12: According to the XYZ Apartment Rental Company ER diagram, which of the following is NOTtrue? A building can have no builders A building can have one builder A building can have two builders A building can have more than two builders Answer: ____arrow_forwardIn an ERD, entities do not have columns. Instead which of the following is used to describe the entity's characteristics? Group of answer choices attributes degrees instances relationshipsarrow_forward
- Student StudentID FirstName LastName Major 1. Please list all entities you see from the above figurearrow_forwardQuestion 1 Show the relationships between entities and use table bridges between entities if necessary.arrow_forwardAll entity names, relationship names, and attribute definitions must be correct.arrow_forward
- O 4. Entity set The ISBN in the image below for "BOOK" Entity type is considered as: Main Sub Annual ISBN Author Title Sal ВОOK O 1. Multi-Valued Attribute O 2. Single Attribute 3. Partial key attribute 4. Key attributearrow_forwardWhich statement is associated with two seperate entities. a) Attribute b) Entity Type c) Reflective Relationship d) Relationshiparrow_forwardWhat does the term "Entity type" mean?arrow_forward
- List the guidelines for naming attributes?arrow_forwardQuestion 3: ( DATABASE APPLICATION DEVELOPMENT ) The following table represents the hours worked per week for temporary staff at eachbranch of a company. TempStaffHours staffNo Branch No Branch Office Name Position Hours Address Phone Per Week Center 111125 Seattle, S4555 City Plaza, ВО02 Ellen Assistant 16 Layman WA 98122 S4555 ВО04 16 14th 422263 Ellen Assistant 9. Avenue, Seattle, Layman WA 98128 S4612 Center 111125 City Plaza,Seattle, ВО02 Dave Assistant 14 Sinclair WA 98122 S4612 B004 16 14th 422263 Dave Assistant 10 Avenue, Seattle, WA 98128 Sinclair S4718 Down Town 523632 Mary Kay ВО01 Cleaner 8 Alley, Jersey, JS 76542 a) Determine one anomaly that exist in the TempStaffHours table and criticize thedesign by giving an example of the anomaly. b) Given the following functional dependencies, perform normalization until the third normal form. Give justification related to anomalies on the design of the derived relations. staffNo, BranchNo → BranchAddress, OfficePhone, Name,…arrow_forwardWhat are ASSOciAtive entitieS?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 ScienceISBN:9781285196145Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos CoronelPublisher:Cengage Learning
A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology Ptr
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr