| 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 |
| TicketID | Price |
|---|---|
| 1 | 15.0 |
| 2 | 20.0 |
| 3 | 25.0 |
| 4 | 30.0 |
| 5 | 35.0 |
| VenueID | TicketID |
|---|---|
| (→ Educational_Venues.VenueID) | (→ Tickets.TicketID) |
| 1 | 1 |
| 1 | 2 |
| 2 | 1 |
| 2 | 3 |
| 3 | 2 |
| VisitorID | FirstName | LastName | Age | |
|---|---|---|---|---|
| 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 |
| 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 |