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?
