INFO6001: Physical Database Design - The University Of Newcastle - Database Management

Internal Code: MAS7631

Database Management:

Questions: 1) Given a student name X, print the names of courses that the student has successfully completed. Print the course code and course name. The student has completed a course when s/he has obtained a final grade P, C, D or HD for the course. 2) Given a course name X, semester Y and year Z, print its timetable. That is, the details of all course offerings including course code, course name, a day of the week, activity, start time, end time, campus, building and room numbers that the course is offered in. 3) Room number 101 in CT building will be closed for refurbishment in trimester 1, 2018. To inform the affected students, we need to get the email addresses of the affected students. Find the student number and email address of students who have classes in Room 101 in CT building for Trimester 1, 2018.