Question 1 Suppose we have data on 5 plants and 25 projects (20 of which are...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 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
Expert Answer:
Answer rating: 100% (QA)
Solutions Step 1 1THere are 5 plants mentioned in the data so there are 5 rows in the plant relation ... View the full answer
Related Book For
Modern Systems Analysis And Design
ISBN: 9780134204925
8th Edition
Authors: Joseph Valacich, Joey George
Posted Date:
Students also viewed these 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...
-
Do you think firms rely too much on internal funds? Would it be better if they had to go back to shareholders when they needed cash?
-
A 2 000-kg car moving at 20.0 m/s collides and locks together with a 1 500-kg car at rest at a stop sign. Show that momentum is conserved in a reference frame moving at 10.0 m/s in the direction of...
-
The absorption maximum for the complex ion [Co(NH3)6]3+ occurs at 470 nm. (a) Predict the color of the complex and (b) calculate the crystal field splitting in kJ/mol.
-
Use random numbers to simulate rolling a six-sided die 60 times. How many times did you obtain each number from 1 to 6? Are the results what you expected?
-
Tim Snyder and Jay Wise have decided to form a partnership. They have agreed that Snyder is to invest $30,000 and that Wise is to invest $40,000. Snyder is to devote full time to the business, and...
-
Please watch the Google Talk on Valuation featuring Aswath Damodoran, Professor of Finance at NYU. What are two things that surprised you about Aswath's presentation. Was there anything learned that...
-
For this exercise, your client, Bright IDEAS Inc., has provided you with a listing of sales invoices. To test whether the client appears to have a receivables collectability problem, the auditor must...
-
Assignment Overview - Write a four hundred word essay that analyzes the macroeconomic impact of the September 11th terrorist attack on the US economy and the policy responses by Congress and the...
-
To succeed in international trade, it is crucial to know what to sell and how to sell a product or service. For example, a company that specializes in pork-based products would likely not find a...
-
Suppose that the two bones found belonging to the male in questions 13b and 13c were his ulna, which is 21 cm long, as well as his humerus, which is 30 cm. Calculate his height using both the ulna...
-
How do ecological disturbances, such as wildfires, invasive species invasions, and disease outbreaks, interact with ecosystem structure and function, and what are the implications for ecosystem...
-
The following is the trial balance of Cornwall Distributers Limited as at the 31 December 2019 Trial Balance as at 31 December 2019 300 000 $1 Ordinary shares 200 000 8% $1 Preference shares Share...
-
Assume that your parents wanted to have $140,000 saved for college by your 18th birthday and they started saving on your first birthday. They saved the same amount each year on your birthday and...
-
graph the system of constraints and find the value of X and Y that maximize the objective function. please show all work needed to complete Constraints x20 y20 y=x+2 5 5y+x Objective Function: C = 7x...
-
Provide a few individual examples who revealed what aspects of emotional intelligence?
-
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?
-
Referring to Example 3, the nanopillar data on height (nm) and width ( \(\mathrm{nm})\) are (a) Fit a straight line with \(y=\) height and \(x=\) width by least squares. (b) Test, with...
-
List and briefly explain the advantages that may accrue to companies as a consequence of conducting internal environmental audits and publishing independently verified environmental (or...
-
Outline the usual contents of: (i) an internal environmental audit report to management; (ii) a verification (or assurance) report attached to a company's published environmental report.
Study smarter with the SolutionInn App