Create abbreviated ERDs with 2 or 3 attributes using lucidchard or something similar to this.
Define the following term in your own words:
composite (bridge) entity
An employee works on many projects
Each project is assigned many employees
A fish species can be found in many lakes
Each lake has many fish species
An actor appears in many films
Each film has many actors
A recipe contains many ingredients
An ingredient appears in many recipes
Answer :
Composite Entity:
1. It is also known as "Bridge entity". 2. It is used to handle many-to-many relationships. 3. This entity lies between the two entities that are of interest and this composite entity shares the primary keys from both the connecting tables. 4. This composite entity is also known as a “gerund” because it has the characteristics of an entity and a relationship.
Create abbreviated ERDs with 2 or 3 attributes using lucidchard or something similar to this. Define the following t...
Resolving M:N Relationships: For parts b- e, create abbreviated ERDs with 2 or 3 attributes using lucidcharts or something similar to this. An employee works on many projects Each project is assigned many employees A fish species can be found in many lakes Each lake has many fish species An actor appears in many films Each film has many actors d. A recipe contains many ingredients An ingredient appears in many recipes