Question: Question 1 Suppose we have data on 5 plants and 25 projects (20 of which are controlled by a plant). Answer the following questions

Question 1 Suppose we have data on 5 plants and 25 projects (20 of which are controlled by a plant). Answer

Question 1 Suppose we have data on 5 plants and 25 projects (20 of which are controlled by a plant). Answer the following questions in the context of the ER diagram and relations that appear in Figure 1. How many rows appear in the PLANT relation? 5 How many rows appear in the PROJECT relation? How many rows appear in the CONTROLS relation? How many rows in the CONTROLS relation have something in the Ctl_pl_p# column? How many rows in the CONTROLS relation have something in the Ctl prj_p# column? What is the primary key of the CONTROLS relation? Justify your choice. PLANT budget PROJECT C PLANT (Pl_name, Pl_p. Pl_budget) PROJECT (Prj_name, Prj_location, Prj_p#, Prj_status) CONTROLS (Ctl_pl_p#, Ctl_prj_p) Figure 1 Puts MANAGER

Step by Step Solution

★★★★★

3.40 Rating (159 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Solutions Step 1 1THere are 5 plants mentioned in the data so there are 5 rows in the plant relation ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!

Tax charge to profits $47 500 Company income tax liability for the year $56 000. Deferred tax liability at start of year $34 000 Deferred tax liability at end of year $28 000 Rasputin has always paid...

Consider the following directed graph, G, with vertices labelled 1 to 6. G = ({1,2,3,4,5,6}, {(1,2), (1,5), (3,1), (3,4), (4,5), (5,6), (6,3)}) a. Draw graph G and give its adjacency matrix...

Answer the following questions based on the information presented for Cloud 9 in Appendix B of this book and in the current and earlier chapters. You should also consider your answers to the case...

Assignment 1 Instructions Assignment 1 should be submitted after you have completed Unit 2. This assignment is worth 15 percent of your final grade. Assignment 1 contains five problems. The maximum...

The requirements are in world file. The pdf file includes the case. Only one-page write. Answer following questions and write one page (double space) What are the challenges of exiting private equity...

1 Suppose you want to buy a house that costs $700,000. You are required to put 10% down, which means the amount to be borrowed is 90% of the price of the house. If you want a 30 year mortgage, and...

I need this done in 3 hours. QUESTION 1 Suppose you want to buy a house that costs $700,000. You are required to put 10% down, which means the amount to be borrowed is 90% of the price of the house....

EFB106 COST AND BENEFIT ANALYSIS FOR PROJECT APPRAISAL Assessment Item 1: Sensitivity Analysis Online resource: http://www.cbabuilder.co.uk/ CBA Builder Excel Tool:...

Problem 5 (40 marks) SPY and XIU are ETFs tracking the S&P 500 and S&P/TSX 60 index, which are often used as proxies for the US and Canadian stock markets, respectively. From a set of their...

I have 40 Min left !!! QUESTION 1 Suppose you calculate the ordinary payback for a project, given the project cash flows and a required rate of return of 12%. After you calculate the ordinary...

Discuss the similarities and differences between theory of constraints and lean production.

A Custodial Fund is used to collect and distribute property taxes for several governmental entities. It has collected cash for the entities of $135,000 and has $270,000 in its Property taxes...

The business uses a hybrid business model to generate revenue by working with reputable organizations that pay fees for greater access to uncharted territory. At the same time, the corporation...

Find the implied volatility of the following European call. The call has four months until expiry and an exercise price of $100. The call is worth $6.51 and the underlying trades at $101.5, discount...

Chapter 30 examines an important algorithm called the fast Fourier transform, or FFT. The first step of the FFT algorithm performs a bit-reversal permutation on an input array A[0 . . n - 1] whose...

Suppose you have a sample of size n on three variables, y, x 1 , and x 2 , and you are primarily interested in the effect of x 1 on y. Let 1 be the coefficient on x 1 from the simple regression and ...

Select the Santa Fe Grill data or one of the other databases provided with this text (see Deli Depot, Remingtons, Qualkote, or Digital Recorder Survey on the website), analyze the data using the...

Refer to the EPA study of mercury poisoning in Maine lakes, Exercise 10.77. Lakes can be classified into three trophic states: Oligotrophic lakes have a balance between decaying vegetation and living...

at what rate will amber green report her U.S. Savings Bond Interest on her personal federal income tax return?

In this chapter, file servers were described as one way of providing information to users of a distributed information system. What file servers are available, and what are their relative strengths,...

Suppose you were responsible for establishing a training program for users of Hoosier Burgers inventory control system (described in previous chapters). Which forms of training would you use? Why?

In what way does the choice of a data type for a field help to control the integrity of that field?

Given the following information: Expected demand during a lead time = 300 units Standard deviation of demand during a lead time= 30 units Demand during a lead time is distributed Normally: a....

A manager just received a new price list for boxes from a supplier. It will now cost $ 1.00 a box for order quantities of SOI or more, $1.10 a box for 200 to 800, and $1.20 a box for smaller...

A jewellery manufacturer buys semi-precious stones to make bracelets and rings. The supplier has quoted a price of $8 per stone for order quantities of 600 stones or more, $9 per stone for orders of...