5. An oil company having two oil fields (OF1 and OF2) can produce 1500 barrels of crude oil per day from OF1 and 1700 barrels of crude oil from OF2. From OF1 and OF2 the crude oil can be piped to three tank farms (TF1, TF2, TF3). The shipment cost from OF1 to TF1, TF2 and TF3 is 3, 5 and 6 dollars whereas the shipment cost from OF2 to TF1, TF2 and TF3 is 1, 4 and 7 dollars, respectively. The transfer between tank farms is not possible. Every day, each tank farm needs 200 barrels of crude oil for its own use. From tank farms (TF1, TF2, TF3) the oil is transferred to the refinery station (RS) at a cost of 4, 3 and 6 dollars per barrel, respectively. The refinery station (RS) can only process up to 2000 barrels per day. The pipes used between oil fields and tank farms have a capacity of 500 barrels per day while the pipes between tank farms and the refinery station have a capacity of 800 barrels per day. Construct your MCNF network for the problem using an appropriate dummy node (show arc costs, arc capacities, node net flows on your network).

5. An oil company having two oil fields (OF1 and OF2) can produce 1500 barrels of crude oil per day from OF1 and 1700 barrels of crude oil from OF2. From OF1 and OF2 the crude oil can be piped to three tank farms (TF1, TF2, TF3). The shipment cost from OF1 to TF1, TF2 and TF3 is 3, 5 and 6 dollars whereas the shipment cost from OF2 to TF1, TF2 and TF3 is 1, 4 and 7 dollars, respectively. The transfer between tank farms is not possible. Every day, each tank farm needs 200 barrels of crude oil for its own use. From tank farms (TF1, TF2, TF3) the oil is transferred to the refinery station (RS) at a cost of 4, 3 and 6 dollars per barrel, respectively. The refinery station (RS) can only process up to 2000 barrels per day. The pipes used between oil fields and tank farms have a capacity of 500 barrels per day while the pipes between tank farms and the refinery station have a capacity of 800 barrels per day. Construct your MCNF network for the problem using an appropriate dummy node (show arc costs, arc capacities, node net flows on your network).

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

question 2 and 3 are not answered.!
On the Faculty Data worksheet, in cell J3, use an IFS function to calculate the retirement matching dollar amount for each faculty member participating in the retirement plan. If the participating member is a Full Professor, the matching amount is 4% of the salary. Otherwise, the matching amount is 3% of the salary. If the member is not participating, show a blank.
Task 4: The InstantRide User Satisfaction team is a core team for InstantRide, and they focus on increasing the customer satisfaction. They want to learn the travel time for each ride in the system. You need to return the USER_ID, and the TRAVEL_TIME column which is calculated using the TIMEDIFF function on the TRAVEL_END_TIME and the TRAVEL_START_TIME.
Explain the below figure. Your answer should contain a minimum of two paragraphs(Each paragraph should at least have a minimum of 150 words)
Employees(employee_id, first_name, last_name, salary, hire_date, job_title, manager_id) Which of the following queries will display the last name of all employees who's managed by 'KING'? Select one: a.SELECT e.last_name FROM employees e, employees m WHERE upper(last_name) = 'KING' b.SELECT e.last_name FROM employees e, employees m WHERE e.manager_id = m.employee.id and upper(m.last_name) = 'KING' c.none of the above d.SELECT m.last_name FROM employees e, employees m WHERE e.manager_id = m.employee.id
What is the combination of newline character?
(1) for each Customer (e.g., customer C), display all other customers who have higher salary than this Customer (e.g., customer C). (use inner join, display each customer’s ID, name, and all higher salaries, you don’t need to display information about the customers who have higher salary.) (2) for each Customer (e.g., customer C), display all other customers who have higher salary and are younger than this Customer (e.g., customer C).
Below are some rows of the PROVIDERS table for a factory: PCODE 10192 98411 0489035 NAME Hans, Inc. Tools and More Motors Inc. PHONE 231 - 3092 231-1029 993 - 1821 All providers from the factory zone of the city start with 231. You want to get the providers that are in the factory zone of the city. Which of the following is more appropriate? O a. O b. SELECT * FROM PROVIDERS WHERE PHONE LIKE '% 231' O C. O d. SELECT * FROM PROVIDERS WHERE PHONE LIKE $231%' SELECT * FROM PROVIDERS WHERE PHONE LIKE 231 SELECT * FROM PROVIDERS WHERE PHONE LIKE '%231%'
On the Sales Data worksheet, calculate the commission rate and commission paid for each sales associate. Beginning in cell F4, enter a formula using the IFS function to calculate the commission rate based on the following table. Hint: Do not include comma separators in numerical values in formulas. Excel interprets commas as function argument separators.
King LPAD Select the letter of the correct output of the given SQL statement below: SELECT TO_CHAR(123456,'00099') FROM DUAL; O a. ###### O b. 000123456 O c. 123456 O d. ##### What will be the datatype of the result of the following oneration?
Please provide two customer-writer arguments. Please answer my question in the specified section. according to computer experts.
How do you tell the difference between a team and a domain?