Categories
5G Network
Agile
Amazon EC2
Android
Angular
Ansible
Arduino
Artificial Intelligence
Augmented Reality
AWS
Azure
Big Data
Blockchain
BootStrap
Cache Teachniques
Cassandra
Commercial Insurance
C#
C++
Cloud
CD
CI
Cyber Security
Data Handling
Data using R
Data Science
DBMS
Design-Pattern
DevOps
ECMAScript
Fortify
Ethical Hacking
Framework
GIT
GIT Slack
Gradle
Hadoop
HBase
HDFS
Hibernate
Hive
HTML
Image Processing
IOT
JavaScript
Java
Jenkins
Jira
JUnit
Kibana
Linux
Machine Learning
MangoDB
MVC
NGINX
Onsen UI
Oracle
PHP
Python
QTP
R Language
Regression Analysis
React JS
Robotic
Salesforce
SAP
Selenium
Service Discovery
Service Now
SOAP UI
Spark SQL
Testing
TOGAF
Research Method
Virtual Reality
Vue.js
Home
Recent Q&A
Feedback
Ask a Question
DBMS Mapping Constraints
Home
>
DBMS
>
DBMS Mapping Constraints
Oct 27, 2019
in
DBMS
Q: What is Mapping Constraints
dbms-mapping-constraints
mapping-constraints
1
Answer
0
votes
Oct 27, 2019
A mapping constraint is a data constraint that expresses the number of entities to which another entity can be related via a relationship set.
It is most useful in describing the relationship sets that involve more than two entity sets.
For binary relationship set R on an entity set A and B, there are four possible mapping cardinalities. These are as follows:
One to one (1:1)
One to many (1:M)
Many to one (M:1)
Many to many (M:M)
One-to-one
In one-to-one mapping, an entity in E1 is associated with at most one entity in E2, and an entity in E2 is associated with at most one entity in E1.
DBMS Mapping Constraints
One-to-many
In one-to-many mapping, an entity in E1 is associated with any number of entities in E2, and an entity in E2 is associated with at most one entity in E1.
DBMS Mapping Constraints
Many-to-one
In one-to-many mapping, an entity in E1 is associated with at most one entity in E2, and an entity in E2 is associated with any number of entities in E1.
DBMS Mapping Constraints
Many-to-many
In many-to-many mapping, an entity in E1 is associated with any number of entities in E2, and an entity in E2 is associated with any number of entities in E1.
DBMS Mapping Constraints
Click here to read more about Loan/Mortgage
Click here to read more about Insurance
Facebook
Twitter
LinkedIn
Related questions
0
votes
Q: What is DBMS?
Dec 13, 2020
in
DBMS
#what-is-dbms
#dbms
0
votes
Q: What do you mean by durability in DBMS?
May 15, 2020
in
DBMS
0
votes
Q: What is data abstraction in DBMS?
May 15, 2020
in
DBMS
0
votes
Q: What do you mean by transparent DBMS?
May 15, 2020
in
DBMS
0
votes
Q: When does checkpoint occur in DBMS?
May 15, 2020
in
DBMS
0
votes
Q: What is a checkpoint in DBMS?
May 15, 2020
in
DBMS
...