← Go home

Constraints of E-R Modeling

September 17, 2016
Published By : Pratik Kataria
Categorised in: Database Management System

An E-R enterprise schema may define certain constraints to which the contents of a database system must conform.

1. Mapping Cardinalities
   1. One to one
   2. One to many
   3. Many to one
   4. Many to many
2. Participation Constraints
   1. Total participation: If every entity in E participation is at least one relationship in R.
   2. Partial participation: If only some entities in E participate in relationships in R.

Pratik Kataria

Pratik Kataria is currently learning Springboot and Hibernate.
Technologies known and worked on: C/C++, Java, Python, JavaScript, HTML, CSS, WordPress, Angular, Ionic, MongoDB, SQL and Android.
Softwares known and worked on: Adobe Photoshop, Adobe Illustrator and Adobe After Effects.

pratikkataria.com/