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 |