When creating relationships between tables in our database, we must consider the following entity relationships.
• Nonidentifying relationships between strong entities
• Identifying relationships between ID-dependent entities
• Mixed entity patterns relationships
• Supertype and subtype relationships
• Recursive relationships
Create an example of entities in one of these relationships and describe how the entity pattern is transformed into database tables.