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
Question: Data Mining is the process of extracting knowledge hidden from large volumes of raw data. (a) Using a suitable example, illustrate how Data Mining can be useful t


What is System R? What are its two major subsystems? System R was intended and developed over a period of 1974-79 at IBM San Jose Research Center. It is a prototype and its pur

What are the disadvantages of file processing system? The drawbacks of file processing systems are a) Data redundancy and inconsistency b) Complexity in accessing data

Describe the Menu based interfaces for web clients or browsing? Menu-Based Interfaces for Web Clients or Browsing - These interfaces present the user along with lists of option

What are the advantages of by using an index and what are its disadvantages ? In difference, if the search key of a secondary index is not a candidate key, it is not sufficient

Show a centralised schema to support the operation of the system you have chosen, including in particular: the product catalogue; the outlets and respective stocks; customer record

Project Description: My VBulletin forum was hacked, and soon after my server machine died. So, I'm now on a new machine, and I think that I've taken care of 99% of the hacking..

While sorting, if the main storage available is not enough, the system writes data to an external help file.  The SAP profile parameter, which determines DIR_SORTTMP

The ABC Bank authority now wants to create a database for their customers. So you are requested to modify your program of Assignment A3 as follows. The main program first displa