Home / Expert Answers / Computer Science / 70-points-a-company-database-contains-information-about-tech-leads-identified-by-tid-and-projec-pa487

(Solved): [70 Points] A company database contains information about Tech. leads (identified by tid) and Projec ...



[70 Points] A company database contains information about Tech. leads (identified by tid) and Projects (identified by pno). Tech. leads manage projects. You are given some situations concerning the manage relationship set. For each situation, draw an ER diagram for it using the notation taught in our class (assuming no further constrains hold). a. [10 points] Tech. leads can manage the same project in different calendar years, and each year must be recorded. b. [10 points] Tech. leads can manage the same project in several calendar years, and only the current year needs to be recorded. c. [10 points] Every tech. lead must manage some project. d. [10 points] Every project is managed by exactly one tech. lead. e. [10 points] Every tech. lead manages exactly one project, and every project must be managed by at least one tech. lead. f. [20 points] Suppose some projects can be jointly managed by a team of tech. leads. Model this situation by introducing additional entity sets and relationship sets as needed. (Here, we assume that only the latest calendar year of a project needs to be recorded; and a leading team may consist of one or multiple tech. leads, i.e., a tech. lead may be treated as a team of one tech. lead.)

student submitted image, transcription available below


We have an Answer from Expert

View Expert Answer

Expert Answer


We have an Answer from Expert

Buy This Answer $5

Place Order

We Provide Services Across The Globe