05_create_activities.cypher

CREATE
(Dance:Activity{name:"IsiZulu Dance Competition", activityRef:"ACT001"}),
(Art:Activity{name:"Art Exhibition", activityRef:"ACT002"}),
(Music:Activity{name:"Music Concert", activityRef:"ACT003"}),
(Theatre:Activity{name:"Theatre Performance", activityRef:"ACT004"});

MATCH (MCF:Facility{name:"Modise Cultural Facility"}), (UAC:Facility{name:"Ubuntu Art Centre"}),
(Dance:Activity{name:"IsiZulu Dance Competition"}), (Art:Activity{name:"Art Exhibition"}),
(Music:Activity{name:"Music Concert"}),(theatre:Activity{name:"Theatre Performance"})
CREATE
(MCF)-[:HOSTS_ON_2025_05_20{facilityId:"fac001", activityRef:"ACT001", Date:"2025-05-20"}]->(Dance),
(MCF)-[:HOSTS_ON_2025_06_20{facilityId:"fac001", activityRef:"ACT002", Date:"2025-06-20"}]->(Art),
(UAC)-[:HOSTS_ON_2025_10_20{facilityId:"fac002", activityRef:"ACT003", Date:"2025-10-20"}]->(Music),
(UAC)-[:HOSTS_ON_2025_12_12{facilityId:"fac002", activityRef:"ACT004", Date:"2025-12-12"}]->(theatre);