$ 75000 is the maximum amount that he can spend per month paying off credit cards and loans and not be in danger of credit overload.
More than this amount will exceed his income.
Answer:
We can use CREATE command to create tables with columns having descriptive names
Explanation:
Firstly, create a table using CREATE command in SQL. The syntax is as follows:
CREATE TABLE [table_name]
(
[col_name] [datatype]),
[col_name] [datatype]),
[col_name] [datatype]),
[col_name] [datatype])
)
Once the table is created, we can insert the data into table using INSERT command. It's syntax is as follows:
INSERT INTO table_name VALUES('', '', '')
if datatype is string, values must be entered within single quotes. If datatype is int, values are entered directly without using quotes.
Now, you can select the data from the table using SELECT command. It's syntax is as follows:
SELECT column-list FROM table_name
If you want to filter rows according to conditions, you can use WHERE command.
I have created sample table and inserted some data into it. Now, I applied some queries on it to select data from the table.
I have written in a text file and attached the same. Please find. Thank you!
Answer:
Following are the program in the C++ Programming Language.
//set header file
#include <iostream>
//set namespace
using namespace std;
//define class
class format
{
//set access modifier
public:
//set string type variable
string res;
//define function
void names(string first_name, string last_name)
{
//set if-else if condition to check following conditions
if(first_name.length()>0 && last_name.length()>0)
{
res="Name: "+last_name+", "+first_name;
}
else if(first_name.length()>0 and last_name.length()==0)
{
res="Name: "+first_name;
}
else if(first_name.length()==0 and last_name.length()==0)
{
res="";
}
}
//define function to print result
void out(){
cout<<res<<endl;
}
};
//define main method
int main() {
//set objects of the class
format ob,ob1,ob2;
//call functions through 1st object
ob.names("John","Morris");
ob.out();
//call functions through 2nd object
ob1.names("Jhon","");
ob1.out();
//call functions through 3rd object
ob2.names("", "");
ob2.out();
}
<u>Output</u>:
Name: Morris, John
Name: Jhon
Explanation:
<u>Following are the description of the program</u>:
- Define class "format" and inside the class we define two void data type function.
- Define void data type function "names()" and pass two string data type arguments in its parameter "first_name" and "last_name" then, set the if-else conditional statement to check that if the variable 'first_name' is greater than 0 and 'last_name' is also greater than 0 then, the string "Name" and the following variables added to the variable "res". Then, set else if to check that if the variable 'first_name' is greater than 0 and 'last_name' is equal to 0 then, the string "Name" and the following variable "first_name" added to the variable "res".
- Define void data type function "out()" to print the results of the variable "res".
- Finally, we define main method to pass values and call that functions.
