Museum

idnamelocation
1The MetNew York
2British MuseumLondon

Gallery

idmuseum_idname
(→ Museum.id)
11Modern Art Wing
22Ancient Civilizations Hall

Event

idgallery_idevent_typedatedescriptioncapacity
(→ Gallery.id)
11Lecture2023-01-01 19:00:00A lecture on modern art movements.100
21Art Workshop2023-01-02 14:00:00A hands-on workshop for aspiring artists.20

Exhibit

idgallery_idtitleartistyeardescription
(→ Gallery.id)
11Starry NightVincent van Gogh1889A masterpiece depicting a view over the town of Saint-Rémy-de-Provence.
21GuernicaPablo Picasso1937A powerful anti-war painting created after the bombing of Guernica during the Spanish Civil War.

Visitor

idnameemailphone_numbermembership
1John Doejohndoe@example.com+12345678900
2Jane Smithjanesmith@example.com+09876543210

Attendance

idvisitor_idevent_identry_timeexit_time
(→ Visitor.id)(→ Event.id)
1112023-01-01 18:55:002023-01-01 21:15:00
2222023-01-02 13:55:002023-01-02 16:15:00