Design of an E-R Database Scheme

Posted By on October 3, 2014


Download PDF
Use of Extended E-R Features
Relational Algebra Queries

Design of an E-R Database Scheme

The E-R data model provides a wide range of choice in designing a database scheme to accurately model some real-world situation.

Some of the decisions to be made are

  • Using a ternary relationship versus two binary relationships.
  • Whether an entity set or a relationship set best fit a real-world concept.
  • Whether to use an attribute or an entity set.
  • Use of a strong or weak entity set.
  • Appropriateness of generalization.
  • Appropriateness of aggregation.

 

 

 

 

 

 
Mapping Cardinalities
Use of Entity or realationship sets
Use of extended ER features

Use of Extended E-R Features
Relational Algebra Queries

Download PDF

Posted by Akash Kurup

Founder and C.E.O, World4Engineers Educationist and Entrepreneur by passion. Orator and blogger by hobby

Website: http://world4engineers.com