Question

What is the Proper E/R diagram for these 5 Departments

1. Entities that support the Volunteer management software:

• Volunteer-Details (entity)
  • Volunteer-name (Entity)
  • Volunteer-age(entity)
  • Volunteer-sex (entity)
• Volunteers clocked in (entity)
• Volunteers clocked out (entity)

2. Entities that support the Guest management software:

• Guest (entity)
• Admission (entity)
  • Guest-name (entity)
  • Guest-age (entity)
  • Guest-sex (entity)
• Beds(entity)
• Shower (entity)
• Laundry-service (entity)
• Meals (entity)
• Basic-medical-care (entity)
• Emergency-services(entity)
• Rule-Violation (entity)

3. Entities that support the Scheduling software:

• Volunteer Shifts(entity)
  • Monday
  • Tuesday
  • Wednesday
  • Thursday
  • Friday
  • Saturday
  • Sunday

• Employee Shifts (entity)
  • • Monday
    • Tuesday
    • Wednesday
    • Thursday
    • Friday
    • Saturday
    • Sunday
  • Guest sign-in (entity)
  • Guest Sign-out(entity)
  • Volunteer sign-in(entity)
  • Volunteer sign-out(entity)

4. Entities that support the Financial management software:

• Full-Time employee pay (entity)
• Part-Time employee pay (entity)
• Supply restock (entity)
• Food purchases (entity)
• Accounts(entity)
  • Monetary Donations(entity)
    • Donor Name (entity)
    • Donor Amount (entity)

• Resources(entity)
  • Food donations(entity)
  • Clothing donations(entity)
  • Supplies Donations(entity)
• Operations(entity)

5. Entities that support the Administrative services software:

• Full-Time Employees (entity)
• Part-Time Employees (entity)
• Job-Councilors(entity)
• Departments (entity)
  • Board members(entity)
  • Administration staff(entity)
  • Social services staff(entity)
  • Technical-Support Staff(entity)
  • Cooking Staff (entity)
  • Janitorial staff(entity)
  • Security(entity)

Answer 1

You can modify the relationship , consider the following images.