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 are the four main characteristics of the database approach? The four major characteristics of the database approach are: 1. Self-describing nature of a database system. 2.

What is equi join? Equi Join - It generates all the combinations of tuples from two relations which satisfy a join condition along with only equality comparison (=).

Differentiate between horizontal & mixed horizontal fragmentation?

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

Sparse and Dense Indexes These indexes in principle are the similar as that of indexes used at the back of the book. The key facts of the indexes are: They are arranged

List any two significant differences between a file processing system and a DBMS. File Processing System vs. DBMS Data Independence - Data independence is the capacity t


Explain the differences between structured data and unstructured data. Structured data are facts concerning objects and events. The most significant structured data are numeric

Let us now make the E-R diagram for the student database as per the explanation given in the previous section. We can also states the overall logical structure of a database usi

What is trigger?  Triggers are statements that are executed automatically by the system as the side effect of a modification to the database.