for every n-ary relationship type r where ngt2 we


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.

Request for Solution File

Ask an Expert for Answer!!
Database Management System: for every n-ary relationship type r where ngt2 we
Reference No:- TGS0208889

Expected delivery within 24 Hours