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?
-
At the beginning of his current tax year, Eric bought a corporate bond with a maturity value of $50,000 from the secondary market for $45,000. The bond has a stated annual interest rate of 5 percent...
-
Explain for what kind of frequency distribution an ogive is drawn. Can you think of any use for an ogive? Explain.
-
distinguish among different types of groups,
-
Using the earnings data developed in E3-1 and assuming that this was the first week of employment for R. Herbert with Crestview Manufacturing Co., prepare the journal entries for the following: a....
-
Schedule of cash payments for a service company EastGate Physical Therapy Inc. is planning its cash payments for operations for the first quarter ( January - March ) . The Accrued Expenses Payable...
-
Determine the force in members GF, CF, and CD of the roof truss and indicate if the members are in tension or compression. 1.5 kN 1.70 m 2 kN 1.5 m 0,8 m G. -1 m- 2 m 2 m
-
Chapter 18 Exercises and Problems 5 6.81 points Saved Help Save & Exit Submit 3 Check my work In 2024, Western Transport Company entered into the treasury stock transactions described below. In 2022,...
-
ABC corporation employees 300 workers as a team. When production of the team exceeds the standard production of 1000 pieces per hour. Each employee in the team is paid a bonus for the excess...
-
From the year ending December 31, 2022 Income Statement: Revenue: $16,400 Cost of Goods Sold: $2,800 Depreciation Expense: $900 Wages Expense: $1,775 Net Income: $6,000 From the Balance Sheets, the...
-
Discuss your understanding of the comparability problems in the valuation of financial assets.
-
(12 points) A minivan moving at 38 m/s passes an unmarked state police car moving at 24 m/s. The electromagnetic waves produced by the radar gun in the police car have a frequency of 8.25 109 Hz....
-
The town of Suffolk has put a bid for delivery of 1,000 gust proof tents per year for five years. Company M would like to compete for the bid. They estimate the cost of equipment to manufacture the...
-
Tellys Ts makes white T-shirts in lots of 12 that they sell for $12 per lot. This month they plan to make and sell 500 lots and have the following standards: DM: 12 meters per lot @ $1.50 per meter...
-
You purchase a bond with a coupon rate of 6.7 percent, a par value $1,000, and a clean price of $905. Assume a par value of $1,000. If the next semiannual coupon payment is due in two months, what is...
-
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?
-
What two factors encourage the diffusion of an innovation? Why? What can be done to encourage these two factors?
-
Examine two of the innovation centers listed in the chapter. How are they similar? Different? Do they focus on any different aspects of healthcare innovation?
-
The creation and operation of a single-organ-focused hospital is what form of healthcare innovation?
Study smarter with the SolutionInn App