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).
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.
-1.png)
Figure 2-25
-2.png)
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
Step by Step Solution
3.27 Rating (176 Votes )
There are 3 Steps involved in it
ER diagrams in Figure 225 a The ERD for City B does not nor does any ERD tell us why the cardinality ... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
613-CS-DB (1594).docx
120 KBs Word File
