Java file boolean w6 | Computer Science homework help

 

 

 

 

 

 

 

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.

Order a unique copy of this paper
(550 words)

Approximate price: $22

Place Order
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

We value our customers and so we ensure that what we do is 100% original..
With us you are guaranteed of quality work done by our qualified experts.Your information and everything that you do with us is kept completely confidential.

Zero-plagiarism guarantee

The Product ordered is guaranteed to be original. Orders are checked by the most advanced anti-plagiarism software in the market to assure that the Product is 100% original. The Company has a zero tolerance policy for plagiarism.

Read more

Free-revision policy

The Free Revision policy is a courtesy service that the Company provides to help ensure Customer’s total satisfaction with the completed Order. To receive free revision the Company requires that the Customer provide the request within fourteen (14) days from the first completion date and within a period of thirty (30) days for dissertations.

Read more

Privacy policy

The Company is committed to protect the privacy of the Customer and it will never resell or share any of Customer’s personal information, including credit card data, with any third party. All the online transactions are processed through the secure and reliable online payment systems.

Read more

Fair-cooperation guarantee

By placing an order with us, you agree to the service we provide. We will endear to do all that it takes to deliver a comprehensive paper as per your requirements. We also count on your cooperation to ensure that we deliver on this mandate.

Read more

Calculate the price

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
× WhatsApp us for help