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
What is an index? An index is a structure that helps to place desired records of a relation quickly, without probing all records.

give some example real-life situations where DBMS are most suiitabe

Parallelism of transaction execution: A transaction can be divided into various sub-queries that can operate on fragments in parallel. This enhances the degree of concurrency in t

Describe the GRANT function and explain, how it associates to security. What kind of privileges may be granted? How are they revoked? Ans: Since more than one user can aacce

You want to implement following relationships when designing tables. How would you do it? a.) One-to-one b.) One-to-many c.) Many-to-many a.) One-to-One relationship -

Q.   Explain the terms key constraints participation constraints and mapping caradinalities in ER model.  Participation Constraints :   The participation of an entity set E i

Question 1 Create a table student with attributes student name, roll number, total marks and percentage. Do the following operations Insert details in to the table Update

what is attribute is attribute inheritance in dbms?

First Normal Form and second normal form First Normal Form (1NF) A relation is said to be in 1NF if it having no non-atomic values and each row can give a unique combinat

What are deadlocks?  How can they be avoided?  Ans: Deadlock considers to a particular condition when two or more processes are every waiting for another to release a resource,