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
Fifth Normal Form (5NF) These relations still have a difficulty. While defining the 4NF we mentioned that all the attributes depend upon each other. Whereas creating the two ta

Which sorting technique is used to sort databases, whose sizes are very big?  Give one such algorithm.  Why do sorting techniques like quicksort, insertion sort, etc.  not applied

During the deletion of a tuple two cases can happen: Deletion of tuple in relation having the foreign key: In this type of case simply delete the desired tuple. For example, in

We are looking to find someone to prepare a database which improves upon the one we are using at present. The present database will be found here: Click on filter options and yo

You are required to program (in a high level language such as C, C++, Java) and implement a cache simulator which will have the following inputs and outputs:- INPUTS

as a customer service employee explain five measures you would recommend to make even a displeased students patronize the school canteen

Question 1 What do you mean by database management system? Question 2 Write a note on Object-Oriented Model Question 3 Explain Sequential File Organization Question

Describe substring comparison in SQL. For the relation Person (name, address), write a SQL query that retrieves the names of people whose name starts along with ‘A' and address co

Explain the Deferred Update The deferred update methods do not physically update the database on disk till after a transaction reaches its commit point; after that the updates

Explain the difference between the three storage types - volatile, non volatile and stable.             Ans: Volatile storage: if storage media loses data while power goes off,