Answered step by step
Verified Expert Solution
Question
1 Approved 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
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
Step: 1
Solutions Step 1 1THere are 5 plants mentioned in the data so there are 5 rows in the plant relation ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started