[ad_1]

Get college assignment help at uniessay writers Problem 2 (30 Points) The database schema is as follows: AIRPORT(city, country, runways); (the last attribute is the number of runways at an airport) FLIGHT (flightID, day, depart_city, arrive_city, depart_time, arrive_time, plane_type) PLANE(plane_type, capacity) Write following queries in SQL and relational algebra: 1) (5 points) Find the airports with a direct flight to Toronto 2) (5 points) Find airports with late flights to Toronto on a big plane. “Late” means departing after 9:00pm; “big” means with capacity 150 passengers or more 3) (5 points) Find cities from which one can fly to Toronto with one change of planes, and using the same type of the aircraft for both legs of the trip. Write following queries in SQL and relational algebra. 1) (5 points) Find flight numbers of flights that use a small (capacity less than 50) plane 2) (5 points) Find all airports with at least 3 runways that have 2 or more flights to Paris a day, or with capacity at least 250. Assumption: (flightId, day) pairs are unique (i.e., there are no two flights with the same flightId on the same day)

In this unit, you will focus on completing your extremism ideology

In this unit, you will focus on completing your extremism ideology case study. As a case study, you will identify the origins of an extremist ideology and the associated movements and groups associated. As a case study, you will place an emphasis on factors contributing to its emergence, critical events associated with the movement, impact on society, and an assessment of the threat posed by either the overall ideology or specific groups within the larger movement. The deliverable for this item will be a formal case study, constituting no less than 2,500 words. APA Format. At Least 3 primary and 5 secondary sources.

Given an integer n0 and a binary tree T of IntTree

Given an integer n0 and a binary tree T of IntTree type. Write a function, which creates an object of IntList type composed of integers located on the level n of T tree taken from left to right.

choicepoint 3 days

choicepoint 3 days

I am supposed to calculate the Water Bill based on the

I am supposed to calculate the Water Bill based on the following rules: 1. If a customer’s bill is waived, place 0 in the Water Bill column. 2. Gal Used (gallons used) must be greater than 25,000 gallons during the quarter; otherwise, the water bill is 0. 3. For all other accounts, the billing rate varies based on the type of customer. The billing rate is $3, $2, or $1.50 per thousand gallons used depending on the type of customer (see the Billing Rate worksheet). For example, a commercial customer using 75,000 gallons has a water bill of $225(75x$3), whereas a government customer using 100,000 gallons pays $150(100x$1.50). A commercial customer using 15,000 gallons has a water bill of 0. I cannot figure out the formula to do this. PLEASE HELP!!! DUE TODAY!!!

design a module getnumber which uses a reference parameter variable to

design a module getnumber which uses a reference parameter variable to sccept and integer arguement. the module should prompt the user to enter a number than store the input into a reference parameter variable

Create the following queries on the ITD640_B database used for IP3

Create the following queries on the ITD640_B database used for IP3 and save them all in a file called ITD640_P5.SQL. Remember that you can execute individual queries in a query file by highlighting the lines that you want to execute before running the script. Also remember to define what database to use with a USE statement. 1. Using a join, get the full details of all the employees who are working on the Harvest Ball promotion. 2. Get the promotion names (duplicates eliminated) being worked on by employees from the Rocky Mountain Produce store. 3. Get the last names of all the employees who are working on promotion P1. 4. Get the employee numbers and start dates of all the employees with start dates equal to the earliest date. 5. Insert yourself in the employee table using the last five digits of your phone number as the employee number and show yourself as working for Rocky Mountain Produce. Then show all the records in the employee table. 6. Delete yourself from the employee table by matching your employee number, and then show all of the records in the employee table.

1. 1. Explain the following unexpected result: $whereis date date: /bin/date

1. 1. Explain the following unexpected result: $whereis date date: /bin/date … $echo $PATH .:/usr/local/bin:/usr/bin:/bin $car > date ECHO “This is my own version of date.” $ date Sat May 24 11:45:49 PDT 2008

Let G be a directed graph over n vertices. Let matrix

Let G be a directed graph over n vertices. Let matrix C have entries Cij equal to the edge cost from vertex i to vertex j. Let matrix D have entries Dij equal to the (minimum) distance from vertex i to vertex j. Devise an algorithm that takes as inputs, matrices C, D, and vertex indices i and j, and returns a minimum-cost path from vertex i to vertex j.

They are currently using SNMP protocol, but not all locations do

They are currently using SNMP protocol, but not all locations do monitoring and it is managed locally at locations that are monitoring. Write a one-page proposal of how this company can manage SNMP from the corporate location

Consensus algorithm”: A group of ten people need to decide which

Get college assignment help at uniessay writers Consensus algorithm”: A group of ten people need to decide which one flavor of ice cream they will all order, out of three options. The algorithm can question and re-question the participants, and present the answers to the participants, until a consensus is reached. This exercise is somewhat more open-ended. Add your assumptions if necessary. Obviously, this algorithm might never result in an answer. Deal with that too.”

In this unit, you will focus on completing your extremism ideology

In this unit, you will focus on completing your extremism ideology case study. As a case study, you will identify the origins of an extremist ideology and the associated movements and groups associated. As a case study, you will place an emphasis on factors contributing to its emergence, critical events associated with the movement, impact on society, and an assessment of the threat posed by either the overall ideology or specific groups within the larger movement. The deliverable for this item will be a formal case study, constituting no less than 2,500 words. APA Format. At Least 3 primary and 5 secondary sources.

this was the question i asked before and the answer you

this was the question i asked before and the answer you gave me was 94% copay pasted from a website “Prepare a 3-4 page paper comparing and contrasting five of the design patterns listed below. Choose any five from the list. DESIGN PATTERNS: Adapter – helps to reuse an object or method by adapting its interface to a more common one Controller – controls client access and manages every request Data Access Object (DAO) – encapsulates access to data, hiding its complexity from users Dispatcher – controls client access and re-directs or dispatches client requests to the proper party that can be located on the same or a different tier Façade – hides a functional complexity; DAO can be considered a specialized Façade Factory Method – creates a family of related objects instantiated by subclasses Abstract Factory Method – creates a family of families (adds a dimension to the Factory Method) Model – logically represents (models) system states and functions Observer – provides a mechanism (implementing an interface or abstract class) for event notification Proxy – provides access to a remote target via an intermediate object View – takes responsibility for the presentation layer Model-View-Controller (MVC) – separates business and presentation logic into three components named by design patterns listed above (this is an example of an architectural design pattern)” – Sent to Computer Science Expert Tutor on 10/29/2010 at 10:22am Dear Student, Please find the attached solution clarified. Regards Download Attachment: 6456364.zip

the body mass of a flea is about 0.5 what

the body mass of a flea is about 0.5 what

A Shopping Cart In this exercise you will complete a class

A Shopping Cart In this exercise you will complete a class that implements a shopping cart as an array of items. The file Item.java contains the definition of a class named Item that models an item one would purchase. An item has a name, price, and quantity (the quantity purchased). The file ShoppingCart.java implements the shopping cart as an array of Item objects. 1. Complete the ShoppingCart class by doing the following: a. Declare an instance variable cart to be an array of Items and instantiate cart in the constructor to be an array holding capacity Items. b. Fill in the code for the increaseSize method. Your code should be similar to that in Listing 7.8 of the text but instead of doubling the size just increase it by 3 elements. c. Fill in the code for the addToCart method. This method should add the item to the cart and update the totalPrice instance variable (note this variable takes into account the quantity). d. Compile your class. 2. Write a program that simulates shopping. The program should have a loop that continues as long as the user wants to shop. Each time through the loop read in the name, price, and quantity of the item the user wants to add to the cart. After adding an item to the cart, the cart contents should be printed. After the loop print a “Please pay …” message with the total price of the items in the cart. // *************************************************************** // item.java // // Represents an item in a shopping cart // *************************************************************** import java.text.NumberFormat; public class Item { private String name; private double price; private int quantity; // ——————————————————- // Return a string with the information about the item // ——————————————————- public String toString () { NumberFormat fmt = NumberFormat.getCurrencyInstance(); return (name “t” fmt.format(price) “t” quantity “t” fmt.format(price*quantity)); } // ————————————————- // Returns the unit price of the item // ————————————————- public double getPrice() { return price; } // ————————————————- // Returns the name of the item // ————————————————- public String getName() { return name; } // ————————————————- // Returns the quantity of the item // ————————————————- public int getQuantity() { return quantity; } } // ********************************************************************** // ShoppingCart.java // // ********************************************************************** import java.text.NumberFormat; public class ShoppingCart { private int itemCount; // total number of items in the cart private double totalPrice; // total price of items in the cart private int capacity; // current cart capacity // ———————————————————– // Creates an empty shopping cart with a capacity of 5 items. // ———————————————————– public ShoppingCart() { capacity = 5; itemCount = 0; totalPrice = 0.0; } // ——————————————————- // Adds an item to the shopping cart. // ——————————————————- public void addToCart(String itemName, double price, int quantity) { } // ——————————————————- // Returns the contents of the cart together with // summary information. // ——————————————————- public String toString() { NumberFormat fmt = NumberFormat.getCurrencyInstance(); String contents = “nShopping Cartn”; contents = “nItemttUnit PricetQuantitytTotaln”; for (int i = 0; i < itemCount; i ) contents = cart[i].toString() "n"; contents = "nTotal Price: " fmt.format(totalPrice); contents = "n"; return contents; } // ——————————————————— // Increases the capacity of the shopping cart by 3 // ——————————————————— private void increaseSize() { } }

Averaging Numbers As discussed in Section 7.4 of the text book,

Averaging Numbers As discussed in Section 7.4 of the text book, when you run a Java program called Foo, anything typed on the command line after “java Foo” is passed to the main method in the args parameter as an array of strings. 1. Write a program Average.java that just prints the strings that it is given at the command line, one per line. If nothing is given at the command line, print “No arguments”. 2. Modify your program so that it assumes the arguments given at the command line are integers. If there are no arguments, print a message. If there is at least one argument, compute and print the average of the arguments. Note that you will need to use the parseInt method of the Integer class to extract integer values from the strings that are passed in. If any non-integer values are passed in, your program will produce an error, which is unavoidable at this point. 3. Test your program thoroughly using different numbers of command line arguments.

A Shopping Cart Write a program that simulates shopping. The program

A Shopping Cart Write a program that simulates shopping. The program should have a loop that continues as long as the user wants to shop. Each time through the loop read in the name, price, and quantity of the item the user wants to add to the cart. After adding an item to the cart, the cart contents should be printed. After the loop print a “Please pay …” message with the total price of the items in the cart. // ********************************************************************** // ShoppingCart.java // // ********************************************************************** import java.text.NumberFormat; public class ShoppingCart { private int itemCount; // total number of items in the cart private double totalPrice; // total price of items in the cart private int capacity; // current cart capacity // ———————————————————– // Creates an empty shopping cart with a capacity of 5 items. // ———————————————————– public ShoppingCart() { capacity = 5; itemCount = 0; totalPrice = 0.0; } // ——————————————————- // Adds an item to the shopping cart. // ——————————————————- public void addToCart(String itemName, double price, int quantity) { } // ——————————————————- // Returns the contents of the cart together with // summary information. // ——————————————————- public String toString() { NumberFormat fmt = NumberFormat.getCurrencyInstance(); String contents = “nShopping Cartn”; contents = “nItemttUnit PricetQuantitytTotaln”; for (int i = 0; i < itemCount; i ) contents = cart[i].toString() "n"; contents = "nTotal Price: " fmt.format(totalPrice); contents = "n"; return contents; } // ——————————————————— // Increases the capacity of the shopping cart by 3 // ——————————————————— private void increaseSize() { } }

1,Explain the following unexpected result: $ whereis date Date: /bin/date …

1,Explain the following unexpected result: $ whereis date Date: /bin/date … $ echo $PATH .:/usr/local/bin:/usr/bin:/bin $ cat > date echo “This is my own version of date.” $ date Sat May 24 11:45:49 PDT 2008

You have asked to prepare a report that evaluates possible client/server

You have asked to prepare a report that evaluates possible client/server solutions to handle a new customer application system for all branch offices. What business characteristics would you evaluate? What technology characteristics would you evaluate? Why?

This is my first week in an online Java class and

This is my first week in an online Java class and I am having a problem with this question: Write a class that accepts a user’s hourly rate of pay and the number of hours worked. Display the user’s gross pay, the withholding tax (15% of gross pay), and the net pay (gross pay – withholding). Save the class as Payroll.java.

It’s my first week in an online java class and I

It’s my first week in an online java class and I don’t have a clue. Here are the two questions that I am having problems with: 1. Write a class that accepts a user’s hourly rate of pay and the number of hours worked. Display the user’s gross pay, the withholding tax (15% of gross pay), and the net pay (gross pay – withholding). Save the class as Payroll.java. 2. Write a program that accepts a temperature in Fahrenheit from a user and conversts it to Celsius by subtracting 32 from the Fahrenheit value and multiplying the result by 5/9. Disply both values. Save the class as FahrenheitToCelsius.java.

The post Problem 2 (30 Points) The database schema is as follows: AIRPORT(city, appeared first on uniessay writers.

[ad_2]

Source link