Saturday, 30 April 2016

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 4Many to Many relationship with Simple attributes
  • Exercise 5Many 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 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)

SQL exercises for beginners one

SQL Exercises for Beginners / Simple SQL Exercises with Answers / Solved SQL exercises / SQL solved exercises with simple conditions / So...