## Guest

ID | FirstName | LastName | PhoneNumber | EmailAddress
--- | --- | --- | --- | ---
1 | John | Doe | +1234567890 | john@example.com
2 | Jane | Smith | +0987654321 | jane@example.com
3 | Alice | Brown | +1112223334 | alice@example.com
4 | Bob | White | +2223334445 | bob@example.com
5 | Carol | Black | +3334445556 | carol@example.com

## EventType

TypeID | Name
--- | ---
1 | Wedding
2 | Corporate Event
3 | Conference
4 | Party
5 | Exhibition

## Event

EventID | Date | StartTime | EndTime | TypeID
--- | --- | --- | --- | ---
|  |  |  | (→ EventType.TypeID)
1 | 2022-01-01 18:00:00 | 19:00:00 | 22:00:00 | 1
2 | 2022-02-01 18:00:00 | 19:00:00 | 22:00:00 | 2
3 | 2022-03-01 18:00:00 | 19:00:00 | 22:00:00 | 3
4 | 2022-04-01 18:00:00 | 19:00:00 | 22:00:00 | 4
5 | 2022-05-01 18:00:00 | 19:00:00 | 22:00:00 | 5

## Venue

VenueID | Address | Capacity | SpecialOccasionLocation | Location | Description
--- | --- | --- | --- | --- | ---
1 | 1 High Street | 500 | Wedding Venue | High Street | A beautiful wedding venue with a capacity of 500 guests.
2 | 2 Low Street | 300 | Wedding Venue | Low Street | An intimate wedding venue with a capacity of 300 guests.
3 | 3 High Street | 400 | Corporate Event Space | High Street | A modern corporate event space with a capacity of 400 guests.
4 | 4 Low Street | 200 | Corporate Event Space | Low Street | A classic corporate event space with a capacity of 200 guests.
5 | 5 Main Street | 550 | Multi-purpose Hall | Main Street | A versatile multi-purpose hall with a capacity of 550 guests.

## Booking

BookingID | GuestID | EventID | VenueID | NumberOfGuests
--- | --- | --- | --- | ---
| (→ Guest.ID) | (→ Event.EventID) | (→ Venue.VenueID) |
1 | 1 | 1 | 1 | 200
2 | 2 | 2 | 2 | 150
3 | 3 | 3 | 3 | 300
4 | 4 | 4 | 4 | 100
5 | 5 | 5 | 5 | 500