Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

It is Entity relation diagram. I want answers for the questions posted. 1. Study the partial (incomplete) E-R diagram shown below (assume all entities have

image text in transcribed

It is Entity relation diagram. I want answers for the questions posted.

1. Study the partial (incomplete) E-R diagram shown below (assume all entities have ID attributes) PROUECE ngades hdlades 5431 CITY Based on this E-R diagram, answer the following questions and, in each case give reasons or an appropriate example in support of your answer: How many CITYS can a TASK be done in? a. b. Could TASK be modelled as a ternary relationship between TOOL, PROJECT and CITY? Why, or why not? explain why not. Should the Skill attribute be instead modelled on a relationship between EMPLOYEE and c Is it possible to attach attributes to the Used_on" relationship? If yes, give an example; if no, d. TASK? Why. or why not? e. For a project that a particular employee is working on, is it possible to identify which tool the employee is using for a task? Why. ar why not? f. Is it possible to tell which cityls) a particular project is being done at? Why. ar why not

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Database Relational Model A Retrospective Review And Analysis

Authors: C. J. Date

1st Edition

0201612941, 978-0201612943

More Books

Students also viewed these Databases questions

Question

=+d) What concerns do you have?

Answered: 1 week ago