Techniques

technique_idtechnique_name
1Manual_Photography
2Landscape_Photography
3Night_Photography
4Wedding_Photography
5Street_Photography

Photographers

photographer_idnameexperience
1John Doe8
2Jane Smith6
3Michael Johnson7
4Emily Davis9
5David Brown10

Workshop_Sessions

session_idworkshop_titlestart_timeend_time
1Introduction to Portrait Photography2022-01-01 10:00:002022-01-01 16:00:00
2Mastering Landscape Photography2022-01-02 10:00:002022-01-02 16:00:00
3Capturing Night Skies2022-01-03 10:00:002022-01-03 16:00:00
4Perfecting Wedding Photography2022-01-04 10:00:002022-01-04 16:00:00
5Urban Exploration Through Street Photography2022-01-05 10:00:002022-01-05 16:00:00

Photography_Workshops_Techniques

idphotography_workshop_idtechnique_id
(→ Photography_Workshops.workshop_id)(→ Techniques.technique_id)
111
222
333
444
555
621
731
841
951

Participants

participant_idfirst_namelast_nameemail
1AliceSmithalicesmith@example.com
2BobJohnsonbobjohnson@example.com
3CarolWilliamscarolwilliams@example.com
4DaveBrowndavebrown@example.com
5EveWhiteevewhite@example.com

Enrollments

enrollment_idparticipant_idworkshop_session_id
(→ Participants.participant_id)(→ Workshop_Sessions.session_id)
111
222
333
444
555

Photography_Workshops

workshop_idworkshop_leader_id
(→ Photographers.photographer_id)
11
22
33
44
55