Consider the two E-R diagrams in Figure 2-25, which represent a database of community service agencies and
Question:
Consider the two E-R diagrams in Figure 2-25, which represent a database of community service agencies and volunteers in two different cities (A and B). For each of the following three questions, place a check mark under City A, City B, or Can't Tell for the choice that is the best answer.
Figure 2-25
Transcribed Image Text:
City A City B Can't Tell a. Which city maintains data about only those volunteers who currently assist agencies? b. In which city would it be possible for a volunteer to assist more than one agency? c. In which city would it be possible for a volunteer to change which agency or agencies he or she assists? City A City B Assists Assists AGENCY 0VOLUNTEER AGENCY 0VOLUNTEER
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 37% (16 reviews)
ER diagrams in Figure 225 a The ERD for City B does not nor does any ERD tell us why the cardinality ...View the full answer
Answered By
Branice Buyengo Ajevi
I have been teaching for the last 5 years which has strengthened my interaction with students of different level.
4.30+
1+ Reviews
10+ Question Solved
Related Book For
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi
Question Posted:
Students also viewed these Computer Sciences questions
-
Construct appropriate tables for each of the E-R diagrams in Exercises 2.2 to 2.4.
-
Consider the state diagrams of Figure 12.28. a. Describe the behavior of each. b. Compare these with the branch prediction state diagram in Section 12.4. Discuss the relative merits of each of the...
-
You may have been assigned a CASE or a drawing tool to develop conceptual data models. Using this tool, attempt to redraw all the E-R diagrams in this chapter. What difficulties did you encounter?...
-
Consider a corporate bond with a 10.5% coupon rate, paid semi-annually, $1000 par value and a current market price of $766.70. It matures in exactly 20 years. What is the yield to maturity (YTM) on...
-
Briefly differentiate among the following types of brokerage accounts: a.Single or joint b.Custodial c.Cash d.Margin e.Wrap
-
On January 1, 2017, Tusk Company issued $300 million of bonds with a 6% coupon interest rate. The bonds mature in 10 years and pay interest annually on December 31 of each year. The market rate of...
-
US Obesity Levels by State and over Time These questions refer to the graphs found at http://stateofobesity.org/adult-obesity/ which show a sequence of maps of US states, colored by the proportion of...
-
The section of the sealed joint shown in the figure is loaded by a repeated force P = 6 kip. The members have E = 16 Mpsi. All bolts have been carefully preloaded to Fi = 25 kip each
-
Health care administrationoffers many opportunities to work on committees, teams, or special projects in an HCO. Discuss one such environment and what regulatory entity may have jurisdiction over the...
-
The following table gives monthly data for four years in million tons of consumption of ice cream in a country. Plot the series and comment on the visible seasonality and trend. Estimate the centered...
-
There is a bulleted list associated with Figure 2-22 that describes the entities and their relationships in Pine Valley Furniture. For each of the 10 points in the list, identify the subset of Figure...
-
Contrast the following terms: a. Stored attribute; derived attribute b. Simple attribute; composite attribute c. Entity type; relationship type d. Strong entity type; weak entity type e. Degree;...
-
Describe when an organization would have a need to undertake investment processes.
-
The personnel should be aware that indirect expenses should be minimized or controlled to achieve a target profit, example of which are donations from the organization . medical and surgical...
-
QUESTION 1 PART A ORYX PROPERTIES LIMITED Oryx Properties is one of the largest property investment funds that are listed on the Namibia Stock exchange. Over the years, the company has experienced...
-
What is a Ghost Card in the context of E-Payables? What is a Ghost Card in the context of E-Payables? A card used for making anonymous payments. A physical card used for making payments. A digital...
-
If an elevated AD account gets deleted due to inactivity (stale), can it be restored? a) Yes, all AD accounts can be restored. b) No, all AD accounts must be re-created once they are deleted. c) No,...
-
New project analysis 7. If using the 15th edition of the text (or an earlier edition), refer to the Web Tax Appendix to correctly answer this question. Heskel Inc. is considering a new investment...
-
Cost and revenue functions are given in Figure 4.56. (a) At a production level of q = 3000, is marginal cost or marginal revenue greater? Explain what this tells you about whether production should...
-
Clark, PA, has been engaged to perform the audit of Kent Ltd.s financial statements for the current year. Clark is about to commence auditing Kents employee pension expense. Her preliminary enquiries...
-
The average annual revenue per customer for the mail order firm described in Problems and Exercises 12-33 and 12-35 is $100. The organization is planning a data quality improvement program that it...
-
The mail order firm described in Problem and Exercise 12-33 has about 1 million customers. The firm is planning a mass mailing of its spring sales catalog to all of its customers. The unit cost of...
-
You have been asked to write a brief report on how TQM can be adopted by your organization to improve data quality. Produce a list of reasons why TQM should and should not be adopted, and recommend,...
-
In which one of the following lists are ALL items relevant to the determination of employment income? Employee RPP contributions; signing bonus on accepting employment; use of an employer - owned...
-
what is the shortest maturity bond issued by pfizer that is outstanding?
-
Manufacturing Company Balance Sheet Partial balance sheet data for Diesel Additives Company at August 31 are as follows: Finished goods inventory $89,400 Prepaid insurance 9,000 Accounts receivable...
Study smarter with the SolutionInn App