Centre Course

SELECT*FROM CENTRES,CENTRES_COURSES,COURSES WHERE CENTRES.CENTRE_NO=CENTRES_COURSES.CENTRE_NO AND CENTRES_COURSES.CENTRE_NO='CN01';

SELECT*FROM LECTURERS,COURSES_LECTURERS,COURSES WHERE LECTURERS.LECTURER_ID = COURSES_LECTURERS.LECTURER_NO AND COURSES_LECTURERS.LECTURERS_NO ='L01';

SELECT *FROM STUDENTS,BOOKINGS,BOOKINGS_COURSES,COURSES WHERE STUDENTS.STUDENT_NO=BOOKINGS.STUDENT_NO AND BOOKINGS.BOOKING_REF_NO=BOOKINGS_COURSES.BOOKING_REF_NO AND BOOKINGS_COURSES.COURSE__CODE =COURSES.COURSE__CODE AND STUDENTS.STUDENT_NO='ST01';

-*-*-*-*-*-**---------------------------------------------------------------------------------------------SELECT BOOKINGS_COURSES.BOOKING_REF_NO,BOOKINGS.BOOKING_DATE,BOOKINGS.STUDENT_NO, STUDENTS.STUDENT_NAME,STUDENTS.STUDENT_D_O_B,BOOKINGS_COURSES.COURSE__CODE, COURSES.COURSE_NAME,COURSES.START__DATE,COURSES.COST_OF_COURSE FROM STUDENTS,BOOKINGS,BOOKINGS_COURSES,COURSES WHERE STUDENTS.STUDENT_NO=BOOKINGS.STUDENT_NO AND BOOKINGS.BOOKING_REF_NO=BOOKINGS_COURSES.BOOKING_REF_NO AND BOOKINGS_COURSES.COURSE__CODE =COURSES.COURSE__CODE AND STUDENTS.STUDENT_NO='ST01';

SELECT*FROM LECTURERS,COURSES_LECTURERS,COURSES,CENTRES_COURSES,CENTRES WHERE LECTURERS.LECTURER_NO=COURSES_LECTURERS.LECTURER_NO AND COURSES_LECTURERS.COURSE__CODE=COURSES.COURSE__CODE AND COURSES.COURSE__CODE=CENTRES_COURSES.COURSE__CODE AND CENTRES_COURSES.CENTRE_NO=CENTRES.CENTRE_NO AND COURSES_LECTURERS.LECTURER_NO='L01';

SELECT LECTURERS.LECTURER_NAME,LECTURERS.LECTURER_TEL,CENTRES_COURSES.COURSE__CODE,COURSE _NAME, CENTRES_COURSES.CENTRE_NO,CENTRES.CENTRE_NAME FROM LECTURERS,COURSES_LECTURERS,COURSES,CENTRES_COURSES,CENTRES WHERE LECTURERS.LECTURER_NO=COURSES_LECTURERS.LECTURER_NO AND COURSES_LECTURERS.COURSE__CODE=COURSES.COURSE__CODE AND COURSES.COURSE__CODE=CENTRES_COURSES.COURSE__CODE AND CENTRES_COURSES.CENTRE_NO=CENTRES.CENTRE_NO AND COURSES_LECTURERS.LECTURER_NO='L01';

SELECT CENTRES.CENTRE_NAME,CENTRES_COURSES.CENTRE_NO,COURSES_LECTURERS.LECTURER_NO, LECTURERS.LECTURER_NAME,LECTURERS.LECTURER_TEL,CENTRES_COURSES.COURSE__CODE,COURSE _NAME FROM LECTURERS,COURSES_LECTURERS,COURSES,CENTRES_COURSES,CENTRES WHERE LECTURERS.LECTURER_NO=COURSES_LECTURERS.LECTURER_NO AND COURSES_LECTURERS.COURSE__CODE=COURSES.COURSE__CODE AND COURSES.COURSE__CODE=CENTRES_COURSES.COURSE__CODE AND CENTRES_COURSES.CENTRE_NO=CENTRES.CENTRE_NO AND CENTRES_COURSES.CENTRE_NO='CN02'; SELECT*FROM COURSES,COURSES_LECTURERS,LECTURERS WHERE COURSES.COURSE__CODE=COURSES_LECTURERS.COURSE__CODE AND LECTURERS.LECTURER_NO=COURSES_LECTURERS.LECTURER_NO AND COURSES_LECTURERS.LECTURER_NO='L01'; SELECT* FROM CENTRES,CENTRES_COURSES,COURSES WHERE CENTRES.CENTRE_NO=CENTRES_COURSES.CENTRE_NO AND COURSES.COURSE__CODE = CENTRES_COURSES.COURSE__CODE AND CENTRES_COURSES.CENTRE_NO='CN01'; SELECT BOOKINGS_COURSES.COURSE__CODE,COURSE_NAME,COURSE_LEVEL,COST_OF_COURSE,COURSE_DURAT ION, COURSES.START__DATE,BOOKINGS.STUDENT_NO,STUDENTS.STUDENT_NAME FROM STUDENTS,BOOKINGS,BOOKINGS_COURSES,COURSES WHERE STUDENTS.STUDENT_NO=BOOKINGS.STUDENT_NO AND BOOKINGS.BOOKING_REF_NO=BOOKINGS_COURSES.BOOKING_REF_NO AND BOOKINGS_COURSES.COURSE__CODE =COURSES.COURSE__CODE AND BOOKINGS_COURSES.COURSE__CODE='CR01';