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
Explain the disadvantages of using DBMS There could be a few disadvantages of using DBMS. As DBMS requires computers, we have to invest a good amount in acquiring the hardwa

Types Of Indexes One of the words used during the file organisation is the term index. In this part, let us describe this term in more detail. We find the index of keywords

Explain Object oriented Model ? Object Oriented Model - This model is based on the object-oriented programming language paradigm. It involves the features of OOP such as inhe

What is difference between TRUNCATE and DELETE? - Truncate can't be rolled back whereas Delete can be. - Truncate keeps the lock on table whereas Delete keeps the lock on ea

User error :  This contains errors in the program (e.g., Logical errors) with errors made by online users of database.  These types of errors can be avoided by applying some check

Difference between Operating System and Database Security Security within the operating system can be executed at various levels ranging from passwords for access to system, t

What is meant by object identifiers? Object-oriented systems use an object identifier to recognize objects. Object identifiers are unique: that is every object has a single ide

Describe relational model? Structure of relational data base Basic structure Database schema Keys Schema diagram Query languages

Need a sample of a clinic database relationships

what does glory be mean