1. A university has a database tracking student registration for courses, among other data. The three tables for course registration that we are interested in are, STUDENT, COURSE, STUDENT_COURSE. - STUDENT: Contains STUDENT_ID, NAME, and ADDRESS - COURSE: Contains COURSE_ID and COURSE_TITLE - STUDENT_COURSE: Contains STUDENT_ID and COURSE_ID a) List student ID, name, and course title registered for all students. List should be sorted by student name and then by course title. b) Write a query to return the student ID and name of all students who have not registered for any courses. c) A student incorrectly got registered for a PHYSICS course instead of a MATH course. Write an update statement to correct the registration. You have the following details: Student Name = John Doe, Address = Addr1, Current (incorrect) course title = PHYSICS, New course title = MATH 2. Any interesting defect found? 3. How the system works the flow for your application? 4. Difficult project you were successful? 5. Open, edit, save file in unix?
