Many-to-many relationship, Database Management System

For each m:n relationship type R, we make a new table (say S) to represent R. We also contain the primary key attributes of both the participating entity types as a foreign key attribute in S. Any easy attributes of the m:n relationship type (or easy components of a composite attribute) is also contain as attributes of S.

For example, the m: n relationship taught-by among entities COURSE and FACULTY should be shown as a new table.  The structure of the table will contain primary key of COURSE and primary key of FACULTY entities

A new table TAUGHT-BY will be created as: Primary key of TAUGHT-By table

 

ID

 

Course_ID

 

{Primary key of FACULTY table}

 

{Primary key of COURSE table}

 

 

Please note that since there are no attributes to this relationship, thus no other fields.

Posted Date: 3/6/2013 6:27:46 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

Horizontal Fragmentation- Horizontal fragmentation groups together the tuples in a relation that are collectively used by the main transactions. A horizontal fragment is produced b

Prepare Heart Failure Registry database How are you today? Please I would like you to design a Heart Failure registry where doctors will log in to enter information about their

Atomicity: It describes a transaction to be a one unit of processing. We can also say either a transaction will be finished completely or not at all. In the transaction example 1


What is a B+-Tree index? A B+-Tree index takes the form of a balanced tree in which each path from the root of the root of the root of the tree to a leaf of the tree is of the

Do the 11.1 11.1 Credit Card Use. Consider the following hypothetical bank data on consumers’ use of credit card credit facilities in Table 11.3. Create a small worksheet in Exce

The scenario You have been approached to design and implement a prototype of a distributed information system for a national car part retail outlet chain. The company comprises

Project Description: I would like to get a database of a website which has clients email name and phone number. If you are able to get information from a website, by entering

Explain outer join? Outer Join - If there are any values in one table which do not have corresponding value(s) in the other, in an equi-join which will not be chosen. Such ro