Given the following query: SELECT DISTINCT zip, category FROM customers NATURAL JOIN orders NATURAL JOIN orderitems NATURAL JOIN books; Which of the following queries is equivalent? a. SELECT zip...
Use the following SELECT statement to answer. 1 SELECT customer#, COUNT(*) 2 FROM customers JOIN orders USING (customer#) 3 WHERE orderdate > '02-APR-09' 4 GROUP BY customer# 5 HAVING COUNT(*) > 2;...
Which of the following statements is correct? a. If a subquery is used in the outer querys FROM clause, the data in the temporary table cant be referenced by clauses used in the outer query. b. The...
Create a view that lists the name and phone number of the contact person at each publisher. Dont include the publishers ID in the view. Name the view CONTACT.
In a DHT-based network, assume m = 4. If the hash of a node identifier is 18, where is the location of the node in the DHT space?
Show how the tables in your answer to question 4.25 solve the problems you identified in question 4.24.
Assume an ISP uses three leaky buckets to regulate data received from three customers for transmitting to the Internet. The customers send fixed-size packets (cells). The ISP sends 10 cells per...
This question considers representing satisfiability (SAT) problems as CSPs. a. Draw the constraint graph corresponding to the SAT problem ( X 1 X 2 ) ( X 2 X 3 ) . . . ( X n1 X n ) for the...
Write a program that declares a variable named inches, which holds a length in inches, and assign a value. Display the value in feet and inches; for example, 86 inches becomes 7 feet and 2 inches. Be...
Herberts Home Repair estimates each job cost as the cost of materials plus $35 per hour while on the job, plus $12 per hour for travel time to the job site. Create a class that contains a main()...
a. Create a class named Sandwich. Data fields include a String for the main ingredient (such as tuna), a String for bread type (such as wheat), and a double for price (such as 4.99). Include methods...
In each case, determine the problem and fix the program. After you correct the errors, save each file using the same filename preceded with Fix. For example, save DebugFour1.java as...
you created a program named Triangle in which you displayed a seven-line triangle pattern like the one in Figure 6-33 by using a series of println() statements. Now, using your knowledge of loops,...
A personal phone directory contains room for first names and phone numbers for 30 people. Assign names and phone numbers for the first 10 people. Prompt the user for a name, and if the name is found...
You created a Salesperson class with fields for an ID number and sales values. Now, create an application that allows a user to enter values for an array of seven Salesperson objects. Offer the user...
You created a Salesperson class with fields for an ID number and sales values. Now, create an application that allows you to store an array that acts as a database of any number of Salesperson...
Create an abstract NewspaperSubscription class with fields for the subscriber name, address, and rate. Include get and set methods for the name field and get methods for the address and subscription...
Write an application named UseInsurance that uses an abstract Insurance class and Health and Life subclasses to display different types of insurance policies and the cost per month. The Insurance...
Open the Amlie Solution.sln file contained in the VB2017\Chap02\Amlie Solution folder. If necessary, open the designer window. Organize the interface so that it follows the GUI design guidelines...
Create a Windows Forms application. Use the following names for the project and solution, respectively: Moonbucks Project and Moonbucks Solution. Save the application in the VB2017\Chap02 folder....
In this exercise, you learn how to create a list box that allows the user to select more than one item at a time. Open the Multi Solution.sln file contained in the VB2017\Chap05\Multi Solution...
Given a memory with a 24-bit address and 8-bit word size, (a) How many bytes can be stored in this memory? (b) If this memory were constructed from 1K 1-bit RAM chips, how many memory chips would be...
Given the input wave forms shown in Figure 3.63, sketch the output, Q, of a D latch. CLK Figure 3.63 Input waveforms of D latch or flip-flop for Exercises 3.3 and 3.5
1. Jesse wants me to investigate GanttProject software to determine whether it would be suitable for SCR. She asked me to prepare a summary of pros and cons, and a sample of screen shots and...
Write a program that reads an integer between 0 and 1000 and adds all the digits in the integer. For example, if an integer is 932, the sum of all its digits is 14. Use the % operator to extract...
Describe an algorithm, relying only on the BinaryTree operations, that counts the number of leaves in a binary tree that are the left child of their respective parent.
Design a flowchart or pseudocode for a program that accepts two numbers from a user and displays one of the following messages: First is larger , Second is larger , Numbers are equal .
Design the logic for a program that outputs every number from 1 through 15.
Suppose that you have declared an array as follows: num values[4] = 0, 0, 0, 0. Which of the following is an allowed operation? a. values[2] = 17 b. input values[0] c. values[3] = values[0] + 10 d....
Executive Training School offers typing classes. Each final exam evaluates a students typing speed and the number of typing errors made. Develop the logic for a program that produces a summary table...
Although the terms parameter and argument are closely related, the difference is that argument refers to _____. a. A value in a method call b. A passed constant c. A formal parameter d. A variable...
a. Create the logic for a program that calculates and displays the amount of money you would have if you invested $5000 at 2 percent simple interest for one year. Create a separate method to do the...
Create the logic for a program that continuously prompts a user for a numeric value until the user enters 0. The application passes the value in turn to the following methods: A method that displays...
Design a class named Computer that holds the make, model, and amount of memory of a computer. Include methods to set the values for each data field, and include a method that displays all the values...
Complete the following tasks: a. Create a class named Order that performs order processing of a single item. The class has four fields: customer name, customer number, quantity ordered, and unit...
Create a program that allows the user to enter an unknown number of sales amounts for each of three car dealerships: Dealership 1, Dealership 2, and Dealership 3. The program should calculate the...
Determine the order of each of the following growth functions. a. 10n 2 + 100n + 1000 b. 10n 3 7 c. 2 n + 100n 3 d. n 2 log n
Repeat Exercise 5 in Chapter 7, but use an instance of ArrayList instead of an array. Exercise 5 in Chapter 7 Write a program in a class CharacterFrequency that counts the number of times a digit...
Write code to insert two additional elements, " dark " and " and ", at the proper places in the list to produce the following ArrayList as the result: ["It", "was", "a", "dark", "and", "stormy",...
Design a collection of database tables for the Springfield Town Council. The council is made up of representatives from each of the towns 15 precincts. The data you need to store includes the...
How long (max) will it take for the output of a 74ALS00 to go HIGH after its input goes LOW?
Consider the list of individual 3NF relations below. These relations were developed from several separate normalization activities. PATIENT(Patient_ID,Room_Number,Admit_Date,Address)...
Where are the current career opportunities for the IT auditor? Search the Internet and identify at least one job profile/description for each career opportunity identified above. For each job profile...
List and describe three types of computers.
Assume the following register contents: $t0 = 0xAAAAAAAA, $t1 = 0x12345678 1. [5] For the register values shown above, what is the value of $t2 for the following sequence of instructions? 2. For the...
As discussed in the text, one possible performance enhancement is to do a shift and add instead of an actual multiplication. Since 9 6, for example, can be written (2 2 2 + 1) 6, we can calculate...
Let T be a (possibly improper) binary tree with n nodes, and let D be the sum of the depths of all the external nodes of T. Describe a configuration for T such that D is Ω(n 2 ). Such a...
Suppose an initially empty stack S has performed a total of 25 push operations, 12 top operations, and 10 pop operations, 3 of which returned null to indicate an empty stack. What is the current size...
Four channels, two with a bit rate of 200 kbps and two with a bit rate of 150 kbps, are to be multiplexed using multiple-slot TDM with no synchronization bits. Answer the following questions: a. What...
Ten sources, six with a bit rate of 200 kbps and four with a bit rate of 400 kbps, are to be combined using multilevel TDM with no synchronizing bits. Answer the following questions about the final...
We have a baseband channel with a 1-MHz bandwidth. What is the data rate for this channel if we use each of the following line coding schemes? a. NRZ-L b. Manchester c. MLT-3 d. 2B1Q
What is the Hamming distance for each of the following codewords? a. d (10000, 00000) b. d (10101, 10000) c. d (00000, 11111) d. d (00000, 00000)
The light of the sun takes approximately eight minutes to reach the earth. What is the distance between the sun and the earth?
Traditional checksum calculation needs to be done in ones complement arithmetic. Computers and calculators today are designed to do calculations in twos complement arithmetic. One way to calculate...
In an 802.11 network, station A sends two data fragments to station B. What would be the value of the D field (in microseconds) that needs to be set for the NAV period in each of the following...
We have the information shown below. Show the contents of the IP datagram header sent from the remote host to the home agent. Mobile host home address: 130.45.6.7/16 Mobile host care-of address:...
Use Dijkstra's algorithm (Table 20.2) to find the shortest path tree and the forwarding table for node A in the Figure 20.35. Table 20.2 4. 4. 3. 3.
To make the initial sequence number a random number, most systems start the counter at 1 during bootstrap and increment the counter by 64,000 every half second. How long does it take for the counter...
Write a program to make the UDP server program in Table 25.1 more generic: to receive a request, to process the request, and to send back the response. Table 25.1 Table 25.1 Echo server program using...
You have been assigned to design the database for a new soccer club. Indicate the most appropriate sequence of activities by labeling each of the following steps in the correct order. (For example,...
Use the fact database and patron collection created in the text for use with MongoDB. Write a query to retrieve only the first name, last name, and type of faculty patrons that have checked out at...
Use the fact database and patron collection created in the text for use with MongoDB. Create a new document in the patron collection. The document should satisfy the following requirements: First...
List the title only of all books available in inventory, using the BOOKS table.
Add a new row in the ORDERS table with the following data: Order# = 1023 and Customer# = 1009. Describe the error raised and what caused the error.
Delete the CUSTOMERREP role from the Oracle 12c database.
Which of the following is correct? a. The ORDER BY clause cant be used in the subquery of a CREATE VIEW command. b. The ORDER BY clause cant be used in an inline view. c. The DISTINCT keyword cant be...
A random number generator produces numbers between 1 and 99. If the current value of the random variable is 45, then what is the probability that the next randomly generated value for the same random...
A wireless receiver with an effective diameter of 250 cm is receiving signals at 20 GHz from a transmitter that transmits at a power of 30 mW and a gain of 30 dB. (a) What is the gain of the receiver...
In a cellular system, diffraction, reflection, and direct path take different amount of time for the signal to reach an MS. How do you differentiate and use these signals? Explain clearly. Compute...
During a busy hour, the number of calls per hour for each of the 12 cells of a cellular cluster is 2220, 1900, 4000, 1100, 1000, 1200, 1800, 2100, 2000, 1580, 1800 and 900. Assume that 75% of the car...
a. Determine the power of each digit for five-digit numbers in base 6. b. Use your results from part (a) to convert the base 6 number 24531 6 to decimal.
Alice can use only the additive cipher on her computer to send a message to a friend. She thinks that the message is more secure if she encrypts the message two times, each time with a different key....
Professor Olay is consulting for an oil company, which is planning a large pipeline running east to west through an oil field of n wells. The company wants to connect Figure 9.2 Professor Olay needs...
Modify the HYBRID-WUMPUS-AGENT to use the 1-CNF logical state estimation method described on page 271. We noted on that page that such an agent will not be able to acquire, maintain, and use more...
we mentioned iterative lengthening search, an iterative analog of uniform cost search. The idea is to use increasing limits on path cost. If a node is generated whose path cost exceeds the current...
Consider a state space where the start state is number 1 and each state k has two successors: numbers 2k and 2k + 1. a. Draw the portion of the state space for states 1 to 15. b. Suppose the goal...
What is the numeric value of each of the following expressions as evaluated by Java? a. 4 + 6 * 2 b. 10 / 5 + 8 c. 12 / 4 + 16 / 2 d. 17 / 2 e. 22 / 5 f. 39 / 10 g. 19 % (2 + 3) h. 3 + 4 * 20 / 3 i....
Write a program that declares variables to hold your three initials. Display the three initials with a period following each one, as in J.M.F. Save the program as Initials.java.
In Section 15.3.2, the prior distribution over locations is uniform and the transition model assumes an equal probability of moving to any neighboring square. What if those assumptions are wrong?...
The Harrison Group Life Insurance company computes annual policy premiums based on the age the customer turns in the current calendar year. The premium is computed by taking the decade of the...
A sequence of characters enclosed within double quotation marks is a ____________. a. Literal string b. Symbolic string c. Prompt d. Command
Sammys Seashore Supplies rents beach equipment to tourists. In previous chapters, you developed a class that holds equipment rental information and an application that tests the methods using three...
The method parseInt() converts a(n) ____________. a. Integer to a String b. Integer to a Double c. Double to a String d. String to an integer
You developed classes that hold rental contract information for Sammys Seashore Supplies. Now modify the Rental and RentalDemo classes as follows: Modify the Rental class to include an integer field...
You created a CertOfDeposit class. Now, create an application to accept data for an array of five CertOfDeposit objects, and then display the data. Save the application as CertOfDepositArray.java.
Create a class named Majors that includes an enumeration for the six majors offered by a college as follows: ACC, CHEM, CIS, ENG, HIS, PHYS. Display the enumeration values for the user, and then...
a. The Talk-A-Lot Cell Phone Company provides phone services for its customers. Create an abstract class named PhoneCall that includes a String field for a phone number and a double field for the...
Write an application that determines which, if any, of the following files are stored in the folder where you have saved the exercises created in this chapter: autoexec.bat, CompareFolders.java,...
Open the Colors Solution.sln file contained in the VB2017\Chap01\Colors Solution folder. If necessary, open the designer window. The interface contains one label control and two buttons. You can use...
In this exercise, you will complete the Restaurant Tip application from Chapter 2s Focus on the Concepts lesson. The applications Planning Chart is shown in Figure 3-34. a. Use either a flowchart or...
In this exercise, you modify the Monthly Payment application from this chapters Apply lesson. Use Windows to make a copy of the Payment Solution folder. Rename the copy Payment Solution-DoLoop. Open...
In this exercise, you modify the Savings Account application from this chapters Apply lesson. Use Windows to make a copy of the Savings Solution folder. Rename the copy Modified Savings Solution....
Open the FixIt Solution.sln file contained in the VB2017\Chap05\FixIt Solution folder. Open the Code Editor window and review the existing code. Start and then test the application. Correct any...
Design a 4-bit, 8-function arithmetic unit that will meet the following specifications: S2 0 0 0 0 1 1 1 1 S1 0 0 1 1 0 0 1 1 SO 0 1 0 1 0 1 0 1 F 2A A plus B A plus B A minus 1 2A plus 1 A plus B...
Write an HDL module that implements the priority encoder from Exercise 2.36. Data from Problem 2.36 A priority encoder has 2 N inputs. It produces an N-bit binary output indicating the most...
Open the VB2017\Chap11\FixIt Solution\FixIt Solution.sln file. Open the Code Editor window. Correct any errors in the code. Start the application. Click the Calculate button. The total on hand should...
The vice president of accounting says to you, the IT director, This request procedure takes too long. My people know what they are doing and their systems requests are necessary and important. She...
Write a program that animates MyHashMap, as shown in Figure 27.8. You can change the initial size of the table. Assume the load-factor threshold is 0.75. Firetox...
Implement the dictionary operations INSERT, DELETE, and SEARCH using singly linked, circular lists. What are the running times of your procedures?
Repeat Exercise 8.3 for the case when the fully associative cache outperforms the direct mapped cache. Data From Problem 3 Come up with a sequence of addresses for which a direct mapped cache with a...