RelationshipA relationship is represented by diamond shape in ER diagram, it shows the relationship among entities. There are four types of relationships: 1. One to One 2. One to Many 3. Many to One 4. Many to Many 1. One to One RelationshipWhen a single instance of an entity is associated with a single instance of another entity then it is called one to one relationship. For example, a person has only one passport and a passport is given to one person.2. One to Many RelationshipWhen a single instance of an entity is associated with more than one instances of another entity then it is called one to many relationship. For example – a customer can place many orders but a order cannot be placed by many customers.3. Many to One RelationshipWhen more than one instances of an entity is associated with a single instance of another entity then it is called many to one relationship. For example – many students can study in a single college but a student cannot study in many colleges at the same time.4. Many to Many RelationshipWhen more than one instances of an entity is associated with more than one instances of another entity then it is called many to many relationship. For example, a can be assigned to many projects and a project can be assigned to many students. - Study24x7
Social learning Network

Warning: include(./views/auth.php): failed to open stream: Permission denied in /var/www/html/live/loginRightSlider.php on line 18

Warning: include(): Failed opening './views/auth.php' for inclusion (include_path='.:/usr/share/php') in /var/www/html/live/loginRightSlider.php on line 18
DBMS
56 followers study24x7 01 Jan 1970 05:30 AM study24x7 study24x7

RelationshipA relationship is represented by diamond shape in ER diagram, it shows the relationship among entities. There are four types of relationships:
1. One to One
2. One to Many
3. Many to One
4. Many to Many 1. One to One RelationshipWhen a sing...

See more

Databases
Like | 1 Comment Share
study24x7
Write a comment
Related Questions
500+   more Questions to answer

Popular Courses

Database Design All Levels English By Dr S Srinath
Free SEO training: SEO for beginner... Beginners Level English By Digital Marketing - Learn SEO, PPC,...
English Beginners Level English By Study Anywhere
H.C. Verma Solution All Levels English By HC Verma FanClub
SSC CGL, CPO, CHSL, GD Comprehensiv... All Levels English By Topline Coaching 3,999 5,499 27% off
English Special Course for SSC CGL,... All Levels English By Topline Coaching 999 1,499 33% off
Online Free SSC Mock Tests All Levels English By Topline Coaching
FREE MOCK TEST FOR SSC CGL All Levels English By SSC Preparation Strategies & Study ...
G.S. Foundation Premium Course All Levels हिन्दी By RAU IAS COACHING 2,199 4,199 48% off
Featured Courses
Popular Pages

Featured Courses

Database Design All Levels English By Dr S Srinath
FREE
5.0
Free SEO training: SEO for beginners Beginners Level English By Digital Marketing - Learn SEO, PPC, SMO, SEM, Cont...
FREE
5.0
Free SEO Link Building Guide 2019 All Levels English By Digital Marketing - Learn SEO, PPC, SMO, SEM, Cont...
FREE
4.5
BESTSELLER
SSC CGL, CPO, CHSL, GD Comprehensive Course All Levels English By Topline Coaching 3,999 5.0
A Premium Course For English Special (All One Day ... All Levels English By Vivishka Learning and Test Series 999 5.0
G.S. Foundation Premium Course All Levels हिन्दी By RAU IAS COACHING 2,199 5.0
English Special Course for SSC CGL, CPO, GD All Levels English By Topline Coaching 999 5.0
Online Free SSC Mock Tests All Levels English By Topline Coaching
FREE
4.5
Math Special Course for SSC CGL, CPO, GD All Levels हिन्दी By Topline Coaching 999 5.0

Popular Pages

SAT (Scholastic Assessment Test)

18 followers

Study24x7

1252 followers

Henry Harvin

71 followers

CBSE Study Materials

104 followers

Digital Marketing - Learn SEO, PPC, SMO,...

762 followers

Defence

106 followers

UPSC & State PSC

1012 followers

SSC Preparation Strategies & Study Mater...

1552 followers

Banking/IRDA

265 followers

DEFENCE EXAM PREPARATION

22 followers

Get the App

Download the Study24x7 App, so you can connect and collaborate.

study24x7
study24x7
Most Related Articles