Convert Entity Relationship Diagram to Relation Schemas - Exercises

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

*************

Click here to go to DBMS solved exercises page