Solved Exercises - Reducing Entity Relationship Diagram into Tables, Convert ER diagram to tables, relational schemas, ER model to relational model, reduce one-to-one, one-to-many, many-to-many relationships into tables, simple, composite, and multivalued attribute to tables
Entity Relationship Data Model / Entity Relationship Diagram
- Exercise 1 – One to One relationship with Simple attributes
- Exercise 2 – One to Many relationship with Simple attributes
- Exercise 3 – Many to One relationship with Simple attributes
- Exercise 4 – Many to Many relationship with Simple attributes
- Exercise 5 – Many to Many relationship with Simple, Composite, and Multi-valued attributes
- Exercise 6 - 1-to-M, and N-to-M relationship with Simple, Composite, Multi-valued and Descriptive attributes
- Exercise 7 - 1-to-M, and N-to-M relationship with Simple, Composite, Multi-valued and Descriptive attributes and Weak Entity set.
- Exercise 8 - reduce ER to relational tables.
- Exercise 9 - convert ERD to relation schema (Descriptive attributes included)
- Exercise 10 - convert ERD to relation schema (Specialization components included)
- Exercise 11 - Draw an ER diagram for the given scenario
- Exercise 12 - Reduce ER to relation schemas (How to handle multiple relationships between two entity sets? Solved)
- Exercise 13 - Reduction of ERD to relational database schema