One of the essential elements of an ER diagram is the relationship between entities. In the example ER diagram below, th
Posted: Sun Jul 10, 2022 11:26 am
One of the essential elements of an ER diagram is therelationship between entities. In the example ER diagram below, the“Works In” relationship when mapped to an SQL implementation can berepresented in different ways within our SQL code. What are twoways we can represent this relationship when implementing thisdatabase/tables using SQL?
You can use create table SQL queries followed by shortexplanations for the two possible ways to represent thisrelationship that you think of. At the very end include a paragraphexplaining if one of the chosen methods to implement thisrelationship is better than the other.
SIN name Employee room Works In dID dName Department dBudget
You can use create table SQL queries followed by shortexplanations for the two possible ways to represent thisrelationship that you think of. At the very end include a paragraphexplaining if one of the chosen methods to implement thisrelationship is better than the other.
SIN name Employee room Works In dID dName Department dBudget