Hello, I need assistance with solving the attached SQL assignment. The task involves the following:Creating a University Database Schema:Design and create tables for entities: students, courses, instructors, enrollments, and departments.Populating the Database with Sample Data:Insert sample records into each table to allow for effective query execution.Writing and Executing SQL Queries:Answer all the questions listed in the assignment by writing SQL queries, running them on Oracle or a local database server, and recording the outputs.Creating a Movie Database:Design and create tables for a movie database $($actors$,$ movies, and actor roles$)$ as specified.Populate the tables with sample data and write the required queries for the provided questions.Submission Requirements:Format the report into sections: Problem, SQL Queries, Results $($screenshots or outputs$).$Include SQL scripts for schema creation, data population, and all queries.Ensure screenshots$/$logs verify query execution and outputs.Please refer to the attached file for the detailed instructions.Thank you!"Final Assignment Submission Format:Your submission should be in a report format $($PDF or Word$)$ with the following sections:Problem Description:Brief explanation of the assignment objectives.SQL Queries:Scripts for creating the database schema.Scripts for populating data into tables.SQL queries for all questions.Results:Screenshots or exported logs of executed queries and their outputs.File Name:Name the file as YourName$\_$YourID$\_$SQLHomework.pdf

$$

$.$

Your task includes:

Creating a university schema with tables for entities such as students, courses, instructors, enrollments, and departments.

Populating the database with sample data to execute the queries effectively.

Answering the provided questions by writing SQL queries, running them on your local server, and recording the results.

Write queries in SQL$,$ on the University schema, to answer each of the following questions:

Find the names of all the instructors from Biology department

Find the names of courses in Computer science department which have $3$ credits

For the student with ID $12345($or any other value$),$ show all course$\_$id and title of all courses registered for by the student.

As above, but show the total number of credits for such courses $($taken by that student$).$ Don't display the tot$\_$creds value from the student table, you should use SQL aggregation on courses taken by the student.

As above, but display the total credits for each of the students, along with the ID of the student; don't bother about the name of the student. $($Don$\text{'}$t bother about students who have not registered for any course, they can be omitted$)$

Find the names of all students who have taken any Comp. Sci. course ever $($there should be no duplicate names$)$

Display the IDs of all instructors who have never taught a couse $($Notesad$1)$ Oracle uses the keyword minus in place of except; $(2)$ interpret "taught" as "taught or is scheduled to teach"$)$

As above, but display the names of the instructors also, not just the IDs.

You need to create a movie database. Create three tables, one for actors$($AID$,$ name$),$ one for movies$($MID$,$ title$)$ and one for actor$\_$role$($MID$,$ AID, rolename$).$ Use appropriate data types for each of the attributes, and add appropriate primary$/$foreign key constraints.

$10.$Insert data to the above tables $($approx $3$ to $6$ rows in each table$),$ including data for actor "Charlie Chaplin", and for yourself $($using your roll number as ID$).$

$11.$Write a query to list all movies in which actor "Charlie Chaplin" has acted, along with the number of roles he had in that movie.

$12.$ Write a query to list all actors who have not acted in any movie

$13.$List names of actors, along with titles of movies they have acted in$.$ If they have not acted in any movie, show the movie title as null. $($Do not use SQL outerjoin syntax here, write it from scratch.$)$

Submission:

Deadline: Exercises must be submitted before $15$ December.

Format: Submit the work as a structured report in PDF or Word format. Include the following sections:

Problem

SQL Queries

Results $($screenshots or outputs$)$

File Name: The file should be named in the format: StudentName$\_$StudentID$\_$SQLHomework.

Submission Method: Upload the report via Moodle.

Academic Integrity:

Plagiarism or sharing of answers will result in a score of zero for all involved parties.

All queries and results must be the student's original work.