Relationship cardinality, Database Management System

Cardinality shows the number of instances of an entity associated with another entity participating in a relationship. Depend on the cardinality binary relationship can be further dividing into the following categories:

  • One-to-one: An entity in A is related with at most one entity in B, and an entity in B is associated with at most one entity in A.


Example: Relationship between university/college and principal

1656_Relationship Cardinality.png

One college only have at the most one principal and one principal can be assigned to only one college.

Likewise we can define the relationship among Vice Chancellor and university.

Posted Date: 3/6/2013 6:06:45 AM | Location : United States

Related Discussions:- Relationship cardinality, Assignment Help, Ask Question on Relationship cardinality, Get Answer, Expert's Help, Relationship cardinality Discussions

Write discussion on Relationship cardinality
Your posts are moderated
Related Questions
Explain the Natural join Natural join is a binary operator which is written as (R* S) in which R and S are relations. The effect of the natural join is the set of all combinati

Define Outer join Outer join - If there are any type of values in the one table that do not have corresponding value(s) in the other, in an equi-join which will not be selected

Decompose the table with the following description and functional dependencies into a set of equivalent tables normalized to 3NF or BCNF. This database stores records from a (ve

A database for the Service and Maintenance (SM) section of a Computer sales and service Company has to be developed. SM gives after sales service to customers. SM branch has a numb

Construct a generalization-specialization hierarchy for a motor-vehicle sales company. The company sells motorcycles that comprise an engine number and cost; cars that have a chass

When It is better to use files than a DBMS? It is better to use files than a DBMS when Multiple users wish to access the data.

Q.  What is relational algebra and calculus? Explain the relational algebra operators :- Selection and predicate, set operation, joins and division. Sol. Relational Algebra

The database application project (DAP) for this assignment consists of the creation of a fully functional Microsoft Access database application for a real client. I recommend you s

Q.   Explain the terms key constraints participation constraints and mapping caradinalities in ER model.  Participation Constraints :   The participation of an entity set E i