Premiere Products Create a tables name SALES_REP. The table has the same structu
ID: 673951 • Letter: P
Question
Premiere Products
Create a tables name SALES_REP.
The table has the same structure as the REP table shown in Figure 3-6 except the LAST_NAME column should be use the VARCHAR data type and the COMMISSION and RATE columns should use the NUMBER data type.
Execute the command to describe the layout and characteristics of the SALES_REP table.
Add the following row to the SALES_REP table: rep number: 25, last name: Lim, first name: Louis, street: 535 Vincent; city: Grove, state: FL, zipcode: 33321, commission: 0.00; and rate: 0.05.
Display the contents of the SALES_REP table. Delete the SALES_REP table.
Run the script for the Premiere database to create the five tables and add records to the tables.
Be sure to select the file for the particular DBMS that you are using (Oracle, SQL Server, or Access). (Note: If you do not have the files for this text, ask you instructor for assistance.)
Confirm that you have created the tables correctly by describing each table and comparing the results to Figures 3-6, 3-35, 3-29, and 3-31 on MYSQL Textbook.
Confirm that you have added all data correctly by describing each table and comparing the results to Figure 2-1 in Chapter 2.
Explanation / Answer
void myFunction( int counter)
{
if(counter == 0)
return;
else
{
cout <<counter<<endl;
myFunction(--counter);
return;
}
}
This recursion is not infinite, assuming the function is passed a positive integer value. What will the output be?
Consider this function:
void myFunction( int counter)
{
if(counter == 0)
return;
else
{
cout<<"hello"<<counter<<endl;
myFunction(--counter);
cout<<counter<<endl;
return;
}
}