Suppose we have data on 25 projects and 15 managers (10 of whom are project managers...

Transcribed Image Text:

Suppose we have data on 25 projects and 15 managers (10 of whom are project managers and assign manage a project). Answer the following questions in the context of the ER diagram and relations that ap in Figure 2. • How many rows appear in the MANAGER relation? • How many rows appear in the RUNS relation? • What is the primary key of the RUNS relation? Justify your choice. Cranber PLANT Bulg BA Con 16.11 PLANT (PL name, Pl_p#, Pl_budget) PROJECT (Prj_name, Prj_location, Prj_p#, Prj_pl_p#) MANAGER (Mgr_emp_no, Mgr_type_mgr) RUNS (Run_prj_p#, Run_mgr_emp_no) Figure 2 PROJECT 10,1) Funs 10.11 MANAGER Type mo Suppose we have data on 25 projects and 15 managers (10 of whom are project managers and assign manage a project). Answer the following questions in the context of the ER diagram and relations that ap in Figure 2. • How many rows appear in the MANAGER relation? • How many rows appear in the RUNS relation? • What is the primary key of the RUNS relation? Justify your choice. Cranber PLANT Bulg BA Con 16.11 PLANT (PL name, Pl_p#, Pl_budget) PROJECT (Prj_name, Prj_location, Prj_p#, Prj_pl_p#) MANAGER (Mgr_emp_no, Mgr_type_mgr) RUNS (Run_prj_p#, Run_mgr_emp_no) Figure 2 PROJECT 10,1) Funs 10.11 MANAGER Type mo

Answer rating: 100% (QA)

Based on the provided image which seems to be an EntityRelationship ER diagram along with a description of relations in a database scenario lets addre... View the full answer