Question 3 Database Schema from Relational model ( 10 marks) Consider the following University student record database STUDENT(StudSin, StudentNo, Name, Major, Bdate) DEPARTMENT(DeptName, DeptNo, location) COURSE(CourseNo, Coursename, CreditHr, DeptNo) ENROLL(StudentNo, CourseNo, SecNo, SemesterYear, Grade) BOOK_ADOPTION(CourseNo, SemesterYear, Book_ISBN) TEXT(Book ISBN, Book_Title, Publisher, Author) SECTION(SecNo, CourseNo, SemesterYear, EmpNo) INSTRUCTOR(EmpSIN, EmpNo, Name, DeptNo) PEREQUISITE(CourseNo, PreNo) i. Identify all foreign keys ii. Draw a relational database schema for the database showing all referential integrities. State any assumption you make (if any). Make sure you underline the primary key as shown in the question in your schema