DBMS practical exercises $(1)$Introduction:This assignment focuses on practicing SQL by creating and querying adatabase on a local server. Refer to the sql$.$js demo: Online SQL interpreterto explore sample SQL queries and understand the syntax. Use theknowledge gained from this demo to design and implement a universitydatabase schema on your local server.Your task includes:$1.$ Creating a university schema with tables for entities such asstudents, courses, instructors, enrollments, and departments$\mathrm{.}2.$ Populating the database with sample data to execute the querieseffectively$\mathrm{.}3.$ Answering the provided questions by writing SQL queries, runningthem on your local server, and recording the results.Write queries in SQL$,$ on the University schema, to answer each of thefollowing questions:$1.2.3.$ Find the names of all the instructors from Biology departmentFind the names of courses in Computer science department whichhave $3$ creditsFor the student with ID $12345($or any other value$),$ show allcourse$\_$id and title of all courses registered for by the student$\mathrm{.}4.5.6.7.8.9.$ As above, but show the total number of credits for such courses$($taken by that student$).$ Don't display the tot$\_$creds value from thestudent table, you should use SQL aggregation on courses taken bythe student.As above, but display the total credits for each of the students, alongwith the ID of the student; don't bother about the name of thestudent. $($Don$\text{'}$t bother about students who have not registered forany course, they can be omitted$)$Find the names of all students who have taken any Comp. Sci. courseever $($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 theIDs.You need to create a movie database. Create three tables, one foractors$($AID$,$ name$),$ one for movies$($MID$,$ title$)$ and one foractor$\_$role$($MID$,$ AID, rolename$).$ Use appropriate data types for eachof the attributes, and add appropriate primary$/$foreign keyconstraints$\mathrm{.}10.$ Insert data to the above tables $($approx $3$ to $6$ rows in each table$),$including data for actor "Charlie Chaplin", and for yourself $($usingyour roll number as ID$)\mathrm{.}11.$ Write a query to list all movies in which actor "Charlie Chaplin" hasacted, along with the number of roles he had in that movie$\mathrm{.}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$.$ Ifthey have not acted in any movie, show the movie title as null. $($Donot use SQL outerjoin syntax here, write it from scratch.$)$Submission: Format: Submit the work as a structured report in PDF or Wordformat. Include the following sections: Problem SQL Queries Results $($screenshots or outputs$)$ File Name: The file should be named in theformat: StudentName$\_$StudentID$\_$SQLHomework.Academic Integrity: Plagiarism or sharing of answers will result in a score of zero for allinvolved parties. All queries and results must be the student's original work.Technical Requirements: Use a specific SQL database on Oracle system for executing thequeries. Include screenshots or exported logs of the database environment toverify query execution