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
Removing a Synonym: DROP SYNONYM D30;

Parallelism of transaction execution: A transaction can be divided into various sub-queries that can operate on fragments in parallel. This enhances the degree of concurrency in t

Describe DROP TABLE command of SQL along with both the options - CASCADE and RESTRICT. DROP TABLE command - This command drops the specified table. Dropping a table also dro

Given the subsequent relations:    vehicle (reg_no, make, colour)    Person (eno, name, address)    Owner (eno, reg_no)   Write expressions

What do you mean by DBMS? What is its need and what are its goals. Explain?        OR   Explain Data Base Management System? Sol.  Database management system is a

Differance between Open addressing and chaining for collision resolution ? In open addressing , proceeding from the occupied position specified by hash address the program che

When every condition appears with equality condition (=) only. c)   Natural join (denoted by R*S) When two join attributes have the similar name in both relations. (Tha

Question : (a) Data mining is one of the best ways to analyse data and using software method, hidden and unexpected patterns and relationships in sets of data can be extracte

DROP TABLE Command: When an existing object is not needed for further use, it is always better to eliminate it from the database. To remove the existing object from the databas

Explain the term- signal-to-noise ratio A signal-to-noise ratio of 20 dB means that S/N = 100. As log2101 is around 6.658, the Shannon limit is around 19.975 kbps. The Nyquist