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
What is called mirroring? The simplest approach to introducing redundancy is to duplicate each disk. This method is called mirroring or shadowing.

Give the reasons for allowing concurrency? The reasons for allowing concurrency is if the transactions run serially, a short transaction might have to wait for a preceding long

Define Assertions in SQL a. An assertion is a predicate that is expressing a condition we wish the database to always satisfy.  b. Domain constraints, functional dependency

Give the Introduction of OBJECT DESIGN Strategies which are selected during system design are carried out in object-oriented design. In this procedure, objects which are identi

Availability: A site having the copy of a replicated relation fails, even then the relation may be found in another site. Therefore, the system may carry on to process at least th

Describe domain constraints. Domain constraints contain entity integrity and referential integrity. The domain is a set of values that might be assigned to an attribute. The en

Question 1 What is data mining? Write Data Mining applications Question 2 What is OLAP? Write the benefits of OLAP Question 3 What is Business Intelligence? Explai

List the types of authorization. A) Read authorization B) Write authorization C) Update authorization D) Drop authorization

Natural Join : It is the similar like Equi join except one of the duplicate columns is removed in the result table. The natural join is the most usually used form of join operation

What is an E-R model? Draw an E-R Diagram for the company database with following Descriptions? The company is organized within departments. Each department has a unique name a