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
Consider the following frequency counts of some itemsets in a transaction database r : freq({A}, r) = 0.405 freq({B}, r) = 0.510 freq({C}, r) = 0.303 freq({A

What is multiple relationship ?

1. Staff (staffID --> availabilityID) 2. Services (servicesID --> itemBasedID --> timedBasedID) 3. TimedBased (timedbasedID--> priceid) 4. Clients (clientId, serviceId-->

Problem 1 What is a Data Warehouse? Mention its advantages 2 Explain the Top-Down and Bottom-up Data Warehouse development Methodologies 3 What is Data Transformation? Ex

Implementing software control To implement software control designer must redesign strategy of state event model which is present in dynamic model. There are three basic ap

What is a disjoint less constraint? Ans: It needs that an entity belongs to no much more than one level entity set.  Disjoint less constraint needs that an entity belongs to

What are composite attributes? Composite attributes can be separated in to sub parts.

What are the types of storage devices? Primary storage Secondary storage Tertiary storage Volatile storage Nonvolatile storage

What are the difference between clustered and a non-clustered index? A clustered index is a special type of index that reorders the way records in the table are physically stor

Ask qu. Write a XML with database with book details (Book ID, Title, Author, subject, published year, language, vendor, and price).estion #Minimum 100 words accepted#