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
In 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
relationships
i have an ERD question to finish please
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_forwardWrite Relational Schema for all ERD below : Clearly pleasearrow_forwardData standardization usually focuses on fixing _ of data while data cleaning usually focuses on fixing _ of data. A- The entity; data dictionary B- The attribute; the entity C- The entity; the attribute D- Data dictionary; the entityarrow_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_forwardAll entity names, relationship names, and attribute definitions must be correct.arrow_forwardcontinuingarrow_forward
- The "Annual_Sal" attribute in the "BOOK" Entity type is considered as: Main Sub Annual Title ISBN Author Sal ВОK O 1. Key Attribute O 2. Stored Attribute O 3. Derived Attribute O 4. Multi-Valued Attribute 10 The "Title" attribute in "R OOK" Entity Tyne is considered as:arrow_forwardWhich statement is associated with two seperate entities. a) Attribute b) Entity Type c) Reflective Relationship d) Relationshiparrow_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_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