Relationship sets, Database Management System

A relationship set is a set of relationships of the similar type.

For example, let consider the relationship among two entities sets course and student. Collection of all the instances of relationship opts forms a relationship set known as relationship type.

Degree

The degree of a relationship type is the number of participating entity types.

The relationship among two entities is known as binary relationship. A relationship among three entities is known as ternary relationship.

Likewise relationship between n entities is called n-ry relationship.

Posted Date: 3/6/2013 6:04:59 AM | Location : United States







Related Discussions:- Relationship sets, Assignment Help, Ask Question on Relationship sets, Get Answer, Expert's Help, Relationship sets Discussions

Write discussion on Relationship sets
Your posts are moderated
Related Questions
Explain entity integrity and referential integrity rules within relational model. Show how these are realized in SQL? Entity Integrity Rule - No primary key value could be nu

Define two-phase locking protocol. Ans: Two-phase locking is significance in the context of ensuring that schedules are serializable. The two-phase locking protocol defines a p

DROP TABLE Command: When an existing object is not needed for further use, it is always better to eliminate it from the database. To remove the existing object from the databas

What is normalization? It is a method of analysing the given relation schemas based on their Functional Dependencies (FDs) and primary key to attain the properties (1).Minim

please give me introduction to full data in D B M S in a short assignment

a set of possible data value of an attribute is called??

describe all the tables you have created. ?get table_name, status, num_rows, user_stats in user_tables system view ?get table_name, constraint_name, constraint_type in user_constr

What is the use of Union and intersection operation? Union: The result of this operation contains all tuples that are either in r1 or in r2 or in both r1 and r2.Duplicate tuple

a) Distinguish between ‘database' and ‘Database Management Systems (DBMS)'. b) List and briefly describe five potential benefits of the database approach compared to conventio

What are the Constituents of File? Also elaborates all the possible file operations? A file is organised logically as sequence of record. These records are mapped onto disk blo