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 |