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
DISADVANTAGES OF RDBMS

Consider a table student (std_id, std_name, date_of_birth, percent_marks, dept_name). Write a QBE query to display names of Computer Science department students who have scored mo

Whta is the advantage of the database management approach? The advantage of the database management approach is data is integrated and can be accessed by multiple programs.

Security And Integrity After Reading the concepts of database recovery in the last section, let us now deal with a vital concept that helps in minimizing consistency errors in

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.

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

What are the two types of indices? The two types of indices are:- A)     Dense index B)      Sparse index

Define an operator that a Relational Algebra does not have Ans: Relational Algebra does not have Aggregation operators.

To eliminate duplicate rows (distinct operator)  Example: SELECT DISTINCT DEPTNO FROM EMP;

crete a data base relationship model Entity: Students; Professors; Dormitories buildings; Attributes of students: Name; Address; Dorm;