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
What should be declared explicitly in the corresponding ABAP/4 Statements to access internal tables without header lines & why? Work Area. This is needed as the Work Area is

How to create values of structured type? Constructor functions are used to make values of structured types. A function with the similar name as a structured type is a construct

Explain entity integrity and referential integrity rules within relational model. Show how these are realized in SQL? Entity Integrity Rule - No primary key value could be nu

I need an ERD created for any original database(can be on anything). It needs to be 3NF. I then need all the CREATE STATEMENTS, INSERT STATEMENTS(anything you can think of as long

10A.53 Code an Oracle Database trigger to enforce the constraint that an employee can never change his or her department. 10A.54 Code an Oracle Database trigger to allow the delet

#question.explain diversity and magnitude of organic compounds and general properties?

Define Fifth Normal form is concerned with Ans : Fifth Normal form is concerned with Join dependency.

The physical location of a record is determined by which mathematical formula that transforms a file key into a record location? The physical location of a record is determined

You group has been hired by  TrainingrUs.com to keeps track of training revenues. TrainingrUS.com wants you to keep scheduling. COURSE table contains following information:

Design Of Distributed Databases: The distributed databases are mainly relational at local level. So a local database schema is the similar as that of a centralised database design