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: If a GROUP BY clause is included in a SQL query, the characteristics that may be sought in the…

A: Introduction: The Aggregate BY clause in SQL is used to group the results of a SELECT operation on a…

Q: In which clause should you include the condition MAX(cost) &gt; 39 to restrict groups displayed in…

A: The HAVING clause is used with the aggregated functions. examples of aggregated functions are sum,…

Q: Report the name of the customer who bought the most expensive product. sql

A: According to the information given:- We have to write query  in order to get the name of the…

Q: If a GROUP BY clause is included in a SQL query, the characteristics that may be sought in the…

A: In SQL ,If a select block does have a GROUP BY clause, any column specification specified in the…

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: 7. For each project, display project name, project platform, project cost and total number of…

A: In sql, we use SELECT statement to display the table details according to the requirement. We will…

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: In SQL, the WHERE clause to the SELECT statement states the criteria that must be met: Multiple…

A: EXPLANATION: SQL is a database language that allows you to store, manipulate, and retrieve data.…

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: enter null value in a column where the Unique constraint is assigned to that column

A: enter null value in a column where the Unique constraint is assigned to that column True or False

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: Which operator should you employ in order to locate NULL values?

A: IS NULL operator is used to locate NULL values

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: List State, Sales Year, Current Year Sales, Last Year Sales, and Change in Total Yearly Sales for…

A: based on your description, here's an example SQL query that give you the result you're looking for:…

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: Fetured Bikes 2021 Best bike collection

A: We have to create a section- In which there will be a Heading and one sub-heading. After that, there…

Q: In which normal form no column should depend on other columns? O You must select at least 1 choice O…

A: Let us understand what the First Normal Form(1NF) is. A relation or table is said to be in first…

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:

Q: 7. Use the UNION operator to generate a result set consisting of three columns from the Products…

A: The UNION operator in SQL is used to combine the results of two or more SELECT queries into a single…