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
The participation Constraints shows whether the existence of an entity depends on its being associated to another entity by the relationship type. There are two kinds of participat

Define union compatibility? Explain why INTERSECTION of two relations cannot be performed if they are not union compatible? Two relations R(A1, A2,-------, An) and S(B1, B2,--

What is self-transition? If there is a transition which goes back to same state, it is known as "self- transition." With a trigger action exit action would be executed f

anyone have a textbook solutions case fair, 8 edition of vol 1 ?, please give me

Explain briefly concurrent task by taking an example. Concurrent Task- The concurrent occurrence of more than one event is called concurrent task. Operating systems can handl

One-way Associations If an association is only traversed in single direction, then it is known as one-way association. It is implemented as a pointer or an attribute which con

What sorts of tables one can se in designing the hierarchy of a LDB? Tables, which are having Foreign Key relations.

A set of possible data values is called? A set of possible data values is called as domain.

What is a foreign key, and what is it used for? A foreign key is used to establish relationships between relations in the relational model. Technically, a foreign key is a colu

What are the problems if one were not to normalize?  When do these problems surface?           Ans:  Database normalization, sometimes considered to as  canonical synthesis, is