Educational_Venues

VenueIDNameTypeAddressCityState
1National History MuseumMuseum123 Main St.WashingtonDC
2Smithsonian Air & Space MuseumMuseum600 Independence Ave SWWashingtonDC
3Adler PlanetariumPlanetarium1300 S Lake Shore DriveChicagoIL
4Field Museum of Natural HistoryMuseum1400 S DuSable Lake Shore Dr.ChicagoIL
5The Franklin Institute Science MuseumMuseum222 N 20th St.PhiladelphiaPA

Tickets

TicketIDPrice
115.0
220.0
325.0
430.0
535.0

Venue_Tickets

VenueIDTicketID
(→ Educational_Venues.VenueID)(→ Tickets.TicketID)
11
12
21
23
32

Visitors

VisitorIDFirstNameLastNameAgeEmail
1JohnDoe30john.doe@example.com
2JaneDoe28jane.doe@example.com
3AliceBrown25alice.brown@example.com
4BobWhite35bob.white@example.com
5CarolGreen40carol.green@example.com

Visit_Records

RecordIDVenueIDVisitorIDDateTime
(→ Educational_Venues.VenueID)(→ Visitors.VisitorID)
1112022-01-0110:00:00
2122022-01-0114:00:00
3212022-01-0210:00:00
4312022-01-0310:00:00
5322022-01-0314:00:00