Answered step by step
Verified Expert Solution
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
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 notStep by Step Solution
There are 3 Steps involved in it
Step: 1
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