Practical Management Science
6th Edition
ISBN: 9781337406659
Author: WINSTON, Wayne L.
Publisher: Cengage,
expand_more
expand_more
format_list_bulleted
Related questions
Question
able 4-4 on page 197 shows a relation called GRADE REPORT for a university. Your assignment is as follows:
- Draw a relational schema and diagram the functional dependencies in the relation.
- In what normal form is this relation?
- Decompose GRADE REPORT into a set of 3NF relations.
- Draw a relational schema for your 3NF relations and show the referential integrity constraints (as shown in Figure 4-5 on page 163).
- Draw an ER-diagram for your answer to part d above.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution
Trending nowThis is a popular solution!
Step by stepSolved in 2 steps
Knowledge Booster
Similar questions
- Item5 Time Remaining 2 hours 52 minutes 12 seconds 02:52:12 eBookReferences Item 5 Time Remaining 2 hours 52 minutes 12 seconds 02:52:12 The production planner for Fine Coffees, Inc. produces two coffee blends: American (A) and British (B). He can only get 300 pounds of Colombian beans per week and 200 pounds of Dominican beans per week. Each pound of American blend coffee requires 12 ounces of Colombian beans and 4 ounces of Dominican beans, while a pound of British blend coffee uses 8 ounces of each type of bean. Profits for the American blend are $2.00 per pound, and profits for the British blend are $1.00 per pound. The goal of Fine Coffees, Inc. is to maximize profits.What is the constraint for Dominican beans? Multiple Choice 12A + 8B ≤ 4,800. 8A + 4B ≤ 3,200. 8A + 12B ≤ 4,800. 4A + 8B ≤ 3,200. 4A + 8B ≤ 4,800.arrow_forwardProblem 15-12 Calculating Current Yields [LO15-5] Calculate the interest amount and current yield for the following $1,000 bonds: Note: Round your interest amount answers to 2 decimal places. Enter the current yield answers as a percent rounded to 2 decimal places. Interest Current Interest Rate Amount Market Value 4.50% $ SA 1,060 4.10% $ 940 3.40% $ 1,070arrow_forwardFormulate the situation in matrix form. Be sure to indicate the meaning of your rows and columns. Find the requested quantities using the appropriate matrix arithmetic. A car dealer sells sedans, station wagons, vans, and pickup trucks at sales lots in Oakdale and Roanoke. The "dealer markup" is the difference between the sticker price and the dealer invoice price. The dealer invoice prices at both locations are the same: $15,000 per sedan, $19,000 per wagon, $24,000 per van, and $26,000 per pickup. The sticker prices at the Oakdale lot are $18,900 per sedan, $23,900 per wagon, $28,900 per van, and $28,900 per pickup, while at the Roanoke lot the sticker prices are $17,900 per sedan, $22,900 per wagon, $26,900 per van, and $30,900 per pickup. Represent these prices as a dealer invoice matrix D and a sticker price matrix S. Use these matrices to find the dealer markup matrix M for these vehicles at these sales lots. (Let row 1 represent the dealer in Oakdale and row 2 represent the…arrow_forward
- Management realized that the optimal product mix, taking setup costs into account, might be different from the one recommended in part (b). Formulate a mixed-integer linear program that takes setup costs provided in part (c) into account. Management also stated that we should not consider making more than 175 units of product 1, 150 units of product 2, or 140 units of product 3. What are the new objective function and additional equation constraints? If the constant is "1" it must be entered in the box. Let Yi is one if any quantity of product i is produced and zero otherwise. Max $ P1 + $ P2 + $ P3 - $ Y1 - $ Y2 - $ Y3 s.t. P1 Y1 P2 Y2 P3 Y3 P1, P2, P3 ≥ 0 (e) Solve the mixed-integer linear program formulated in part (d). How much of each product should be produced and what is the projected total profit contribution? Compare this profit contribution to…arrow_forward23. The theory of loss aversion and reference dependence implies that (a) equilibrium allocations will usually be outside the Pareto set (b) the location of the Pareto set may depend on the initial allocation (c) the Pareto set is piecewise linear (d) the Pareto set is reduced to a single point in the Edgeworth box (e) the Pareto set lies on two adjacent sides of the Edgeworth boxarrow_forward33 White & Becker Tools (W&B) requires 2,000 elec- tric motors next month for its product line of weed trimmers. Each motor is composed of three com- ponents: a coil, a shaft, and housing. W&B has the capability to produce these components or purchase them from an outside vendor. The costs of produc- ing them and purchasing them are shown in the following table. COMPONENT Coil Shaft Housing DEPART- MENT PRODUCTION COST PER UNIT Fabrication 0.5 Molding 0.4 Inspection 0.2 $2.60 $1.80 $1.40 The components that are produced by W&B must pass through three departments: fabrication, molding, and inspection. The number of hours each component requires in each department and the total number of hours available next month in each department are shown in the following table: 0.2 0.7 0.3 PURCHASE COST PER UNIT COIL SHAFT HOUSING AVAILABILITY (HR.) (HR.) (HR.) (HR.) $3.12 $2.16 $1.68 0.6 0.3 0.4 3,000 3,000 1,800 In order to determine the number of components that will be produced and the number…arrow_forward
- The following sentence contains a parallelism error; please choose the one revision that corrects this error. Many states are reducing property taxes for homeowners and extend financial aid in the form of tax credits for renters. O Many states are reducing property taxes for homeowners and extending financial aid in the form of tax credits for renters. O Many states are reducing property taxes for homeowners; and extend financial aid in the form of tax credits for renters. Many states are reducing property taxes for homeowners, and they are also going to extend financial aid in the form of tax credits for renters. Many states are reducing property taxes for homeowners, and extend financial aid in the form of tax credits for renters.arrow_forwardExplain the term “Constrained Optimization” as Thaler used in the first chapter of Misbehaving.arrow_forwardPLEASE USE SIMPLEX METHOD. Thank you! Suppose a company manufactures different electronic components for computers. Component A requires 2 hours of fabrication and an hour of assembly. Component B requires 3 hours of fabrication and an hour of assembly, and component C requires 2 hours of fabrication and 2 hours of assembly. The company has upto 1,000 labor-hours for fabrication, 800 labor-hours of assembly time each work. If the profit on each component A, B, and C is $7, $8, and $10 respectively, how many of each should be produced to maximize profit?arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Operations ManagementOperations ManagementISBN:9781259667473Author:William J StevensonPublisher:McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi...Operations ManagementISBN:9781259666100Author:F. Robert Jacobs, Richard B ChasePublisher:McGraw-Hill Education 
Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage Learning
Production and Operations Analysis, Seventh Editi...Operations ManagementISBN:9781478623069Author:Steven Nahmias, Tava Lennon OlsenPublisher:Waveland Press, Inc.
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Operations Management
Operations Management
ISBN:9781259667473
Author:William J Stevenson
Publisher:McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi...
Operations Management
ISBN:9781259666100
Author:F. Robert Jacobs, Richard B Chase
Publisher:McGraw-Hill Education
Purchasing and Supply Chain Management
Operations Management
ISBN:9781285869681
Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:Cengage Learning
Production and Operations Analysis, Seventh Editi...
Operations Management
ISBN:9781478623069
Author:Steven Nahmias, Tava Lennon Olsen
Publisher:Waveland Press, Inc.