University Student Oracle Database

UNIVERSITY PROJECT FOR ORACLE ORACLE/PLSQL. Full description is in attachment. Most of the project is either done ( Phase1&2 is in attachment or working on). Need help only on STUDENT FUNCTIONS MENU from Phase 3. IMPORTANT: BUSINESS LOGIC HAS TO BE IMPLEMENTED ONLY WITH ORACLE/PLSQL FUNCTIONS ! NO OTHER PROGRAMMING LANGUAGE IS REQUIRED. A database design results in the following relational tables: COURSES (Cno, Ctitle, Hours, DeptId) DEPARTMENTS (DeptId, DeptName, College) INSTRUCTORS (LastName, FirstName, DeptId, Office, Phone, Email) SECTIONS (Term, LineNo, Cno, InstrLname, InstrFname, Room, Days, StartTime, EndTime, Capacity) STUDENTS (Sid, LastName, FirstName, Class, Phone, Street, City, state, Zip, Degree, DeptId, hours, Gpa) ENROLLMENTS (Sid, Term, LineNo, Grade) The COURSES table maintains the list of courses in the university catalog. Information about departments, instructors, and students is maintained in the DEPARTMENTS, INSTRUCTORS, and STUDENTS tables, respectively. Notice that some of the columns in the STUDENTS table are computed columns (gpa, hours) – i.e., their values are determined by other values in other tables. The SECTIONS table maintains the information about the schedule of classes for each term. The ENROLLMENT table keeps information about the enrollment of students in sections. The following is an outline application program for the student database: STUDENT FUNCTIONS MENU (1) Register for courses (2) Add/Drop a course (3) Request Transcript (4) Compute GPA (5) Quit