## Educational_Venues

VenueID | Name | Type | Address | City | State
--- | --- | --- | --- | --- | ---
1 | National History Museum | Museum | 123 Main St. | Washington | DC
2 | Smithsonian Air & Space Museum | Museum | 600 Independence Ave SW | Washington | DC
3 | Adler Planetarium | Planetarium | 1300 S Lake Shore Drive | Chicago | IL
4 | Field Museum of Natural History | Museum | 1400 S DuSable Lake Shore Dr. | Chicago | IL
5 | The Franklin Institute Science Museum | Museum | 222 N 20th St. | Philadelphia | PA

## Tickets

TicketID | Price
--- | ---
1 | 15.0
2 | 20.0
3 | 25.0
4 | 30.0
5 | 35.0

## Venue_Tickets

VenueID | TicketID
--- | ---
(→ Educational_Venues.VenueID) | (→ Tickets.TicketID)
1 | 1
1 | 2
2 | 1
2 | 3
3 | 2

## Visitors

VisitorID | FirstName | LastName | Age | Email
--- | --- | --- | --- | ---
1 | John | Doe | 30 | john.doe@example.com
2 | Jane | Doe | 28 | jane.doe@example.com
3 | Alice | Brown | 25 | alice.brown@example.com
4 | Bob | White | 35 | bob.white@example.com
5 | Carol | Green | 40 | carol.green@example.com

## Visit_Records

RecordID | VenueID | VisitorID | Date | Time
--- | --- | --- | --- | ---
| (→ Educational_Venues.VenueID) | (→ Visitors.VisitorID) |  |
1 | 1 | 1 | 2022-01-01 | 10:00:00
2 | 1 | 2 | 2022-01-01 | 14:00:00
3 | 2 | 1 | 2022-01-02 | 10:00:00
4 | 3 | 1 | 2022-01-03 | 10:00:00
5 | 3 | 2 | 2022-01-03 | 14:00:00