Create course table 2. Add a field named elective to course table whose data type is integer(1) 3. Add Database Applications course to course table 4. Add your data to student table. Assume class id (cid) of your class is 14 5. Delete all courses of Marketing. Code of Marketing courses starts with MKT??? 6. Update credit hours of all courses to 3 7. Display semester name, teacher name, course code and title of all courses allocated to teachers in Fall 2020 8. Display course code, title and total marks (mid marks + terminal marks) of each course you have registered in Fall 2020 9. Display your average marks in Fall 2020 10. Display name of all those teachers who were not allocated any course in Fall 2020 11. Display class name, regtno and student name of those students who have registered only 4 courses in Fall 2020 12. Display code and title of all those course that were not allocated in Fall 2020 13. Create a view that shows semester name and total number of students who have joined that semester 14. Display your fee amount due in Spring 2020. Calculate fee on the base of courses registered x 10000 15. Display program name, class name and strength of each class 16. Display program name and total credit hours of that program 17. Display name and phone number of all those teachers whose name start with A 18. Display regno and name of all those students who have failed a course at-least once 19. Display course code, title and credit_hours of all courses. If credit_hours is zero print Non Credit otherwise print credit_hours value

ERD 01 Teacher l'teacher_id integer l'name varchar2(70) lphone varchar2 (10) lntn varchar2 (10) Semester semester_id integer I.name varchar217) Semester Joining student_id integer semester id integer Doining date date Course Offering *code varchar2(7) *semester_id integer 'classid integer Course Allocation l'allocation_id integer l* code varchar2(7) 1. semester_id integer *teacher 10 integer Registration student_id integer code varchar2(7) semester_id integer class_id integer Pmid_marks integer "terminal marks integer Allocated Class allocation id integer 'classid integer Course l.code varchar2(7) l.title varchar2(100) lecredit hours integer Class *class_id integer "name varchar2(50) program 1d integer Faculty faculty_id integer .name varchar2(50) Program course program_id integer *code varchar2(7) Student * student_id integer "regno varchar2(19) name varchar2(50) address varchar2(200) class_id integer Program lprogram id integer name varchar2(50) He department 1d inetegr Department department is integer l.name varchar2(50) lufaculty id Integer