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
Question: Using the data model express the following queries in SQL. (a) Create the Table named "Cinema" and make the cinema_code to be the primary key of the relation and

What are the states of transaction? The states of transaction are:- a) Active b) Partially committed c) Failed d) Aborted e )Committed   f) Terminated

for the following business rules . Identify all entities, attributes, relationships, primary keys, cardinalities and constraints where appropriate 3. (9) An art museum owns a larg

What are the advantages of creating a table from existing table?

Which two tools are used to administer users for Active Directory?

I have 10+ yrs exp in oracle Sql ,Pl/SQl,Forms ,Reports. I am expert in assignements & Online tutoring so i want to join you. Please guide me. Thanks Brajesh Shukla +91 9899641535

external and internal mapping with examples

DML Precompiler All the DBMS have two basic sets of Languages - Data Definition Language (DDL) that have the set of commands needed to define the format of the data that is b

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

Object-based Models: Use objects as key data representation components . Examples:-   Entity-Relationship Model: It is a collection of real world objects known as entitie