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.

Consider the two E-R diagrams in Figure 2-25, which represent

Figure 2-25

Consider the two E-R diagrams in Figure 2-25, which represent

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

1 Expert Approved Answer
Step: 1 Unlock

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

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Word file Icon

613-CS-DB (1594).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!