In many DBMSs where no strict separation of levels is maintained, this one language is used by the DBA and database designers to
1 answer:
You might be interested in
Answer:
Follows are the modified code in c++ language:
#include<iostream>//header file
#include<string>//header file
using namespace std;
int main()//main method
{
string name,address, MSG_YES, MSG_NO;//defining string variable
int item,quantity,size=6, i=0;//defining integer variable
double price;//defining double variable
int VALID_ITEM[]={106,108,307,405,457,688};//defining integer array and assign value
double VALID_ITEM_PRICE[]={0.59,0.99,4.50,15.99,17.50,39.00};//defining double array and assign value
bool foundIt=false;//defining bool variable
MSG_YES="Item available";//use string variable to assign value
MSG_NO = "Item not found"; //use string variable to assign value
cout<<"Input name: ";//print message
cin>>name;//input value in string variable
cout<<"Input Address: ";//print message
cin>>address;//input value in string variable
cout<<"Input Item: "<<endl;//print message
cin>>item;//input value in string variable
cout<<"Input Quantity: "<<endl;//print message
cin>>quantity;//input value in string variable
while(i <size)//defining while that checks i less then size
{
if (item ==VALID_ITEM[i]) //use if block to match item in double array
{
foundIt = true;//change bool variable value
price = VALID_ITEM_PRICE[i];//hold item price value in price variable
}
i++;//increment the value of i
}
if (foundIt == true)//use if to check bool variable value equal to true
{
cout<<MSG_YES<<endl;//print value
cout<<"Quantity "<<quantity<<" at "<<"Price "<<price<<"each"<<endl;//print value
cout<<"Total"<<quantity*price;//calculate the total value
}
else//else block
cout<<MSG_NO;//print message
}
Output:
please find the attached file.
Explanation:
In the above given C++ language modified code, four-string variable " name, address, MSG_YES, and MSG_NO", four integer variable "item, quantity, size, and i", and "integer and double" array is defined, that holds values.
In the string and integer variable "name, address, and item, quantity", we input value from the user-end and use the while loop, which uses the if block to check the "item and quantity" value from the user end and print its respective value.
