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
What is a data dictionary?  A data dictionary is a data structure which keeps Meta data about the structure of the database i.e.  the schema of the database.

prototype of a distributed information system for a national car part retail outlet chain.

Compare the Nested-loop join and block-nested loop join Ans: Nested  loop join - It is costly as worst case cost, no. of block accesses needed is n r * b s + b r   where b

Lack of Redundancy We have talked about the problems of repetition of information in a database. Such repetition should be stay away as much as possible. Let us state once again t

INTRODUCTION Databases and database systems have become an essential part of our daily life. We encounter many activities that involve some interaction with a database almost

Explain Record Based Logical Models? Record-Based logical Models: Also define data at the conceptual and view levels. Unlike object-oriented models, are used to state overall

Illustration of implementation of inheritance Let us take the illustration of implementation of inheritance. Suppose that we are about to implement the Stack class and by now w

Timestamps For Read operations: If TS (T) If TS (T) >= W-timestamp (Q), then the transaction T is trying to read a value of data item Q which has been written and committed

Explain the three data models namely relational, network and hierarchical and evaluate their relative advantages and disadvantages. Hierarchical Model: In hierarchical model, da

Define in which normalisation form if an attribute of a composite key is dependent on an attribute of other composite key. Ans: 3NF A relation is in 3 NF if an attribute of