N-ary relationship, Database Management System

For every n-ary relationship type R where n>2, we make a new table S to represent R. We contain as foreign key attributes in s the primary keys of the relations that show the participating entity types. We also contain any easy attributes of the n-ary relationship type (or easy components of complete attributes) as attributes of S. The primary key of S is generally a combination of all the foreign keys that reference the relations showing the participating entity types. Figure  is a special case of n-ary relationship: a binary relation.

Posted Date: 3/6/2013 6:28:06 AM | Location : United States

Related Discussions:- N-ary relationship, Assignment Help, Ask Question on N-ary relationship, Get Answer, Expert's Help, N-ary relationship Discussions

Write discussion on N-ary relationship
Your posts are moderated
Related Questions
Question: (a) Why is it important to know the architecture rather than to start requirement capture when designing a large scale system? (b) Who are the different people in

what are the reasons having variable length records

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

What are the advantages of creating a table from existing table?

What benefits can a company gain by managing its own information infrastructure and servicea

how to construct labelled precedence graph for view serialiability.please explain insteps with one solved examples

What is difference between primary index and secondary index? Primary Index a) It is an ordered file whose records are of fixed length along with two fields. b) Only base

anyone have a textbook solutions case fair, 8 edition of vol 1 ?, please give me

Can your organization scan large format documents? Yes, large format scanning used for such entities as city plans and blueprints is available. We selected scanners with the ab

Explain the concept of deadlock Yes. It can direct to deadlock. Suppose that a batch of frames arrived correctly and were accepted. Then receiver will advance its window. Now s