AIT632 Database Management Systems Professor: Sungchul HongPlease use Oracle script to create database and solve following problems.- Create a script (myscript.sql)- Type “spool mylogfile” at “SQL>” prompt (start a new spool)- Run myscript.sql- Type “spool off” at SQL>prompt (end the spool and save it)- Download mylogfile to your computer using FTP- Print the result (table creation, data input, query, query’s result)PROJECTj_num jname cityj1 Sorter Parisj2 Punch Romej3 Reader Athensj4 Console Athensj5 Collator Londonj6 Terminal Osloj7 Tape LondonPARTp_num pname color weight cityp1 Nut Red 12 Londonp2 Bolt Green 17 Parisp3 Screw Blue 17 Romep4 Screw Red 14 Londonp5 Cam Blue 12 Parisp6 Cog Red 19 LondonSUPPLIERs_num s_name status citys1 Smith 20 Londons2 Jones 10 Pariss3 Blake 30 Pariss4 Clark 20 Londons5 Adams 30 AthensSPJs_num p_num j_num qtys1 p1 j1 200s1 p1 j4 700s2 p3 j1 400s2 p3 j2 200s2 p3 j3 200s2 p3 j4 500s2 p3 j5 600s2 p3 j6 400s2 p3 j7 800s2 p5 j2 100s3 p3 j1 200s3 p4 j2 500s4 p6 j3 300s4 p6 j7 300s5 p1 j4 100s5 p2 j2 200s5 p2 j4 100s5 p3 j4 200s5 p4 j4 800s5 p5 j4 400s5 p5 j5 500s5 p5 j7 100s5 p6 j2 200s5 p6 j4 500Note: Qty, status, and weight are numbers and other attributes are varchar type.Exercise1. Get supplier names and numbers for all suppliers who supplied part P3 and whose name begins with letter A.2. Get supplier names and numbers for all suppliers whose name begins with letter A and who supplied parts whose name begins with setter S.3. Get supplier names for suppliers who supplied for job J2. (Use a sub query)4. Get supplier names for suppliers who supplied for jobs in Athens. (Use sub query)5. Get part names for parts that are not supplied for job J3. (Use a sub query)6. Get supplier numbers for suppliers with status lower than that of supplier S1.7. Get supplier numbers and names for suppliers whose status is greater than status values of all suppliers in located Paris.8. Get job numbers for jobs whose city is first in the alphabetical list of the job cities.9. Increase the status values of suppliers by 5 who are located in Paris.10. Change the name to ‘Hammer’ of parts that are Red and located in London and whose name was Screw.11. Delete all jobs in Rome and all corresponding part shipments. (Please use 2