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
Explain CNT in the respects of QBE ? CNT: It is one of the aggregation commands given in QBE. It is used to identify number of tuples

I need ERP system We are selling automotive spare parts on the internet and we require ERP software, which would sync with our e-shop. Our e-shop doesn't use any e-commerce plat

Funky Festivals Specification Funky Festivals organise music festivals which take place at various venues throughout the UK.  A venue needs to be booked before a Festival can t

Implementation of association as an object Implement as a separate association object, independent of either class, as in Figure. An association object is a group of pairs

Evaluate, compare and contrast the two methods of relational database design namely top down method and Bottom up method. What will be your choice if you are asked to select a meth

#what is cursor its uses ? Explain it

Describe about Use Case and external case in DFD The processes are transformed those into the Use Case and external case in DFD has same characteristics which of an actor in O

What is Enterprise Resource Planning (ERP), and what kind of a database is used in an ERP application? Enterprise Resource Planning (ERP) is an information system used in manuf

Limitations of File Based System The file-based system has some limitations. The limitations are listed as follows: Isolation and separation of data: When the data is

Question : (a) Differentiate between database integrity and database security (b) Database security involves measures to avoid loss of privacy and loss of confidentiality. D