One to many - relationship cardinality, Database Management System

One-to-many: An entity in A is related with any number of entities in B. An entity in B is related with at the most one entity in A.

Example: Relationship between faculty and department.

541_One to many - Relationship Cardinality.png

One department can take on any number of faculty members but a faculty member is assigned to only one department.

  • Many-to-one: An entity in A is related with at most one entity in B. An entity in B is related with any number in A.

147_One to many - Relationship Cardinality1.png

Example: Relationship between course and instructor. An instructor can teach several courses but a course can be taught only by one instructor. Please note this is an assumption

Posted Date: 3/6/2013 6:08:57 AM | Location : United States







Related Discussions:- One to many - relationship cardinality, Assignment Help, Ask Question on One to many - relationship cardinality, Get Answer, Expert's Help, One to many - relationship cardinality Discussions

Write discussion on One to many - relationship cardinality
Your posts are moderated
Related Questions
Which database level is closest to the users? External database level is closest to the users.

Which two tools are used to administer users for Active Directory?


Attributes that are directly kept in the data base. For example, 'Birth date' attribute of a person.   Derived  Attributes that are not stored directly but can be derived

What is serializability? Explain its types? The data base system must control concurrent implementation of transactions, to ensure that the data base state remains consistent.

SET concept is used in which type of modelling? SET concept is used in Network Model.

Your friend owns a computer store in Yuen Long, selling Desktop and Notebook PCs and other computer peripherals. Having been rather successful with his business there, he decided t

If R1 and R2 are two relations or functions, then the result of R3 = R1 × R2 is the combination of tuples that are in R1 and R2. The product is associative and commutative. Degr

Attributes having a one value for a particular entity. For instance, Age is a single valued attribute of a student entity. Attributes  that  have  more  than  single  values

Ask qu. Write a XML with database with book details (Book ID, Title, Author, subject, published year, language, vendor, and price).estion #Minimum 100 words accepted#