Museum

idnameaddressopening_hoursticket_price
1Natural History Museum123 Main St9am - 6pm15.0
2Art Gallery456 Elm St10am - 8pm20.0

Planetarium

idnameaddressopening_hoursticket_price
1Space Exploration Center789 Oak St11am - 5pm15.0
2Astronomy Observatory321 Pine St8pm - 10pm20.0

Tickets

idmuseum_idplanetarium_idticket_typeprice
(→ Museum.id)(→ Planetarium.id)
11NoneAdult15.0
212Family Package40.0
321VIP Pass30.0

Students

idfirst_namelast_nameagestudent_id
1JohnDoe161
2JaneSmith152

Visits

idstudent_idvisit_datetickets_purchased
(→ Students.id)
112023-01-013
222023-01-021