Illustrate the cardinality of relationship, Database Management System

Cardinality of Relationship

One-to-One

Only one entity of the first set is linked to only one entity of the second set. E.g. A teacher teaches a student. Only one teacher is teaching only one learner.

One-to-Many

Only one entity of the first set is related to many entities of the second set. E.g. A teacher teaches learners.

Many-to-One

Multiple entities of the first set are related to many entities of the second set. E.g. Teachers teach a learner.

Many-to-Many

Multiple entities of the first set are related to multiple entities of the second set. E.g. Teachers teach learners

 

Posted Date: 7/26/2013 5:57:55 AM | Location : United States







Related Discussions:- Illustrate the cardinality of relationship, Assignment Help, Ask Question on Illustrate the cardinality of relationship, Get Answer, Expert's Help, Illustrate the cardinality of relationship Discussions

Write discussion on Illustrate the cardinality of relationship
Your posts are moderated
Related Questions
Explain the disadvantages of file oriented approach? In the oriented approach Applications are designed in isolation. Design of application is optimized for one application. In

Complexity : A distributed DBMS that is available, reliable, and secure is inherently more difficult than a centralised DBMS. Though, adequate data replication is essential to have

What are metrics for choosing the best algorithm? Matrices for choosing the best algorithms are as below: Computational complexity Ease of understand ability and im

Have a look around the site, and at some of the sites they have featured. These are all examples of bad design, and also offer an explanation about why they fall into this category

What is Interaction Diagram An interaction diagram shows an interaction, comprises of a set of objects and their relationships including the messages that may be dispatched be

Increased overheads on update : On the drawbacks side, it will need the system to ensure that all replicas of a relation are consistent. This shows that all the replicas of the rel

What is Disadvantages Of DBMS ? 1. Cost of Software and Hardware and Migration - A important disadvantage of the DBMS system is cost. 2. Reduced Response and Throughpu

File Organisation And Its Types  Just as arrays, trees, lists and other data structures are used to execute data Organisation in main memory, a number of planning's are used to

What is Explicit update In explicit update, each derived attribute is defined with respect to one, or more fundamental base object(s). The object designer determines that de

List the string operations supported by SQL? 1) Pattern matching Operation 2) Concatenation 3) Extracting character strings 4) Converting among uppercase and lower cas