First sub-orparto? 3. Suppose that a data warehouse consists of the three dimensions time, doctor, and patient, and the twomeasures count and charge, where charge is the fee that a doctor charges a patient for a visit.(a) Enumerate three classes of schemas that are popularly used for modeling data warehouses.(b) Draw a schema diagram for the above data warehouse using one of the schema classes listed in (a).(c) Starting with the base cuboid [day, doctor, patient], what specific OLAP operations should beperformed in order to list the total fee collected by each doctor in 2004?(d) To obtain the same list, write an SQL query assuming the data is stored in a relational databasewith the schema fee (day, month, year, doctor, hospital, patient, count, charge).

Answered: Image /qna-images/answer/08732e09-8b21-43d8-b8d2-db2c81fb6987.jpg

Answered: 3. Suppose that a data warehouse…

Linear Algebra: A Modern Introduction

4th Edition

ISBN:9781285463247

Author:David Poole

Publisher:David Poole

Chapter2: Systems Of Linear Equations

Section2.4: Applications

Problem 2EQ: 2. Suppose that in Example 2.27, 400 units of food A, 500 units of B, and 600 units of C are placed...

See similar textbooks

Similar questions

2. Suppose that in Example 2.27, 400 units of food A, 500 units of B, and 600 units of C are placed in the test tube each day and the data on daily food consumption by the bacteria (in units per day) are as shown in Table 2.7. How many bacteria of each strain can coexist in the test tube and consume all of the food? Table 2.7 Bacteria Strain I Bacteria Strain II Bacteria Strain III Food A 1 2 0 Food B 2 1 3 Food C 1 1 1
Within a company is a (micro)economy that is monitored by the accounting procedures. In terms of the accounts, the various departments "produce" costs, some of which are internal and some of which are direct costs. This problem shows how an open Leontief model can be used to determine departmental costs. The sales department of an auto dealership charges 10% of its total monthly costs to the service department, and the service department charges 20% of its total monthly costs to the sales department. During a given month, the direct costs are $68,600 for sales and $29,400 for service. Find the total costs (in dollars) of each department. (Round your answers to the nearest whole number.)
Two sectors of the U.S. economy are (1) audio, video, and communication equipment and (2) electronic components and accessories. Suppose in 1998, the input-output table involving these two sectors was as follows (all figures are in millions of dollars). To Equipment Components From 6,200 600 Components 23,000 32,000 Total Output 90,000 140,000 Determine the production levels (in dollars) necessary in these two sectors to meet an external demand for $78,000 million of communication equipment and $92,000 million of electronic components. Round answers to two significant digits.
“PLEASE SOLVE WITH MATLAB, NOT MANUEL!” A corporation that manufactures electronics makes computer chips, transistors, and resistors. Four units of copper, one unit of zinc, and two units each of glass are needed to make one transistor. Each computer chip needs two, one, and three units of these materials, whereas each resistor needs three, three, and one units of each of the three materials. When we convert this data into a table, we get: Supplies of these materials vary from week to week, so the company needs to determine a different production run each week. For example, one week the total amounts of materials available are960 units of copper, 510 units of zinc, and 610 units of glass. Set up the system of equations modelling the production run, and use MATLAB to solve for the number of transistors, resistors, and computer chips to be manufactured this week.
The production planning period for flat-screen moni-tors at Louisiana’s Roa Electronics, Inc., is 4 months. Cost data are as follows:Regular-time cost per monitor $ 70Overtime cost per monitor $110Subcontract cost per monitor $120Carrying cost per monitor per month $ 4 For each of the next 4 months, capacity and demand for flat-screen monitors are as follows: PERIOD MONTH 1 MONTH 2 MONTH 3 a MONTH 4Demand 2,000 2,500 1,500 2,100CapacityRegular time 1,500 1,600 750 1,600Overtime 400 400 200 400Subcontract 600 600 600 600aFactory closes for 2 weeks of vacation.CEO Mohan Roa expects to enter the planning period with 500monitors in stock. Back ordering is not permitted (meaning, forexample, that monitors produced in the second month cannot beused to cover first month’s demand). Develop a production planthat minimizes costs using the transportation method.
A quality control engineer studied the relationship between years of experience as a system control engineer and the capacity of the engineer to complete within a given time a complex control design including the debugging of all computer programs and control devices. A group of 25 engineers having widely differing amounts of experience (measured in months of experience) was given the same control design project. The results of the study are given in the following table with y 5 1 if the project was successfully completed in the allocated time and y 5 0 if the project was not successfully completed. a. Determine whether experience is associated with the probability of completing the task. b. Compute the probability of successfully completing the task for an engineer having
A line of LRT with five (5) stations will be constructed in a city. A forecast passenger demand is given below: Depart Station Boarding Station 1 2 3 4 5 1 0 1600 10000 2000 250 2 230 0 11000 2071 230 3 60 1400 0 1500 170 4 250 1700 10400 0 250 5 300 1900 12000 2500 0 (a) Compute the number of passengers between each pair of the stations for both directions.(b) In this LRT project, headway must not be less than 120 seconds and must not be greater than 300 seconds. All stations are designed to cater a train of 6 couches. The capacity of each couch is 280 passengers. Based on the computed maximum passengers in (a), compute headway possibilities and corresponding number of couches per train. You may use rail utilisation factor of 0.75 and load factor of 0.9.
Communication Equipment Two sectors of the U.S. economy are (1) audio, video, and communication equipment and (2) electronic components and accessories. Suppose in 1998, the input-output table involving these two sectors was as follows (all figures are in millions of dollars). To Equipment Components (From) Equipment 5,900 500 (From) Components 24,000 29,000 Total Output 90,000 140,000 Determine the production levels (in dollars) necessary in these two sectors to meet an external demand for $81,000 million of communication equipment and $90,000 million of electronic components. Round answers to two significant digits. equipment: $ ? millions components: $ ? millions
A company makes two products (X and Y) using two machines (A and B). Each unit of X that is produced requires 50 minutes of processing time on machine A and 30 minutes of processing time on machine B. Each unit of Y that is produced requires 24 minutes of processing time on machine A and 33 minutes of processing time on machine B. At the start of the current week, there are 30 units of X and 90 units of Y in stock. Available processing time on machine A is forecast to be 40 hours and on the machine, B is forecast to be 35 hours. The demand for X in the current week is forecast to be 75 units and for Y is forecast to be 95 units. Company policy is to maximize the combined sum of the units of X and the units of Y in stock at the end of the week. Formulate the problem of deciding how much of each product to make in the current week as a linear program. Solve this linear program using excel.
Telefonika is a telecommunication company, located in the Accra Mall, selling mobile phones and accessories. Most of their new phones are ordered. But, Telefonika stocks three main phones for walk-in customers. Every week, they generate profit of GH¢600 from selling Galaxy S2, GH¢400 from Galaxy S3 and GH¢300 from Galaxy S4. The overall weekly cost of these types of phones are GH¢1,800, GH¢2,100 and GH¢1,200 respectively. This week, Telefonika has a budget of GH¢12,000 available to buy these three types of phones. During sales, each phone type must be unpacked, leading to 8 hours of unpacking time for S2 phones, 12 hours for S3 phones and 16 hours for S4 phones. The manager estimates that he and his workers have 120 labour hours available to unpack the three types of phones. Telefonika has enough space to order 20 phones this week. The manager also wants to stock at least twice as many S4 as S2 and S3 phones because S4 phones sell better.a) Formulate a linear programming model for this…
3.3 4.manufactures 37-in. high def LCD tvs in 2 separate locations, Locations I and II. The output at Location I is at most 6000 televisions/month, whereas the output at Location II is at most 5000 televisions/month. TMA is the main supplier of tvs to the Pulsar Corporation, its holding company, which has priority in having all its requirements met. In a certain month, Pulsar placed orders for 3000 and 4000 televisions to be shipped to two of its factories located in City A and City B, respectively. The shipping costs (in dollars) per television from the 2 TMA plants to the 2 Pulsar factories are as follows. To Pulsar Factories From TMA City A City B Location I $7 $3 Location II $8 $9 TMA will ship x televisions from Location I to city A and y televisions from Location I to city B. Find a shipping schedule that meets the requirements of both companies while keeping costs to a minimum. (x,y)= What is the minimum cost? 6.Solve the linear programming problem by…
A company has 4 production facilities. Each facility is eligible to produce Product A, Product B or Product C, but it can only produce one of these products. The annual fixed cost of operating each facility and the variable cost of producing a product of each type at each facility are given in the table. Facility Fixed Cost ($) Variable Cost ($) Product A Product B Product C Facility 1 8,000,000 1200 1600 900 Facility 2 6,000,000 1500 1800 1100 Facility 3 4,000,000 1700 1900 1200 Facility 4 3,000,000 1900 2200 1400 The company must produce 5000 units of each type of product in a year. Formulate an IP to minimize the total annual production cost satisfying the following constraints: Each facility can produce only one type of product. The total production of each type of product must be at a single facility. For instance, if any Products A are produced at facility 1, then all Products A must be produced there. If facilities 3 and 4 are used, then facility 1 must also be used.

SEE MORE QUESTIONS

Recommended textbooks for you

Linear Algebra: A Modern Introduction

Algebra

ISBN:

9781285463247

Author:

David Poole

Publisher:

Cengage Learning

Linear Algebra: A Modern Introduction

Algebra

ISBN:

9781285463247

Author:

David Poole

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS