MODERN DATABASE MGMT.(PEARSON CHANNEL)
13th Edition
ISBN: 9780136709299
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
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
Write Relational Schema for all ERD below :
Clearly please
Data 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 entity
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...
Knowledge Booster
Similar questions
- Question 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_forwardWhat considerations should be taken into account when deciding on the data type for an attribute?arrow_forward
- Question 7 On ERD, you can create attributes with the same name in different Entities. Question 7 options: True Falsearrow_forward2arrow_forwardQuestion 2: For the following table find the relevant Functional Dependencies and resolve them till third normal form. Course Code Course Title Level Mode of Attendance Course Fee Start Date End Date Student ID Num. 14111 14332 14378 Student Name Alan Briggs Susan McBride David Adair 23 Business Accounting 3 Part Time £55.00 20/08/2016 24/08/2016 Student Address 24 Abbey Park, Bangor, BT19 1RT 19 Belmont Road, Bangor, BT19 3TR 14 Grange Park, Bangor, BT19 4TF Student Telephone 028 91468665 07798754623 Department Tutor Dept Head Student DOB 10/08/94 Business Trevor Albright Mr Alan Parkes 028 91584630 06/11/87 07891834277 to Enrolment Date 10/06/16 028 91488930 01/03/93 03/07/16 07891454235 05/07/16 Enrolled By:- Andrea Gilchrist David Smythe Andrea Gilchristarrow_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