## Museum

id | name | address | opening_hours | ticket_price
--- | --- | --- | --- | ---
1 | Natural History Museum | 123 Main St | 9am - 6pm | 15.0
2 | Art Gallery | 456 Elm St | 10am - 8pm | 20.0

## Planetarium

id | name | address | opening_hours | ticket_price
--- | --- | --- | --- | ---
1 | Space Exploration Center | 789 Oak St | 11am - 5pm | 15.0
2 | Astronomy Observatory | 321 Pine St | 8pm - 10pm | 20.0

## Tickets

id | museum_id | planetarium_id | ticket_type | price
--- | --- | --- | --- | ---
| (→ Museum.id) | (→ Planetarium.id) |  |
1 | 1 | None | Adult | 15.0
2 | 1 | 2 | Family Package | 40.0
3 | 2 | 1 | VIP Pass | 30.0

## Students

id | first_name | last_name | age | student_id
--- | --- | --- | --- | ---
1 | John | Doe | 16 | 1
2 | Jane | Smith | 15 | 2

## Visits

id | student_id | visit_date | tickets_purchased
--- | --- | --- | ---
| (→ Students.id) |  |
1 | 1 | 2023-01-01 | 3
2 | 2 | 2023-01-02 | 1