情境
Residential community managers need to track resident requests for security guard services and schedule guards on patrol routes. The ERD links residents, guards, bookings, patrol routes, and assignments.
這張圖裡有什麼
看懂背後的決策。
01
Modeled Booking as an associative entity connecting Resident and Guard with date, time, and status.
02
Modeled PatrolAssignment as a separate entity to support many-to-many between Guard and PatrolRoute with schedule details.
03
Introduced Community entity to scope residents and patrol routes to a residential community.
Reusable for apartment complexes, gated communities, or HOA-managed security operations that need to coordinate guard bookings and patrol schedules.