Question: Question 2 15 points This question tests how well you understand the process for converting E/R diagrams to relational schemas. An E/R diagram when converted

Question 2 15 points This question tests how well you understand the process for converting E/R diagrams to relational schemas. An E/R diagram when converted to relations (using the mechanical construction that we know and love) gives rise to the following relations: S (a, d) U ( g) R(a, b, c) T (a, d, e, f) You may assume that the same symbols refer to the same attribute and different symbols refer to different attributes (e.g., the attributes a in the relations R, S, and T are the same). Your task is to reverse-engineer the E/R diagram from these relations; in other words, what E/R diagram could have produced these relations? (10 points) For full credit, give two different E/R diagrams that could have produced these relations (5 points)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
