Answer:
The first value of i is 0 and last value of i is 20.
Explanation:
The following are the description of a given loop.
- In this problem, there are two loops one is the internal loop and the other is the external loop
- In the outer loop, the value of " i" is initialized with "0" So the first value is printed 0 in the console.
- For one value of "i" all the inner loop is executed.
- The loop is executed is less equal to 20 that's why the last value of "i" is printed 20 in the console window.
Answer:
Customer Table
- Customer name
- Customer id
Product Table
- Product id/number (primary key, auto increment)
- Product name
- Product sale price
Transactions Table
- Transaction Id
- Customer Id
- Product id
- Quantity
- Price
- Date
Explanation:
Natalie wants to fetch following information from database
- Look up customer name and sale price
- Sort items in db by product number
To lookup customer name and sale price perform a join on Transactions table and Customer table.Assuming database is build in mysql the query to fetch required results would be
select transction.productId,transaction.customerid,customer.customername from transactions join customer ON
customer.customerid=transcation.customerid
where productid="user provided product id of returned product"
For sorting products by number set produc number in product table a auto increment primary key
a.The primary purpose of JavaScript is to enable features such as validation of forms before they are submitted to the server.
<u>Explanation:</u>
On web pages before submitting the day, end user has to do client validations such as whether data enter is correct data type, so end user for client side validation been eiher by VBSCRIPT (visual basic script language) or (JavaScript java script). Internet explorer or Microsoft edge uses VBSCRIPT for web page validation.
For visual basic script languages end user should have enough knowledge on visual basic programming languages. Same away for java script end user have enough knowledge on c language.
Both Scripts are used for client side validation on success of validation end user will submit web page form for next action. JavaScript is used in most of the browser including Microsoft explorer or Microsoft edge.