Java File
Boolean W6
Using Relational and Logical Operators to Evaluate Logical (Boolean) Expression
Evaluate the logical (Boolean) expressions in the following exercises and circle the correct answer after you evaluation. For char and String types, use the Unicode collating sequence.
|
Expression |
Result (Circle correct answer) |
|
1. int num1 = 3, num2 = 2; (num1 > num2) |
T F |
|
2. double hours = 12.8; (hours > 40.2) |
T F |
|
3. int funny = 7; (funny ! = 1) |
T F |
|
4. char letter = ‘ A ‘; (‘a’ < letter ) |
T F |
|
5. int count = 1; count < = 4; |
T F |
|
6. double y = -2 . 3; y > = 0.0; |
T F |
|
Expressions Use the following values: X = false, y = false, z = true |
Result (Circle all possible answers) |
|
|
1. ! ( x | | y) | | z |
T F short – circuit |
|
|
2. x && z && y |
T F short – circuit |
|
|
3. ! x | | (y | | ! z) |
T F short – circuit |
|
|
4. x | | (z && (y | | x) ) |
T F short – circuit |
|
|
5. true | | ! z && y |
T F short – circuit |
|
|
6. ! (x | | y) | | x |
T F short – circuit |
|
|
7. z && x && y |
T F short – circuit |
|
|
8. ! x | | (y | | ! z) |
T F short – circuit |
|
|
9. x | | (y && (x | | z) ) |
T F short circuit |
|
|
10. false | | ! x && y |
T F short – circuit |
|
|
Expression Use the following values: X = false, y = false, z = true T F (Circle all possible answers)
|
Result (Circle all possible answers) |
|
1. String name1 = “Aaron” ; String name2 = “aaron” ; name1. compareTo(name2)= = 0 |
T F |
|
2. String name1 = “Aaron” ; String name2 = “Aardvark” ; namel. compareTo(name2) > 0 |
T F |
|
3. Boolean flag = true; int a = 2, b = 5, c = 10; (a * b < = c && ! flag) |
T F |
|
4. String name1 = “Aaron” ; String word = “A” ; name1 .compareTo(word) < 0 |
T F |
|
5. int x = 2; double y = 1 . 1; (x – y) = = 0 . 9
|
T F |
DATABASE
W6
DATA W6
Consider the following relational database that Best Airlines uses to keep track of its mechanics, their skills, and their airport locations. Mechanic number (MECHNUM), airport name (AIRNAME), and skill number are all unique fields. SIZE is an airport’s size in acres. SKILLCAT is a skill category, such as an engine skill, wing skill, tire skill, etc. YEARQUAL is the year that a mechanic first qualified in a particular skill: PROFRATE is the mechanic’s proficiency rating in a particular skill.
MECHANIC Table |
MECHNUMMECHNAME AGE SALARY AIRNAME |
AIRPORT Table |
AIRNAME CITY STATE SIZE YEAROPENED |
SKILL Table |
SKILLNUM SKILLNAME SKILLCAT |
QUALIFICATION Table |
MECHNUM SKILLNUM YEARQUAL PROFRATE |
Write SQL SELECT commands to answer the following queries.
a. List the names and ages of all the mechanics.
b. List the airports in California that are at least 20 acres in size and have been open since 1935. Order the results from smallest to largest airport.
c. List the airports in California that are at least 20 acres in size or have been open since 1935.
d. Find the average size of the airports in California that have opened since 1935.
e. How many airports have been open in California since 1935?
f. How many airports have been open in each state since 1935?
g. How many airports have been open in each state since 1935? Include in your answer only states that have at least five such airports.
h. List the names of the mechanics who in California.
i. Fan blade replacement is the name of a skill. List the names of the mechanics that have a proficiency rating of 4 in fan blade replacement.
j. Fan blade replacement is the name of a skill. List the mechanics who work in California who have a proficiency rating of 4 in fan blade replacement.
k. List the total combined salaries of all the mechanics who work in each city in California.
l. Find the largest of all of the airports.
m. Find the largest airport in California.
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more