Customers who belong to an online retailer’s Free Ship club receive free shipping on all of their purchases. Customers who do not belong to the club must make a minimum purchase of $50 to receive free shipping. If subcondition1 is strClubMember = "Y" and subcondition2 is dblPurchase >= 50, which logical operator should you use to combine both subconditions: AndAlso or OrElse?

Customers who belong to an online retailer’s Free Ship club receive free shipping on all of their purchases. Customers who do not belong to the club must make a minimum purchase of $50 to receive free shipping. If subcondition1 is strClubMember = "Y" and subcondition2 is dblPurchase >= 50, which logical operator should you use to combine both subconditions: AndAlso or OrElse?

Programming with Microsoft Visual Basic 2017

8th Edition

ISBN:9781337102124

Author:Diane Zak

Publisher:Diane Zak

Chapter4: The Selection Structure

Section: Chapter Questions

Problem 1MQ4

See similar textbooks

Similar questions

An online retailer offers free shipping on purchases over $100, but only when the customer has a free shipping code. If subcondition1 is dblPurchase > 100 and subcondition2 is strFreeShip = "Y", which logical operator should you use to combine both subconditions: AndAlso or OrElse?
Which of the following statements is equivalent to the statement dblTotal = dblRate dblTotal? a. dblTotal = dblRate b. dblTotal = dblRate c. dblRate = dblTotal d. dblRate = dblTotal
Which of the following instructs a function to return the value stored in the dblBonus variable? Return dblBonus Return ByVal dblBonus Send dblBonus SendBack dblBonus
Below is the code for a procedure that will accept a Customer ID as an input parameter and display the Customer ID, Customer Surname and Customer Address. Review the code, then answer the questions that follow. create or replace procedure sp_customer_details (c_id IN CUSTOMER.cust_id%TYPE,customer_details out VARCHAR2)ISBEGINSELECT 'CUSTOMER ID:' || c.cust_id || ', Surname:'|| c.cust_sname || ',ADDRESS:' ||c.cust_addressinto customer_detailsfrom CUSTOMER cwhere c.cust_id = c_id;END; Q.1 Briefly discuss the advantages of using the %TYPE attribute in the code. Q.2 Create the code to execute the procedure with exception handling if no customer data is found. Use customer ID C115 in your code.
Which of the following is a legal identifier? a. 1st b. legal1 c. legalidentifier! d. Legal Identifier
this is the information that has to be hard-coded: # hard-coded calls jim = User(first_name='Jim', last_name='Bob', user_id=1000, last_login='June 12, 1998', password='password123') jim.describe_user() jim.greet_user() joe = User('Joe', 'Bob', 1001, 'July 4, 2001', 'babygirl') joe.greet_user() joe.describe_user()
What does :last serve as in the following statement? 'SELECT FName, LName from users where LName = :last'
Please answer all three subparts. I will really upvote. Thanks
Hello I am receiving this error whenever I try to import it into MySQL using this code SELECT store_id AS Store, COUNT(*) AS Num_CustomersFROM sakila.customerGROUP BY store_idORDER BY store_id DESC, COUNT(*) DESC;SELECT film.title AS Title, rental.rental_date AS Rental_Date, rental.return_date AS Return_DateFROM sakila.customerJOIN sakila.rental ON customer.customer_id = rental.customer_idJOIN sakila.inventory ON rental.inventory_id = inventory.inventory_idJOIN sakila.film ON inventory.film_id = film.film_idWHERE customer.first_name = 'JO' AND customer.last_name = 'FOWLER'ORDER BY rental.rental_date ASC;REPLACE VIEW top_rental_films ASCREATE OR SELECT film.title AS FilmTitle, COUNT(rental.rental_id) AS Num_Rentals, AVG(payment.amount) AS Avg_AmtFROM sakila.filmJOIN sakila.inventory ON film.film_id = inventory.film_idJOIN sakila.rental ON inventory.inventory_id = rental.inventory_idJOIN sakila.payment ON rental.rental_id = payment.rental_idGROUP BY film.film_idORDER BY…
Based on the following code, how many DWORD arguments and local variables are reserved for the procedure sub_mid? Please provide the answer with reason and explanation sub_mid PROC push ebp mov ebp, esp sub esp, 16 ... mov eax, [ebp + 8] add eax, [ebp + 12] sub eax, [ebp - 4] mov eax, [ebp + 16] ... sub_mid endp
P1 - Loan Payment Schedule Main Street Bank is offering an annual interest rate discount based on the client’s credit score. The discount for each credit score level is provided in the table below. The lowest credit score is 300 while the highest credit score is 850. For example, the new interest rate for a client with a credit score of 755 and a current interest rate of 4.25% would be 4.25 – 0.75 = 3.50% interest rate Credit Score Rating Interest Rate Discount 300 - 579 Very Poor 0.00 580 – 669 Fair 0.25 670 - 739 Good 0.50 740 - 799 Very Good 0.75 800 - 850 Exceptional 1.00 Use modular programming concepts Create a program that includes a WHILE loop to generate a payment schedule for loans that are paid in equal monthly payments Input the loan number and retrieve required loan account from MS_LOANS table Output is shown below Monthly interest is calculated by dividing the yearly interest rate by 12 to get a monthly interest…
Do problem attached please