Table Name Attributes School SchoolID, SchoolName,...

Table Name Attributes School SchoolID, SchoolName, Site Lecturer LecturerID, Lecturer Name, Schoolld, Specialism DegreeCourse CourseID, CourseTitle, CurriculumLeaderID, Schoolld, FeeType Module ModuleID, ModuleTitle, CwWeight, Exam Weight ModuleTeam Moduleld, LecturerID, StartDate, TeamStatus StudyProgramme Courseld, ModuleID, ModuleStatus Student StudentID, FirstName, LastName, CourseID, DateEnrolled, DateWithdrawn, DateGraduated Registration StudentID, ModuleID, Year, Semester, CwMark, ExamMark Fee FeeType, amount

Thanks for your feedback!

Solve the Following MS SQL Question in Database. A Relational Database is to be set up for you to query. The tables in the database are given. The underlined column names are the primary keys for the table, while the columns in red/italic are foreign keys. Q7. Get the module titles of all the modules (for semester 3 2021 registrations) on which registered students who were ever enrolled in courses for which Izaan is the Curriculum Leader. Q8. Find the names of any students (first and last) who are currently enrolled in a course but not registered for any modules. Note that enrolled students will have an enrollment date and will not have a date withdrawn or date graduated. Q9. Give the names of lecturers who have the same specialism as lecturer Khadija Fatima (not including Khadija Fatima). Q10. Who (apart from himself) has ever taught any module that lecturer Khadija Fatima has taught? Q11. Who (apart from himself) has been part of a module team that lecturer Khadija Fatima has been? Lecturers are in the same module team where the start dates for a particular module are equal. The output should be the Lecturer ID and name. Q12. Give the IDs and names of any students (first and last) who are (or have been) registered in more than four modules in any one year, together with the year in which this happened and the number of modules registered for that year. Q13. Which lecturers (by name) have not taught (led or tutored) any module in which student Isbah (first name) has registered. Table Name Attributes School SchoolID, SchoolName, Site Lecturer LecturerID, LecturerName, SchoolID, Specialism DegreeCourse CourseID, CourseTitle, CurriculumLeaderID, SchoolID, FeeType Module ModuleID, ModuleTitle, CwWeight, ExamWeight ModuleTeam ModuleID_LecturerID, StartDate, TeamStatus StudyProgramme CourseID_ModuleID, ModuleStatus Student StudentID, FirstName, LastName, CourseID, DateEnrolled, DateWithdrawn, DateGraduated Registration StudentID_ModuleID_Year_Semester, CwMark, ExamMark Fee FeeType, amount

Play audio

Feedback

Question

Please give Ace some feedback