To implement the database system, you are required toa) provide SQL commands to create the database, its tables, the relationships of thetablesb) Create a text file called YourStudentId-Create.sql (format xxxxxxx-Create.sql) forexample 2225991-Create.sql that will provide SQL commands to:i. create a database called BigM[YourStudentID] (eg BigM30011111)ii. create all of the required tables for the database including their primarykeys, foreign keys and the relationships of tables.c) Create a text file called YourStudentId-Insert.sql (format xxxxxxx-Insert.sql) forexample 2225991-Insert.sql that will provide SQL commands to:i. insert sufficient data into each table you have created to test the queries(at least 5 to 10 records in each table; some table may require less ormore).ii. You are required to include your full name as one of the employee and/orcustomer; but you can provide fake details for your address and contact.d) Create a text file called YourStudentId-Queries.sql (format xxxxxxx-Queries.sql - forexample 2225991-Queries.sql) that contains all of the queries to display the followingreports:1. List of names and complete address of all employees sorted by their salary. Alsoindicate if the employee works fulltime or casual.2. The date on which the most recent customer order has been made. The customername and date of order will suffice.3. List of all the store names and their addresses, sorted in dictionary order of thestore name.4. A list of all customers that have not placed an order yet. Displaying customernumber and name will be sufficient.5. A list containing the name of employees, which work as accountant.6. A list containing the total quantity on hand for each product (product no anddescription) regardless of stores.7. A list showing each product sold (picked) on or before May 20, 2015. Show productnumber, name and quantity sold, sorted by product number and then quantity sold.8. A list of CDs (show CD title, release date and price) whose price is less than orequal to the average CD price.9. Increase each fulltime employee's salary by 7.5% and show the updated salary ofall fulltime employees (name and salary).10. Show all the artist names and CDs in which they appear, sorted by artist first nameand then by last name and finally by CD title.