Question: Suppose we have data on 25 projects and 15 managers (10 of whom are project managers and assign manage a project). Answer the following

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

Step by Step Solution

★★★★★

3.54 Rating (151 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

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 full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!

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...

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...

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...

At one time the Thames River in England supported an abundant community of fish. Pollution then destroyed all the fish in a 40-mile stretch near its mouth for a 45-year period beginning in 1915....

Identify the following intermediate in the citric acid cycle, and tell whether it has R or Sstereochemistry:

2. Describe the starting points of external sustainability marketing transformations by companies.

=+What can you conclude?

Dudley Savings Bank wishes to take a position in Treasury bond futures contracts, which currently have a quote of 105-100. Dudley Savings thinks interest rates will go down over the period of...

18 19 20 Question Completion Status: 17 15 16 14 13 12 10 11 9 8 7 2 4 3 1 25 5 6 30 31 32 33 34 35 37 36 22 22 Question 18 le 1480,000, viable costs are 62% of sales, and income is $172,000, what is...

You are on the Sports Day planning group and have been allocated the role as parent liaison. This involves providing parents with all information they need to know about the sports day and providing...

Required information [The following information applies to the questions displayed below] Carlberg Company has two manufacturing departments, assembly and painting. The assembly department started...

The Covid-19 pandemic has forced many countries to partially shutdown their economies to prevent the spread of the virus. In response, many governments including Barbados have embarked on...

Total cash available $64.000 Less cash disbursements For inventory $47,850 For expenses 13,300 For equipment 1,500 Total cash disbursements 62,650 Excess (deficiency) of cash $1,350 Financing: Etc....

Review the annual reports of PepsiCo and Amazon, two of the largest publicly traded firms in America. Compute and compare the accounts receivable turnover ratios and the average collection period in...

a) Explain how changes in the film industry led to blockbuster movies becoming more limited creatively and oriented to making money [worth 5 marks] b) Then explain how changes in industry practices...

Nike not renewing franchise agreements in Russia Reporting by Reuters; Editing by Simon Cameron-Moore and Tomasz Janowski 25 May 2022, Reuters U.S. sportswear maker Nike has not renewed agreements...

Why is the amortization for year 2015 and 2016 $12000? Fields Laboratories holds a valuable patent (No. 758-6002-1A) on a precipitator that prevents certain types of air pollution. Fields does not...

7. FALSE DILEMMA 8. GANDWAGON Definition: Fallacy example: How to revise argument: Definition: Fallacy example: How to revise argument:

Draw an activity diagram for the following case. Maximum Software develops and supplies software products to individuals and businesses. As part of its operations, Maximum provides a 1-800 telephone...

In what ways is a request to change an information system handled differently from a request for a new information system?

In a real estate database, there is an entity called PROPERTY, which is a property for sale by the agency. Each time a potential property buyer makes a purchase offer on a property, the agency...

One of the fust Internet-based groceries home delivery businesses was Homegrocer.com. In 1998, Mike Donald, president of Concord Sales, one of the largest food brokers in B.C., and two partners...

Go to the Web site of Airbus A38G, the biggest passenger plane ever built (525 passengers or more on 2 floors, with a range of 15,000 km, and a wingspan of 80 metres), http://www.airbus....

The fixed cost of running a gift store (wages, rent, etc.) in a particular mall is $250,000 per year. The gross margin (i.e., sales - cost of goods sold or alternatively revenue - variable cost) is...