Many-to-many relationship, Database Management System

Many-to-many: Entities in A and B are related with any number of entities from each other.

Example:

Taught_by Relationship among course and faculty.

One faculty member can be assigned to teach a lot of courses and one course may be taught by a lot of faculty members.

528_Many-to-many Relationship.png

Relationship among book and author.

One author can explained a lot of books and one book can be written by more than one authors.

1298_Many-to-many Relationship1.png

More about Relationships and Entities

Posted Date: 3/6/2013 6:11:37 AM | Location : United States







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

Write discussion on Many-to-many relationship
Your posts are moderated
Related Questions
Consider a relation s over the attributes A and B with the following characteristics: 5,000 tuples with 10 tuples per page A 2-level B+ tree index on attribute

using the invoice table shown below,write the relational schema,draw a dependencies,inclunding all partial and transitive dependencies.assume that the table does not contain repeat

With the help of a suitable diagram gives module wise explanation of system architecture of DBMS.on..

what is cascading rollback

Forward Recovery (Redo): In this system the committed changes made by a transaction are reapplied to a previous copy of the database.                          In simpler

Secondary Indexes Let consider the student database and its clustering index and primary (only one will be applicable at a time). Now consider the state when the database is to

discuss the array implementation of a stack.

A Functional dependency is described by X Y between two groups of attributes Y and X that are subsets of R specifies a constraint on the possible tuple that can make a relation

A TDMS project plan is not a typical Information Technology project plan; therefore, a traffic data project has several unique characteristics: Traffic data management system

What is SQL, and why is it important? SQL stands for Structured Query Language, and is the most significant data processing language in use today. It is not a complete programm