Parti- Instructions: Creating Databases [10 Marks] Consider the Relational Schema (below) for designing and creating 3 different databases: Central Database, Engineering Database, and Science Database Implement the followings using Oracle database management system. 1- Write Sql queries to create the 3 databases (below) 2- Write Sql queries to insert values into Central db 3- Write Sql queries and equivalent RA statements to insert values from Central tables into corresponding tables in Engineering and Science dbs 4- Write the equivalent Sql queries for the following RA statements: Central_Student Engineering_Student Science_Student Central_Professor Engineering_Professor Science_Professor Central_Course Engineering_Course u Science_Course Central_Can_Teach Engineering_Can_Teach u Science_Can_Teach Central_Teaches Engineering_Teaches u Science_Teaches Central_Enrolled -Engineering_Enrolled u Science_Enrolled 5. Write RA statement to List of Classes based on (StudentName) in each faculty dbs 6- Write RA statement to List all students in two faculties with GPA4 with student names 7. Write RA statement to List for each course, the average GPA for students registered for that course 8- Write RA statement to List Names of the professors who are teaching a course that they have not said they can teach that course 9. Write RA statement to List all professors and their office locations that can teach both science and engineering courses 10-Write RA statement to List all of the Courses in both the Science department and Engineering Department which are worth 1 credit Central Database Central Student \begin{tabular}{|l|l|l|l|l|} \hline StudentNo & StudentName & Degree & GPA & Department \\ \hline \end{tabular} Central Professor \begin{tabular}{|l|l|l|l|l|} \hline ProfName & EngOffice & EngPhone & SciOffice & SciPhone \\ \hline \end{tabular} Central Course \begin{tabular}{|l|l|l|l|} \hline CourseNo & CourseName & Credits & Department \\ \hline \end{tabular} Central Can Teach \begin{tabular}{|l|l|l|l|} \hline CourseNNo & ProfName & Preference & Evaluation \\ \hline \end{tabular} Central Teaches \begin{tabular}{|l|l|l|} \hline CourseNo & ProfName & Term \\ \hline \end{tabular} Central Enrolled \begin{tabular}{|l|l|l|l|} \hline CourseNNo & ProfName & StudentNo & Status \\ \hline \end{tabular} Engineering Database Engineering_Student \begin{tabular}{|l|l|l|l|l|} \hline StudentNo & StudentName & Degree & GPA & Department \\ \hline \end{tabular} Engineering_Prolessor \begin{tabular}{|l|l|l|} \hline Profname & EngOffice & EngPhone \\ \hline \end{tabular} Engineering Course \begin{tabular}{|l|l|l|l|} \hline CourseNNo & CourseName & Credits & Department \\ \hline \end{tabular} Engineering Can_Teach \begin{tabular}{|l|l|l|l|} \hline Courselvo & ProfName & Preference & Evaluation \\ \hline \end{tabular} Engineering Teaches \begin{tabular}{|l|l|l|} \hline CoursetNo & ProfName & Term \\ \hline \end{tabular} Engineering Enrolled \begin{tabular}{|l|l|l|l|} \hline CourseNo & ProfName & StudentNo & Status \\ \hline \end{tabular} Science Database Science Student \begin{tabular}{|l|l|l|l|l|} \hline StudentNo & StudentName & Degree & GPA & Department \\ \hline \end{tabular} Science Professor \begin{tabular}{|l|l|l|} \hline ProflName & SciOffice & SciPhone \\ \hline \end{tabular} Science Course \begin{tabular}{|l|l|l|l|} \hline CourseNo & CourseName & Credits & Department \\ \hline \end{tabular} Science Can Teach \begin{tabular}{|l|l|l|l|} \hline CourseNo & ProfName & Preference & Evaluation \\ \hline \end{tabular} Science Teaches \begin{tabular}{|l|l|l|} \hline CourseNo & ProfName & Term \\ \hline \end{tabular} Science Enrolled \begin{tabular}{|l|l|l|l|} \hline CourseNNo & ProfName & StudentNo & Status \\ \hline \end{tabular} Part2- Instructions