I want to solve the following:
Give the names of any module which are taken by all the students currently enrolled in the Visual Arts School.

Following are the database tables

Code:
Create table School
	(SchoolID		varchar2(5), 
	SchoolName		varchar2(25),
 	Site			varchar2(25),
	constraint pk_s1 primary key(SchoolID)	);

Create table Lecturer
	(LecturerID		varchar2(5), 
	LecturerName		varchar2(20),
 	SchoolId		varchar2(5),
	Specialism		varchar2(30),
	constraint pk_l1 primary key(LecturerID),				
	constraint fk_s1 foreign key(SchoolId) references School(SchoolId)	);

Create table DegreeCourse
	(CourseId		varchar2(5),
	CourseTitle		varchar2(30),
	CurriculumLeaderID	varchar2(5),
	SchoolId		varchar2(5),
	constraint pk_c1 primary key(CourseId),				
	constraint fk_l1 foreign key(CurriculumLeaderID) references Lecturer(LecturerID),	
	constraint fk_s2 foreign key(SchoolId) references School(SchoolId));


Create table Module
	(ModuleID		varchar2(5), 
	ModuleTitle		varchar2(30),	
	CwWeight		number(3),
	ExamWeight		number(3),
	constraint pk_m1 primary key(ModuleID)     );

		
Create table ModuleTeam
	(ModuleID		varchar2(5),
	LecturerID		varchar2(5),		
	StartDate		date,
	TeamStatus		varchar2(20),
	constraint pk_mt1 primary key(LecturerID,ModuleID,StartDate),
	constraint fk_l2 foreign key(LecturerID) references Lecturer(LecturerID),
	constraint fk_m1 foreign key(ModuleID) references Module(ModuleID)	);
			

Create table StudyProgramme
	(CourseId		varchar2(5), 	
	ModuleID		varchar2(5),
	ModuleStatus		varchar2(20), 
	constraint pk_sp1 primary key(CourseId,ModuleID),		
	constraint fk_c1 foreign key(CourseId) references DegreeCourse(CourseId),
	constraint fk_m2 foreign key(ModuleID) references Module(ModuleID)	);


Create table Student
	(StudentID		varchar2(6),
	FirstName		varchar2(20),
	LastName		varchar2(20),
	CourseId		varchar2(5),
	DateEnrolled		date,
	DateWithdrawn		date,
	DateGraduated		date,
	constraint pk_st1 primary key(StudentID),
	constraint fk_c2 foreign key(CourseId) references DegreeCourse(CourseId)	);


Create table Registration
	(StudentID		varchar2(6), 
	ModuleID		varchar2(5), 
	Year			char(2), 
	Semester		char(1),  
	CwMark			number(2),
	ExamMark		number(2), 
	constraint pk_r1 primary key(StudentID,ModuleID,Year,Semester),		
	constraint fk_st1 foreign key(StudentID) references Student(StudentID),
	constraint fk_m3 foreign key(ModuleID) references Module(ModuleID)  );
I tried this but could not proceed further

SELECT where not exists (SELECT SP.MODULEID FROM SCHOOL S, DEGREECOURSE DC, STUDYPROGRAMME SP WHERE S.SCHOOLID=DC.SCHOOLID and S.SCHOOLNAME='Visual Arts' and DC.COURSEID=SP.COURSEID)

Please help