EBK 3N3-EBK: PROGRAMMING W/MICROSOFT VI
8th Edition
ISBN: 9780176920159
Author: ZAK
Publisher: VST
expand_more
expand_more
format_list_bulleted
Concept explainers
Expert Solution & Answer
Chapter 4, Problem 1MQ4
Explanation of Solution
AndAlso operator:
- The AndAlso logical operator evaluates to be “true” when all the sub-conditions are “true” in the compound condition.
OrElse operator:
- The OrElse logical operator evaluates to be “true”, when any one of the sub-conditions is “true” in the compound condition...
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
The following is a table of applicants to be considered for admission into 07BSAM:
POINTS
MATH
SYMBOL
123
450
NAMES
STUDENT
NUMBER
ENG SYMBOL
To qualify for admission, an applicant should have at least 25 points, minimum of B symbol in
Mathematics and a minimum of E symbol in English. If an applicant has a C symbol in Mathematics,
then the applicant must pass an entrance test to be considered for admission.
Hints:
There are three modes of study: The Full-time mode, the Part-time mode and the Distance mode.
Applicants can choose which mode they want provided there is space in that mode. Each of the Full-
time and the Part-time modes cannot accommodate more 30 admitted students. After these two
modes are full, every other qualified applicant is admitted in the Distance mode. The admission
exercise is first come first served.
Write a pseudocode that identifies the applicants that qualify for admission and outputs their names,
student numbers and modes of study. Use a FOR-LOOP /…
What is the difference between union and union all operators?
PATHS is a table that contains information about paths on a number line. The
structure of PATHS is as follows, where x1 and x2 represent that there is a path
from Coordinate x1 to Coordinate x2 (You can't move from Coordinate x2 to
Coordinate x1 ).
NAME
ΤΥΡE
NULLABLE
X1
INT
FALSE
X2
INT
FALSE
Problem
Please write an SQL statement that returns the beginning and end point of each
path in PATHS . Sort them by the value of the beginning point in ascending order.
Constraints
• In the case where a direct path from Coordinate a to Coordinate b is
available, no path from Coordinate b to Coordinate a will be given.
|x1-x2| = 1
• No path will overlap with one another.
Example
Suppose that PATHS is as follows:
x1
x2
1
2
2
3
4
7
7
6
This table can be visualized as follows:
START
END
END
START
7
8.
9
Therefore, your SQL statement must return the following:
start
end
1
4
8
6
Chapter 4 Solutions
EBK 3N3-EBK: PROGRAMMING W/MICROSOFT VI
Ch. 4 - Prob. 1MQ1Ch. 4 - Prob. 2MQ1Ch. 4 - Prob. 3MQ1Ch. 4 - Prob. 1MQ2Ch. 4 - Prob. 2MQ2Ch. 4 - Prob. 3MQ2Ch. 4 - Prob. 4MQ2Ch. 4 - What is the opposite of greater than?Ch. 4 - Prob. 1MQ3Ch. 4 - Prob. 2MQ3
Ch. 4 - Prob. 3MQ3Ch. 4 - Prob. 4MQ3Ch. 4 - Prob. 1MQ4Ch. 4 - Prob. 2MQ4Ch. 4 - Prob. 3MQ4Ch. 4 - Prob. 1MQ5Ch. 4 - Prob. 2MQ5Ch. 4 - Prob. 3MQ5Ch. 4 - Prob. 1MQ6Ch. 4 - Jake’s Car Rental charges each customer a daily...Ch. 4 - Prob. 1MQ7Ch. 4 - Prob. 2MQ7Ch. 4 - Write a Case clause that specifies all numbers...Ch. 4 - Prob. 1MQ8Ch. 4 - Prob. 2MQ8Ch. 4 - Prob. 3MQ8Ch. 4 - A form contains six radio buttons. Three of the...Ch. 4 - Which property of the KeyPress procedures e...Ch. 4 - Which property of the KeyPress procedure’s e...Ch. 4 - Prob. 3MQ9Ch. 4 - Prob. 4MQ9Ch. 4 - Prob. 5MQ9Ch. 4 - Prob. 1RQCh. 4 - Prob. 2RQCh. 4 - Prob. 3RQCh. 4 - Prob. 4RQCh. 4 - Prob. 5RQCh. 4 - Prob. 6RQCh. 4 - Prob. 7RQCh. 4 - Prob. 8RQCh. 4 - Prob. 9RQCh. 4 - Prob. 10RQCh. 4 - Prob. 11RQCh. 4 - Prob. 12RQCh. 4 - Use the code shown in Figure 4-54 to answer Review...Ch. 4 - Use the code shown in Figure 4-54 to answer Review...Ch. 4 - Use the code shown in Figure 4-54 to answer Review...Ch. 4 - Prob. 16RQCh. 4 - Prob. 17RQCh. 4 - Prob. 18RQCh. 4 - Prob. 19RQCh. 4 - Prob. 20RQCh. 4 - Prob. 21RQCh. 4 - Prob. 22RQCh. 4 - Prob. 23RQCh. 4 - Prob. 24RQCh. 4 - Prob. 25RQCh. 4 - It is customary in Windows applications to...Ch. 4 - Prob. 27RQCh. 4 - Prob. 28RQCh. 4 - Prob. 29RQCh. 4 - Prob. 30RQCh. 4 - Prob. 31RQCh. 4 - Prob. 32RQCh. 4 - Prob. 33RQCh. 4 - Prob. 34RQCh. 4 - Which of the following statements is equivalent to...Ch. 4 - The six logical operators are listed below....Ch. 4 - An expression can contain arithmetic, comparison,...Ch. 4 - Prob. 1ECh. 4 - Prob. 2ECh. 4 - Prob. 3ECh. 4 - Prob. 7ECh. 4 - Prob. 11ECh. 4 - The purpose of this exercise is to demonstrate the...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- ord_no 70001 70009 70002 70004 purch_amt 150.5 270.65 65.26 110.5 ord_date customer_id salesman_id 2012-10-05 3005 2012-09-10 3001 2012-10-05 3002 2012-08-17 3009 5002 5005 5001 5003 Given the Orders Table above: Write a SQL statement to find the highest purchase amount with their ID and order date, for those customers who have a higher purchase amount in a day is within the range 100 and 300.arrow_forwardWhich values are marked for deallocation after the sequence? Integerobj1=newInteger(10);Integerobj2=newInteger(20);Integerobj3=obj2;Integerobj4=newInteger(40);obj2=null;obj4=obj1; only 20 only 40 20 and 40 no values are marked for deallocation Which expressions for XXX, YYY, and ZZZ output "Great job" for scores above 90, and "Nice try" otherwise? Choices are in the form XXX / YYY / ZZZ. intscore;score=scnr.nextInt();if(XXX){System.out.println(YYY);}else{System.out.println(ZZZ);} score < 91 / "Great job" / "Nice try" score < 91 / "Nice try" / "Great job" score > 90 / "Nice try" / "Great job" (Not possible for given code) The program should determine the largest integer seen. What should XXX be if the input values are any integers (negative and non-negative)? All variables are integers and have…arrow_forward“For calculating the delivery charges, customers are divided into two categories: those whose sales region code is 100 or above and those with a code less than 100. If the code is less than 100 and the invoice amount is less than $50,000, the delivery charge of $500 is added to the invoice total. However, if the invoice is $50,000 or more, the delivery charge is $1000. If the sales region code is 100 or greater, the corresponding delivery charge is $250, irrespective of the invoice amount.” Please indicate INITIAL conditions, rules and actionsarrow_forward
- The following two SQL statements will produce the same results. SELECT P_DESCRIPT, P_QOH,P_PRICE FROM PRODUCT WHERE P_QOH >(SELECT P_QOH FROM PRODUCT WHERE P_CODE='11QER/31') AND P_PRICE>(SELECT P_PRICE FROM PRODUCT WHERE P_CODE='11QER/31'); SELECT P_DESCRIPT, P_QOH,P_PRICE FROM PRODUCT WHERE (P_QOH,P_PRICE) > (SELECT P_QOH,P_PRICE FROM PRODUCT WHERE P_CODE='11QER/31'); A) True B) Falsearrow_forwardwrite SQL code that involve calculation by using if else statementarrow_forwardIn cell N3, enter a formula using the IF function and structured references as follows to determine which employment level Tiffany Adams is qualified for: The IF function should determine if the employee's Years of Experience is greater than or equal to 4, and return the value 2 if true or the value 1 if false. Fill the formula into the range N4:N32, if necessary.arrow_forward
- TAL Distributors would like to know the number of months between the current date and the order date of an order. Write an SQL statement in MySQL that displays the order number and the number of months between the current date and the order date. The number of months should display as an integer. (Hint: You can nest one function within another function.) This is the code I haveSELECT FLOOR(MONTHS_BETWEEN(CURRENT_DATE,To_date(ORDER_DATE, 'MM/DD/YYYY')))num_monthsFROM ORDERS;is giving me an errorError Code: 1305. FUNCTION tal.MONTHS_BETWEEN does not existarrow_forwardCustomers 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?arrow_forwardOn the Faculty Data worksheet, in cell J3, use an IFS function to calculate the retirement matching dollar amount for each faculty member participating in the retirement plan. If the participating member is a Full Professor, the matching amount is 4% of the salary. Otherwise, the matching amount is 3% of the salary. If the member is not participating, show a blank.arrow_forward
- 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?arrow_forwardDatabase: CUSTOMER (CustomerID, LastName, FIrstName, Phone, EmailAddress) PURCHASE (InvoiceNumber, InvoiceDate, PreTaxAmount, CustomerID) PURCHASE_ITEM (InvoiceNumber, InvoiceLineNumber, Item Number, RetailPrice) ITEM (ItemNumber, ItemDesciption, Cost, ArtistLastName, ArtistFirstName) Write an SQL statement to show which cutomers bought which items, and include any items that have not been sold. Include CUSTOMER.LastName, CUSTOMER.FirstName, IvoiceNumber, InvoiceDate, ItemNumber, ItemDescription, ArtistLastName, and ArtistFirstName,. Use a join using JOIN ON syntax, and sort the results by ArtistLastName and ArtistFirstName in ascending order. Note that in Microsoft Access this require multiple queries. From Database Concepts 9th Ed. (Kroenke)arrow_forwardWrite a stored procedure called sp_apply_discount() that will apply percent discount to books in a subject. The stored procedure takes in 2 parameters, percentDiscount (DECIMAL(8,2)) and subject (VARCHAR(120)). Using these parameters, the stored procedure computes the discount for the book cost and stores it in the FINAL_PRICE field. For example, the following stored procedure call: call sp_apply_discount(0.15, 'Database');would compute 15% percent discount from the book cost in the Database subject category and store it in the FINAL_PRICE column as depicted in this image:arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Programming with Microsoft Visual Basic 2017Computer ScienceISBN:9781337102124Author:Diane ZakPublisher:Cengage Learning
Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:CengageCOMPREHENSIVE MICROSOFT OFFICE 365 EXCEComputer ScienceISBN:9780357392676Author:FREUND, StevenPublisher:CENGAGE L
A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology Ptr
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr