Entity-Relationship Model Wedding_Planner

Diagram

Data requirements

Entity: User

Explanation: The User entity represents a registered person who uses the system to organize and manage weddings and related events. It stores personal and contact information and serves as the main actor that creates weddings, organizes events, and interacts with guests and service providers. The entity is modeled separately to centralize user data and enable secure identification and ownership of weddings.

Candidate keys:

user_id – chosen as the primary key because it is a system-generated, stable, and unique identifier.

email – candidate key because it is unique per user, but not selected as the primary key since it can change.

Attributes:

user_id – numeric, required

first_name – text, required

last_name – text, required

email – text, required, valid email format

phone_number – text, optional

gender – text, optional

birthday – date, optional

Entity: Wedding

Explanation: The Wedding entity represents a specific wedding event being planned and managed in the system. It acts as the central entity that connects all reservations, services, guests, and events related to a wedding. It is modeled as a separate entity to clearly group all wedding-related data and enable independent management of multiple weddings by different users.

Candidate keys:

wedding_id – chosen as the primary key as a unique system-generated identifier.

Attributes:

wedding_id – numeric, required

date – date, required

budget – numeric, optional

notes – text, optional

Entity: Event

Explanation: The Event entity represents individual events related to a wedding, such as ceremonies, receptions, or parties. It allows the system to track schedules, types, and statuses of events. Modeling events separately enables flexibility in planning multiple events for a single wedding.

Candidate keys:

event_id – chosen as the primary key because it uniquely identifies each event.

Attributes:

event_id – numeric, required

event_type – text, required

date – date, required

start_time – time, required

end_time – time, required

status – text, required

Entity: Event_RSVP

Explanation: The Event_RSVP entity records responses of users or guests to event invitations. It is necessary to track attendance confirmations and response statuses for proper event organization.

Candidate keys:

response_id – chosen as the primary key as it uniquely identifies each RSVP response.

Attributes:

response_id – numeric, required

status – text, required

response_date – date, required

Entity: Guest

Explanation: The Guest entity represents individuals invited to the wedding. It stores guest-specific information independently from registered users, as guests do not need system accounts.

Candidate keys:

guest_id – chosen as the primary key.

Attributes:

guest_id – numeric, required

first_name – text, required

last_name – text, required

email – text, optional

Entity: Attendance

Explanation: The Attendance entity represents the participation of guests in wedding events. It enables tracking seating, roles, and attendance status.

Candidate keys:

attendance_id – chosen as the primary key.

Attributes:

attendance_id – numeric, required

status – text, required

table_number – numeric, required

role – text, required

total – numeric, required

Entity: Venue

Explanation: The Venue entity represents physical locations where wedding events take place. It stores capacity, pricing, and contact details to support venue selection and booking.

Candidate keys:

venue_id – chosen as the primary key.

Attributes:

venue_id – numeric, required

name – text, required

location – text, required

city – text, required

address – text, required

capacity – numeric, required

menu – text, optional

phone_number – text, optional

price_per_guest – numeric, required

Entity: Venue_Type

Explanation: The Venue_Type entity categorizes venues (e.g., restaurant, hall, outdoor space). It is separated to ensure data consistency and easy extensibility.

Candidate keys:

type_id – chosen as the primary key.

Attributes:

type_id – numeric, required

type_name – text, required

Entity: Venue_booking

Explanation: The Venue_booking entity represents reservations of venues for weddings. It captures scheduling and pricing information and ensures no booking conflicts occur.

Candidate keys:

booking_id – chosen as the primary key.

Attributes:

booking_id – numeric, required

date – date, required

start_time – time, required

end_time – time, required

status – text, required

price – numeric, required

Entity: Photographer

Explanation: The Photographer entity represents professional photographers available for weddings. It stores contact and pricing information to support booking and comparison.

Candidate keys:

photographer_id – chosen as the primary key.

Attributes:

photographer_id – numeric, required

name – text, required

email – text, required

phone_number – text, required

price_per_hour – numeric, required

Entity: Photographer_booking

Explanation: This entity records bookings of photographers for specific weddings and time periods.

Candidate keys:

booking_id – chosen as the primary key.

Attributes:

booking_id – numeric, required

date – date, required

start_time – time, required

end_time – time, required

status – text, required

Entity: Band

Explanation: The Band entity represents music performers available for weddings. It allows storage of genre, equipment, and pricing information.

Candidate keys:

band_id – chosen as the primary key.

Attributes:

band_id – numeric, required

band_name – text, required

genre – text, required

equipment – text, optional

phone_number – text, required

price_per_hour – numeric, required

Entity: Band_booking

Explanation: The Band_booking entity represents reservations of bands for weddings, including timing and booking status.

Candidate keys:

booking_id – chosen as the primary key.

Attributes:

booking_id – numeric, required

date – date, required

start_time – time, required

end_time – time, required

status – text, required

Entity: Church

Explanation: The Church entity represents religious locations where wedding ceremonies can take place.

Candidate keys:

church_id – chosen as the primary key.

Attributes:

church_id – numeric, required

name – text, required

location – text, required

contact – text, required

Entity: Church_booking

Explanation: The Church_booking entity records church reservations for wedding ceremonies.

Candidate keys:

booking_id – chosen as the primary key.

Attributes:

booking_id – numeric, required

date – date, required

start_time – time, required

end_time – time, required

status – text, required

Entity: Priest

Explanation: The Priest entity represents clergy members who perform wedding ceremonies. It is modeled separately to allow assignment to church ceremonies.

Candidate keys:

priest_id – chosen as the primary key.

Attributes:

priest_id – numeric, required

name – text, required

contact – text, required

Entity-Relationship Model History

*.01 – Initial version of the ER model