SELECT SQL_CALC_FOUND_ROWS posting_id, rw1.node_name AS subject, rw2.node_name AS topic FROM posting, rewrite_sol_bm AS rw1, rewrite_sol_bm AS rw2
WHERE ota_id=101620
AND type=1
AND library_status=1
AND posting.subject_id=rw1.subject_id
AND posting.topic_id=rw2.topic_id
AND rw1.node_type=1
AND rw2.node_type=2
ORDER BY library_downloads DESC LIMIT 0, 20
Transportation Problem - The Darby Company manufactures and distributes meter used to measure electric power consumption. The company started with a small production plant in El Paso and gradually built a customer base throug ...
Simple algorithm using the big theta - notation - Sometimes a slight change in a problem can significantly alter the form of its solution. For example, find a simple algorithm for solving the following problem and classify it using big-theta notatio ...
MS SQL STATEMENT PROBLEMS - I am using Microsoft SQL Server 2000
1. Database Tables
TABLE: Employees
Job_title_code
Social_security_number
Last_name
First_name
Address
City
State
Zip_code
Telephone_ar ...
Break-even Point - 1. Air Filter, Inc., sells its products for $6 per unit. It has the following costs:
Rent $100,000
Factory labor $1.20 per unit
Executive salaries $89,000
Raw material $.60 per unit
Separate ...
Database analysis - Please examine this database and provide your input.
1. Are the tables normalized?
2. Are the relationships between the tables correct?
3. Do any of the tables need indexes?
4. Are the indexes c ...
Linear Programming : Maximizing Profit - Furniture Unlimited has the capability to manufacture desks, cabinets, and chairs. In order to manufacture these product, it must rent the appropriate equipment at a weekly cost of $2,000 for the desk ...
Solving Systems of Equations using a Matrix Method - A company's employees are working to create a new energy bar. They would like the two key ingredients to be peanut butter and oats, and they want to make sure they have enough carbohydrates and prote ...
8-word 32 bit RAM - I need to design an 8 word, 32bit RAM using 8x8 RAMs. Can you help? Thanks.
Two D-Type Flip-Flop Questions - Please help me solve the attached sets of problems.
Mock Exam 2000:
Consider the following circuit {see attached}.
IC 1 is a 3-bit asynchronous (ripple) counter, positive-edge triggered. At hig ...
Decision-Making : Decision Trees and Payoffs - Problem 14
A manufacturer must decide whether to build a small or a large plant at a new location. Demand at the location can be either small or large, with probabilities estimated to be 0.4 and 0.6 ...
Modeling, Trends and Forecasting - Suppose that the function represents the percentage of inbound e-mail in the U.S. that is considered spam, where x is the number of years after 2000.
Carry all calculations to six decimals on ea ...
How do I create a flow chart and pseudocode for this problem? - Calculating a discount that customers receive based on the value of their order. If the total amount ordered is less than $20.00, no discount will be given. If the total amount is between $20.00 and $ ...
partial fraction expansion - We have a function(see Attachment). Using a partial fraction expansion of Y(s) find Y(z) when T=0.2 seconds.
Roots, rate of change, and maximum and minimum - Find the maximum and minimum values attained by the function on the interval [0, 2].
h(x)=x-1/x+1
The equation has three distinct real roots. Approximate
their locations by evaluating f at ...
investigation (Diagonals in a Rectangle) - Diagonals in a Rectangle.
In the case of a 2 X 2 rectangle, or a 3 X 5 rectangle, we can simply count. However, can we make a decision about a 100 X 167 or a 3600 X 288 rectangle? In general, given ...
Probability : Random Variables - Suppose that the height, in inches, of a 25-year-old man is a normal random variable with parameters μ = 71 and o^2 = 6.25. What percentage of 25-year-old men are over 6 feet 2 inches tall? What ...