For this section, no need to solve the questions and submit answers Your company is a major distributor of coffee in the UAE. You can buy coffee from 5 roasters and distribute the coffee to three UAE cities (Al-Ain, Abu Dhabi, and Dubai). The monthly demand in the three cities is as follows: City Monthly Demand (tons) 1- Al-Ain 50 2- Abu Dhabi 120 3- Dubai 280 In order to guarantee supplies from the five coffee roasters, you need to sign a monthly contract with fee. If you decide to sign a contract with a roaster, you need to pay the contract fee and then you need to pay for transportation cost of any coffee supplied from the roaster to the 3 cities. The production capacity of each roaster and their monthly fee are as follows: Roaster Monthly Supply (tons) Monthly Fee (contract) A 75 $800 B 150 $1200 C 175 $1350 D 200 $1500 E 125 $1000 The transportation cost per ton of coffee from roasters to the 3 UAE cities is as follows: Roaster Al-Ain Abu Dhabi Dubai A $5 $8 $6 B $3 $6 $7 C $4 $9 $6 D $8 $5 $9 E $7 $9 $2 Your company asked you to minimize the total monthly cost of coffee supply from the five roasters and distribution to the three UAE cities. 12. How many binary decision variables are needed for the formulation? (1 Point) 15 20 5 3 13. If Y is used to represent the binary decision variable, one of the following is the correct formulation for the constraint that represents the capacity of Roaster C: (1 Point) Xc1 + Xc2 +Xc3 - 175Yc <= 0 X1c + X2c +X3c <= 175 X1c + X2c +X3c-175Yc <= 0 Xc1 + Xc2 +Xc3 <= 175

Q: The WHERE statement identifies the. Sort None of these Filter All of these Table Fields

A: The WHERE statement identifies the

Q: Display employees where the first name or last name starts with S. using sql plus hr user

A: To select data from a database,  SELECT statement are used. The data is saved in a result table…

Q: Create a query based on the EMP table that satisfies the criteria below Use the TO_CHAR function to…

A: Solution:   When you install Oracle 11g Enterprise Edition there are couple databases you can chose…

Q: In each question below, you will define a new table based on the following tables.

A: The SQL question involves creating tables and sentences based on parent-child relationships, dog…

Q: How many distinct visit reasons start with the word "Pain"? Name the result column as NumPainReason.…

A: SELECT COUNT(DISTINCT VisitReason) AS NumPainReason FROM VisitWHERE VisitReason LIKE 'Pain%';

Q: The HR department needs a report to display employee information as shown from the job_history…

A: SOLUTION- With using DATEDIFF - Below is the SQL query that you could use to generate the report:…

Q: please use the picture below to answer the following question Display employee number, employee…

A: SELECT EmployeeID, Emp_LName, HireDate FROM Employee e JOIN Position pWHERE e.Emp_LName like '%e%'…

Q: 8. Use a SELECT statement to view the CURRVAL of NUMGEN. Delete the NUMGEN synonym and MY_FIRST_SEQ.

A: Please check the solution below

Q: department name information for those departments whose location_id is 1500

A: Attributes of Department Table are- department_id department_name employee_id location_id

Q: 8. In the OrderItems table, display the minimum item_price with the alias shown. 2.49 1 rows…

A: Below is the complete solution with explanation in detail for the given question about writing query…

Q: Display the PID and average prices from the PRODUCTS table which price is less than the average…

A: Here we need to perform group by operation in the main query and use Having clause to select only…

Q: Please read the instrucitons before posting an answer that someone else has already posted.…

A: The new query is given below without using GROUP_CONCAT

Q: CARD_NO PLAYER_NO TEAM_CODE PRICE 44 BR 4.45 27 BR 3.5 54 BR vers cards

A: query SELECT team_code,COUNT(card_no) AS TOTAL_CARD_NO, to_char(SUM(price),'$99.99') as total_price…

Q: Please explain how to set the mining “difficulty”.

A: The difficulties of mining association rules from large databases: 1. Security and social issues:…

Q: Task 7: The StayWell marketing team considers sending small gifts to all residents and owners. To…

A: Sure, I can help you with that. The StayWell marketing team wants to send small gifts to all…

Q: You are in the Marketing Department and are reviewing sales of coffee and espresso products. You are…

A: In the required SQL query, following clauses are used: AS clause to temporarily allocate a new name…

Q: What is the name of the columns of thee left hand side of the relationships between columns called?

A: Here is the solution which is mentioned below:

Q: Item Number (Item Name) In this case, the date of supply is 04 VENDOR Vendor supply chain Authors'…

A: Attribute (Simple): Simple qualities are ones that cannot be further subdivided. For example, in the…

Q: SQL: Dog Data In each question below, you will define a new table based on the following tables.…

A: In this query, we aim to construct a table named by_parent_height that provides a comprehensive view…

Q: Write a SELECT statement that uses the ranking functions to rank products by the total quantity…

A: This query uses a JOIN between the Products and Order_Items tables to get the total quantity of each…

Q: Which clause of a SQL Select statement is required if we want to display aggregate data by category…

A: Solution :  The GROUP BY statement groups rows that have the same values into summary rows, like…

Q: You have been told that you need to store the zip code for employees.  Add a column to the EMPLOYEE…

A: Hello student Greetings   In this scenario, we are required to add a new column to the EMPLOYEE…

Q: IN SQL If you omitted the WHERE clause of SELECT statement, the query returns an error because the…

A: Answer True explanation because if  the condition is  given with the query then where clause is…

Q: Beginning in cell F4, enter a formula using the IFS function to calculate the commission rate based…

A: