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: 40% (15 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
-
https://learn-eu-central-1-prod-fleet01-xythos.content.blackboardcdn.com/5e0dab4d06809/1462603?X-Blackboard-Expiration=1614794400000&X-Blackboard-Signature=kY2uq9c856vCCpGWn7DOGsF4AQDWEBysLokZzKnvl30%...
-
A study made in the assembly department of a small electronics manufacturing firm revealed that workers typically produce 100 to 150 assemblies in an 8-hour workday. For simplicity, assume the...
-
Create a set of use cases for the following high-level requirements in a housing system run by the Campus Housing Service. The Campus Housing Service helps students find apartments. Owners of...
-
Distinguish between copyright, patents, and trademarks. Why is it difficult to assert copyright in the age of globalization? What legal action is available to a company when its trademarks are...
-
Global Green Books Publishing produces customized eBooks for a local college. It has just received an order for a new eBook on Strategic Human Resource Management in a Global Context from a senior...
-
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;...
-
Figure 17-61 shows a full-wave-rectified sine wave representing the voltage applied to the terminals of an LC series circuit. Use the trigonometric Fourier series to find the voltages across the...
-
ABC Inc. is a company which sells air tickets. Its line of business is generally considered quite stable and low risk. ABC Inc. is considering expanding into the tourism business. Tourism is...
-
How to Understand e-mail, memos, and the professional standards for their usage, structure, and format in the digital era workplace? Why do Workers complain About E-Mails? Writing Interoffice Memos
-
Which version of Thomas King's narrative ('A short history of Indians in Canada') made the greater impact on you and why: the narrative as a short story text or as cartoon animation? Give reasons for...
-
Can our expression of emotions be managed or is that out of our control - and in many situations, dependent on the other person in our relationship? Explain/justify your answer with at least 2 clear...
-
Why should Este Lauder target innovators from the VALS framework, relate and describe why . For corporate decision-makers The VALS Framework has also been criticized as too culturally specific for...
-
A calf that weighs wo pounds at birth gains weight at the rate dw/dt = 1200 -w, where w is weight in pounds and this time in years. Solve the differential equation.
-
If the annual fixed costs are 54,000 dinars, the occupation expense represents 20%, the contribution margin is 25%, and the unit selling price is 40 dinars. Required: Calculate the closing point of...
-
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,...
-
Racie will receive payments of $550 a month for ten years. What are these payments worth today at a discount rate of 6 percent, compounded monthly?
-
Apple Ltd owns all the share capital of Orange Ltd. In relation to the following intra-group transactions, prepare the notional adjusting journal entries for the consolidation worksheet at financial...
-
What would you offer for a symcor bond that offers a 5.5% coupon (paid semi-annually), has face value of $1,000, and matures in 7 years if similar risk investments offer an expected yield of 5%...
Study smarter with the SolutionInn App