Lab 4: Structured Query Language (SQL)

Student Class Room Course Instructor Final Grades Seat Section/Class EnforceSince Faculty/Professor Student  ID int FK PK Name int FK PK Addresses int FK PK Class Room ID int FK PK Seats int FK PK int FK PK Course ID int FK PK Course Name int FK PK Department int FK PK Instructor ID int FK PK Name int FK PK Phone Numbers int FK PK Grade ID int FK PK Grade Name int FK PK int FK PK Seat No int FK PK Seat Position int FK PK int FK PK Section No int FK PK Year int FK PK Semester int FK PK Start date int FK PK Phone Numbers int FK PK Email Addresses int FK PK Gender int FK PK Birth Date int FK PK Section No int FK PK Grade int FK PK Password int FK PK Quarters Offered int FK PK Sections int FK PK Instructor Teaching int FK PK int FK PK Address int FK PK Email Addresses int FK PK Gender int FK PK Birth Date int FK PK Class Time int FK PK Enrollment int FK PK Max Enrollment int FK PK Text Book int FK PK fills takes has teaches Requires teaches takes Prerequisites/courses Taught in has Faculty ID int FK PK Name int FK PK int FK PK Address int FK PK Password int FK PK Dept ID int FK PK Age int FK PK MODIFID DIAGRAM