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.


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
Having clause This clause is used for producing conditions on grouped information. Example: Find maximum salary and department number of those departments where maxim

Differentiate between join and outer join? Outer joins return all rows from at least one of the tables or views mentioned within the FROM clause, as long as those rows get toge

Explain three main attributes of data.

Atomicity: It describes a transaction to be a one unit of processing. We can also say either a transaction will be finished completely or not at all. In the transaction example 1

Which operations need the participating relations to be union compatible? A UNION, INTERSECTION and DIFFERENCE operations need the participating relations to be union compatibl

What are the advantages and disadvantages of merging an association into a class?  Advantages: i)  Less number of tables ii) Faster performance due to the fewer tables

Concatenation operator Example : Printing name and job as one string as column name employees: SELECT ENAME||JOB "EMPLOYEES" FROM EMP;

Task Part A. Create an ERD from a business problem. (50 marks) Read the following problem and complete the tasks listed below. THE ABS Blood Bank Australian Blood Services (ABS) i

what is file organization? what are file organization techniques.explain in detail? explain random file organization technique, multikey file organization technique?what is indexin

#Use the following database schema: 1) Patient—PatientID, Name, DOB 2) Doctor—DoctorID, Name, MedLicenseNumber, Phone 3) Medication—MedicationID, BrandName, GenericName 4) Prescrip