Based on the following requirements for a University database, please write create statements for 5 tables. Please do not use the instructor table and the department table. If you make any further assumptions, please specify those assumptions. Please make sure to identify primary keys, foreign keys and any other possible constraints on the tables. The university is organized into departments. Each department is identified by a unique name (dept name), is located in a particular building, and has a budget. Each department has a list of courses it offers. Each course has associated with it a courseid, title, dept name, and credits, and may also have associated prerequisites. Instructors are identified by their unique ID. Each instructor has name, associated department dept name), and salary Students are identified by their unique ID. Each student has a name, an associated major department (dept name), and tot cred (total credit hours the student earned thus far). . The university maintains a list of classrooms, specifying the name of the building, room number, and room capacity. The university maintains a list of all classes (sections) taught. Each section is identified by a course id, sec id, year, and semester, and has associated with it a semester, year, building, room number, and time slot id (the time slot when the class meets) The department has a list of teaching assignments specifying, for each instructor, the sections the instructor is teaching. . The university has a list of all student course registrations, specifying, for each student, the courses and the associated sections that the student has taken (registered for)