Consider the following E-R Diagram: Site manages Staff works in has employs Branch Figure A The attributes of each entity are as follows: Staff Entity's attributes are Staff No, Fname, Lname and...


Consider the following E-R Diagram:<br>Site<br>manages<br>Staff<br>works in<br>has<br>employs<br>Branch<br>Figure A<br>The attributes of each entity are as follows:<br>Staff Entity's attributes are Staff No, Fname, Lname and Extension No.<br>Branch Entity's attributes are Name, Address, Telephone No.<br>Site Entity's attributes are Site No, Address and Capacity.<br>a) Eliminate each redundant relationship from the E-R Diagram above (Figure A) and<br>justify your answer. (Maximum 200 words).<br>

Extracted text: Consider the following E-R Diagram: Site manages Staff works in has employs Branch Figure A The attributes of each entity are as follows: Staff Entity's attributes are Staff No, Fname, Lname and Extension No. Branch Entity's attributes are Name, Address, Telephone No. Site Entity's attributes are Site No, Address and Capacity. a) Eliminate each redundant relationship from the E-R Diagram above (Figure A) and justify your answer. (Maximum 200 words).

Jun 05, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions ยป

Submit New Assignment

Copy and Paste Your Assignment Here