How would this look like? How do you add this table to a database? In the previous labs you built functions to respond to 2 queries:1. CREATE DATABASE Where is any single-word database name.2. SHOW DATABASESIn this lab you will build a function to respond to 1 query:1. CREATE TABLE Where is the names of table columns.Since the system has multiple databases in it that your users can create tables in, your users must first be able to select whichdatabase they want to create their tables in. The functionality for this has been provided for you. The query your users will enterto select which database they want to create tables in will be:USE Where is the name of the database the user wants to create tables in.This command will set a global variable currentDB to . You will need to use currentDB in this lab.Usage of this command can be seen in the example output.LABNote: For this lab you will not need to edit anything in main. You will only write code for an addTable function.CREATE TABLE This command will create the arrows from the Databases to the Tables.In the main function in lab10.cpp under the case for CREATE you will notice a function call to a function calledcreateTable, this function creates a table in our database. If you look above the main function you will see the definitionfor createTable.createTable takes in a name and a string containing options (the names the user wants to call thecolumns in the table). The name it takes in is the name the user wants to call their table, and the string of options are the namesthe user wants to call the columns in their table. The first thing createTable does is it turns the string of options into avector of options. It then calls a function called addTable which takes in a table name and a vector of column names. Youneed to create this addTable function. Creating this function is described belowAbove the createTable function, create a boolean-retuning function called addTable. This function should take in 2 formalparameters, a string and a vector. A prototype for your function is as follows:bool addTable (string, const vector6)In the addTable function you need to add a table to your database. To add a table in your database:1. Check if the table already exists in the database you are currently in.a. Open the CSV file of tables for the current database you are in. This file"csv/" + current DB + "_tables.csv"b. Skip the line of headers in the CSV file from (a) using C++'s getline function.c. Grab the first row from the CSV file from (a).d. Call the provided function vectorizeRow (string) on the row you got from the previous step.is located at:i.vectorizeRow is a vector-returning function that turns the passed row from a csv file into avector of strings. i.e. "DB, exTable, 2" = ["DB", "exTable", "2"]e. The vector you get back from (d) contains 3 elements:vec[0] = The name of the database the table belongs to.vec[1]= The name of the table.vec[2] = How many columns are in theIf the vector's database name matches currentDB and table name matches the name of the table the user istrying to create, the table is already in the database. Output an error message and return false from theaddTable function, The error message should say:Error: Table already exists.f. If (e) doesn't result in error, grab the next row from the CSV file of tables for the current database you are inand continue from (d). If you get through the file without finding the table the user is trying to add, continue to(2) as the table doesn't already exist and can be added.2. If the table doesn't already exist add it to the database:a.Close, then open, in appendable mode, the CSV file of tables for the current database you are in.b. Append the table the user wants to create to the CSV file of tables for the current database you are in. This canbe done by appending a new row to the file. The row you want to append is:current DB, tableName, columnCountWhere tableName is the string and columnCount is the size of the vector passed to addTable.c. Create a new CSV file to hold data for your table in the location:"csv/" + current DB + "_" + name + ".csv"d. Write the names of the headers passed to addTable via a vector to the CSV file created in (c). Eachheader in the file should be separated by a comma ',e. Close all of the files opened in the function.f. Return true as you were able to successfully add the table to the database.

Question

How would this look like? How do you add this table to a database? In the previous labs you built functions to respond to 2 queries:1. CREATE DATABASE Where  is any single-word database name.2. SHOW DATABASESIn this lab you will build a function to respond to 1 query:1. CREATE TABLE   Where  is the names of table columns.Since the system has multiple databases in it that your users can create tables in, your users must first be able to select whichdatabase they want to create their tables in. The functionality for this has been provided for you. The query your users will enterto select which database they want to create tables in will be:USE Where  is the name of the database the user wants to create tables in.This command will set a global variable currentDB to . You will need to use currentDB in this lab.Usage of this command can be seen in the example output.LABNote: For this lab you will not need to edit anything in main. You will only write code for an addTable function.CREATE TABLE   This command will create the arrows from the Databases to the Tables.In the main function in lab10.cpp under the case for CREATE you will notice a function call to a function calledcreateTable, this function creates a table in our database. If you look above the main function you will see the definitionfor createTable.createTable takes in a name and a string containing options (the names the user wants to call thecolumns in the table). The name it takes in is the name the user wants to call their table, and the string of options are the namesthe user wants to call the columns in their table. The first thing createTable does is it turns the string of options into avector of options. It then calls a function called addTable which takes in a table name and a vector of column names. Youneed to create this addTable function. Creating this function is described belowAbove the createTable function, create a boolean-retuning function called addTable. This function should take in 2 formalparameters, a string and a vector. A prototype for your function is as follows:bool addTable (string, const vector6)In the addTable function you need to add a table to your database. To add a table in your database:1. Check if the table already exists in the database you are currently in.a. Open the CSV file of tables for the current database you are in. This file&#34;csv/&#34; + current DB + &#34;_tables.csv&#34;b. Skip the line of headers in the CSV file from (a) using C++'s getline function.c. Grab the first row from the CSV file from (a).d. Call the provided function vectorizeRow (string) on the row you got from the previous step.is located at:i.vectorizeRow is a vector-returning function that turns the passed row from a csv file into avector of strings. i.e. &#34;DB, exTable, 2&#34; => [&#34;DB&#34;, &#34;exTable&#34;, &#34;2&#34;]e. The vector you get back from (d) contains 3 elements:vec[0] = The name of the database the table belongs to.vec[1]= The name of the table.vec[2] = How many columns are in theIf the vector's database name matches currentDB and table name matches the name of the table the user istrying to create, the table is already in the database. Output an error message and return false from theaddTable function, The error message should say:Error: Table already exists.f. If (e) doesn't result in error, grab the next row from the CSV file of tables for the current database you are inand continue from (d). If you get through the file without finding the table the user is trying to add, continue to(2) as the table doesn't already exist and can be added.2. If the table doesn't already exist add it to the database:a.Close, then open, in appendable mode, the CSV file of tables for the current database you are in.b. Append the table the user wants to create to the CSV file of tables for the current database you are in. This canbe done by appending a new row to the file. The row you want to append is:current DB, tableName, columnCountWhere tableName is the string and columnCount is the size of the vector passed to addTable.c. Create a new CSV file to hold data for your table in the location:&#34;csv/&#34; + current DB + &#34;_&#34; + name + &#34;.csv&#34;d. Write the names of the headers passed to addTable via a vector to the CSV file created in (c). Eachheader in the file should be separated by a comma ',e. Close all of the files opened in the function.f. Return true as you were able to successfully add the table to the database.

Accepted Answer

Create Database and Create Table. While both are pretty simple, they should be used first before you…