Guest

IDFirstNameLastNamePhoneNumberEmailAddress
1JohnDoe+1234567890john@example.com
2JaneSmith+0987654321jane@example.com
3AliceBrown+1112223334alice@example.com
4BobWhite+2223334445bob@example.com
5CarolBlack+3334445556carol@example.com

EventType

TypeIDName
1Wedding
2Corporate Event
3Conference
4Party
5Exhibition

Event

EventIDDateStartTimeEndTimeTypeID
(→ EventType.TypeID)
12022-01-01 18:00:0019:00:0022:00:001
22022-02-01 18:00:0019:00:0022:00:002
32022-03-01 18:00:0019:00:0022:00:003
42022-04-01 18:00:0019:00:0022:00:004
52022-05-01 18:00:0019:00:0022:00:005

Venue

VenueIDAddressCapacitySpecialOccasionLocationLocationDescription
11 High Street500Wedding VenueHigh StreetA beautiful wedding venue with a capacity of 500 guests.
22 Low Street300Wedding VenueLow StreetAn intimate wedding venue with a capacity of 300 guests.
33 High Street400Corporate Event SpaceHigh StreetA modern corporate event space with a capacity of 400 guests.
44 Low Street200Corporate Event SpaceLow StreetA classic corporate event space with a capacity of 200 guests.
55 Main Street550Multi-purpose HallMain StreetA versatile multi-purpose hall with a capacity of 550 guests.

Booking

BookingIDGuestIDEventIDVenueIDNumberOfGuests
(→ Guest.ID)(→ Event.EventID)(→ Venue.VenueID)
1111200
2222150
3333300
4444100
5555500