##Please use two ways to represent, and conclude which one isbetter!
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 aretwo ways we can represent this relationship whenimplementing this database/tables using SQL?
Please Use Two Ways To Represent And Conclude Which One Is Better One Of The Essential Elements Of An Er Diagram Is 1 (42.26 KiB) Viewed 31 times
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 aparagraph explaining if one of the chosen methods to implement thisrelationship is better than the other.
SIN name Employee room Works In dID dName Department dBudget
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!