Of course,

I'll show the setup of the tables.

CREATE TABLE Event(

EventID number(6),

Location VARCHAR2(50),

Description ...