Write a C program called: ./database CMD OPT1 OPT2 OPT3 OPT4Where:●CMD is a command that performs a specific operation.OPTi are optional arguments depending on CMD.The source file is called: database.cThe executable file is called: databaseThe CSV file is called: database.csvThe argument CMD can have the following values:SHOWDELETEADDdisplays all the records from the database.- OPT1 = ID, that record in removed from the database.- OPT1=ID, OPT2=NAME, OPT3=AGE, OPT4=GPA, anew record with these fields are added to the database.The structure of the CSV file is: ID, NAME, AGE, GPASpaces can exist between the commas, but are not required. In other words, your programshould handle both cases. If a space comes after or before a comma, then it is notconsidered to be part of the field.For example, database.csv could look like this:10, bob, 18, 3.515, mary, 20, 4.05, tom, 17, 3.8Notice the record "tom" has spaces before and after some of the commas. These spacesare not part of the fields. In other words we read: "5" then "tom" then "17" then"3.8", without spaces in the field characters.Create database.csv and database.c in the same directory. Using vim, initializedatabase.csv with the above three records (i.e. bob, mary, tom), with the samespacing and format.Make database.c do the following:1. If the user does not provide any command line arguments, then terminate with anerror message: "Your did not provide any arguments. Please enter: ./databaseCMD OPT1 OPT2 OPT3 OPT4".2. If the CMD argument is not SHOW, not DELETE, not ADD, then terminate theprogram with the error message: "The command you requested in invalid. Pleaseselect from one of these: SHOW, DELETE, ADD".3. The user must input the CMD argument in all caps. BONUS: (optional - no extrapoints) automatically convert the user's CMD to uppercase. 4. If CMD is SHOW, then display all the records like this, without the quotes:"Record 1: ID=nnn NAME=nnn AGE=nnn GPA-nnn"Where nnn is the data from the CSV file. The record number increases for eachrecord displayed. All the records are displayed. Use the %s, %d, and %f correctlyso that the output is displayed in columns (all the ID fields are under each other,all the NAME fields are under each other, etc.). Each record in displayed on anew line. After the records are displayed the program terminates.5. If CMD is DELETE, then there must be an OPT1 argument.a. If this is missing, then the program terminates with the error message:"Name of record to delete is missing"..b. If there are more arguments than OPT1, then they are ignored. This iscalled graceful execution. We assume the first argument is the correctOPT1 and ignore all the other arguments.6. If CMD is ADD, then there must be OPT1, OPT2, OPT3, and OPT4 arguments.a. If less than four OPT arguments are present, terminate the program willthe following error message: "Missing ID, Name, AGE, and GPAarguments".●c. Delete the first record that matches NAME==OPT1. The database.csvfile is updated, and the program terminates. You will need to use atemporary file: database.tmp to copy the records you do not want todelete. Then use the system () command to delete the olddatabase.csv file and rename the database. tmp file into the newdatabase.csv file. If no record matched the search condition thendisplay the following message and terminate: "Sorry, that user was notfound. Nothing was deleted."WHAT TO HAND INEverything must be submitted to TA before the due date. Please hand in thefollowing:b. If there are more arguments, then implement graceful execution.c. It does not matter whether another record with the same name or IDalready exists. Simply append (using fopen (filename. "at")) theneword to the end of the database.csv file.The database.c fileThe database.csv fileA bash compile.sh script that compiles the programs for the TA using gcc.Make sure to add comments to your C program, and add your name as a commentScreen shots to show how well your program complete requirementsREADME documenting how well you finish the assignments: what is completelyfinished, what is partially finished, what is not done at all, etc.

Question

Write a C program called: ./database CMD OPT1 OPT2 OPT3 OPT4Where:●CMD is a command that performs a specific operation.OPTi are optional arguments depending on CMD.The source file is called: database.cThe executable file is called: databaseThe CSV file is called: database.csvThe argument CMD can have the following values:SHOWDELETEADDdisplays all the records from the database.- OPT1 = ID, that record in removed from the database.- OPT1=ID, OPT2=NAME, OPT3=AGE, OPT4=GPA, anew record with these fields are added to the database.The structure of the CSV file is: ID, NAME, AGE, GPASpaces can exist between the commas, but are not required. In other words, your programshould handle both cases. If a space comes after or before a comma, then it is notconsidered to be part of the field.For example, database.csv could look like this:10, bob, 18, 3.515, mary, 20, 4.05, tom, 17, 3.8Notice the record &#34;tom&#34; has spaces before and after some of the commas. These spacesare not part of the fields. In other words we read: &#34;5&#34; then &#34;tom&#34; then &#34;17&#34; then&#34;3.8&#34;, without spaces in the field characters.Create database.csv and database.c in the same directory. Using vim, initializedatabase.csv with the above three records (i.e. bob, mary, tom), with the samespacing and format.Make database.c do the following:1. If the user does not provide any command line arguments, then terminate with anerror message: &#34;Your did not provide any arguments. Please enter: ./databaseCMD OPT1 OPT2 OPT3 OPT4&#34;.2. If the CMD argument is not SHOW, not DELETE, not ADD, then terminate theprogram with the error message: &#34;The command you requested in invalid. Pleaseselect from one of these: SHOW, DELETE, ADD&#34;.3. The user must input the CMD argument in all caps. BONUS: (optional - no extrapoints) automatically convert the user's CMD to uppercase. 4. If CMD is SHOW, then display all the records like this, without the quotes:&#34;Record 1: ID=nnn NAME=nnn AGE=nnn GPA-nnn&#34;Where nnn is the data from the CSV file. The record number increases for eachrecord displayed. All the records are displayed. Use the %s, %d, and %f correctlyso that the output is displayed in columns (all the ID fields are under each other,all the NAME fields are under each other, etc.). Each record in displayed on anew line. After the records are displayed the program terminates.5. If CMD is DELETE, then there must be an OPT1 argument.a. If this is missing, then the program terminates with the error message:&#34;Name of record to delete is missing&#34;..b. If there are more arguments than OPT1, then they are ignored. This iscalled graceful execution. We assume the first argument is the correctOPT1 and ignore all the other arguments.6. If CMD is ADD, then there must be OPT1, OPT2, OPT3, and OPT4 arguments.a. If less than four OPT arguments are present, terminate the program willthe following error message: &#34;Missing ID, Name, AGE, and GPAarguments&#34;.●c. Delete the first record that matches NAME==OPT1. The database.csvfile is updated, and the program terminates. You will need to use atemporary file: database.tmp to copy the records you do not want todelete. Then use the system () command to delete the olddatabase.csv file and rename the database. tmp file into the newdatabase.csv file. If no record matched the search condition thendisplay the following message and terminate: &#34;Sorry, that user was notfound. Nothing was deleted.&#34;WHAT TO HAND INEverything must be submitted to TA before the due date. Please hand in thefollowing:b. If there are more arguments, then implement graceful execution.c. It does not matter whether another record with the same name or IDalready exists. Simply append (using fopen (filename. &#34;at&#34;)) theneword to the end of the database.csv file.The database.c fileThe database.csv fileA bash compile.sh script that compiles the programs for the TA using gcc.Make sure to add comments to your C program, and add your name as a commentScreen shots to show how well your program complete requirementsREADME documenting how well you finish the assignments: what is completelyfinished, what is partially finished, what is not done at all, etc.

Accepted Answer

#include #include #include void trim(char *str) {…