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)
Based on the information provided in the question and the ER diagram in Figure L we can determine th... 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?
-
If there were a great migration of people toward the Earths equator, how would this affect the length of the day?
-
Elaborate the notion of "Orientalism' as discussed by Edward Said.
-
Consider the wine quality of young red wines data in Table B.19. Regressor $x_{1}$ is an indicator variable. Perform a thorough analysis of these data. What conclusions do you draw from this...
-
You were recently approached by one of your clients, Wendy Wonders, the Chief Financial Officer of Rock Group Limited ( RGL), a Canadian public company with a 31 December year- end. RGL manufactures...
-
Case: The rise of ad blockers has begun to make a dent in the advertising revenue earned by content creators and providers. Ad blockers identify and eliminate content based on its IP address,...
-
Several AI winters, or rapid collapses in levels of economic and academic activity (and media interest) associated with AI, have occurred. Describe the causes of each collapse and of the boom in...
-
What are some of the shared characteristics of indigenous people around the world? Discuss in relation to the politics of recognition. A good answer would use a specific case study. What are the main...
-
Two vertical springs have identical spring constants, but one has a ball of mass \(m\) hanging from it and the other has a ball of mass \(2 m\) hanging from it. If the energies of the two systems are...
-
Which of these forces could result in simple harmonic motion: (a) \(F(x)=2 x\), (b) \(F(x)=-2 x\), (c) \(F(x)=\) \(-2 x^{2},(d) F(x)=2 x^{2},(e) F(x)=-2 x+2,(f) F(x)=\) \(-2(x-2)^{2}\) ?
-
On December 31, Kohl Company correctly made an adjusting entry to recognize \($2,000\) of accrued salaries payable. On January 8 of the next year, total salaries of \($3,800\) were paid. Assuming the...
-
Even a spring without a block hanging on the end of it has an oscillation period. Why isn't the period zero?
-
Calculate the Lorentz factor for an object moving relative to Earth at (a) \(60 \mathrm{mi} / \mathrm{h}\), (b) \(0.34 \mathrm{~km} / \mathrm{s}\) (speed of sound in air), (c) \(28 \times 10^{3}...
-
What is the proposed Net Operating Income? $5,210,000 $4,878,500 $6,538,500 $6,630,000 What is the Total Cost To Achieve Developer Return $65,205,000 $32,365,000 $97,570,000 $1,660,000 What is the...
-
Information graphics, also called infographics, are wildly popular, especially in online environments. Why do you think infographics continue to receive so much attention? How could infographics be...
-
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?
-
Laura says she doesnt believe that humans were at one time chimpanzees or gorillas. Jeff says he doesnt believe it either. Explain why biologists also dont believe that humans are descended from...
-
Write a letter to Grandma telling her about drug resistance in living organisms. Explain to her why drug resistance is such a common phenomenonincluding why insects become more resistant to...
-
During a drought, the supply of seeds available to a finch population decreases. The smaller, softer seeds, which are easier to crack, are quickly eaten up. Finches with larger, stronger beaks are...
Study smarter with the SolutionInn App