Advanced Database Management System - Tutorials and Notes: Convert Entity Relationship Diagram to Relation Schemas - Exercises

Search Engine

Please visit, subscribe and share 10 Minutes Lectures in Computer Science

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)
  • Exercise 13 - Reduction of ERD to relational database schema

Featured Content

Multiple choice questions in Natural Language Processing Home

MCQ in Natural Language Processing, Quiz questions with answers in NLP, Top interview questions in NLP with answers Multiple Choice Que...

All time most popular contents