b) Consider your responsibility as DBA for designing and maintaining a typical university database for information concerning students, courses and grades. Five different files are needed to organize and store data records of the same type. These are STUDENT file which stores information on students, COURSE file which stores data on each course, SECTION files which store data on each section of a course, GRADE-REPORT files stores data on the grades students received in various sections that they have completed and the PREREQUISITE file stores the prerequisites of each course. i. Create the database tables for this application using SQL. (10 marks) 72 46 ii. Insert a new student by name Johnson, sophomore, studying Math. (3 marks) iii. Change the class of a student by name "Smith" to senior. (3 marks) iv. Delete the record for the student whose name is "john" and whose student number is 17 Deport (3 marks) stused 3 Como Scie