cavitcakir/sql-database-for-collages

CS 306 Project Sabanci University SPRING 18/19

The project is about creating a database that is going to store course information, information of students that take course and information of instructor of courses.

The course table contains location of the course, time, pre-requisites of the course, which course/courses it is the prerequisite of, which faculty the course belongs to and instructor.

The student table contains the id of the student, name, surname, e-mail, department, sex, which courses that student takes and year.

The instructor table contains name, surname, e-mail, courses given by the instructor, department.

Also, we are going to store which courses are located in which faculties.