Explain the two types of participation constraint. 

Total: The participation of an entity set E in a relationship set R is said to be total if each entity in E participates in at least one relationship in R. 

Partial:  if only some entities in E participate in relationships in R, the participation of entity set E in relationship R is said to be partial.

 

Posted Date: 7/27/2013 6:59:36 AM | Location : United States

Ask an Expert

Related Discussions:- Explain the two types of participation constraint, Assignment Help, Ask Question on Explain the two types of participation constraint, Get Answer, Expert's Help, Explain the two types of participation constraint Discussions

Write discussion on Explain the two types of participation constraint
Your posts are moderated

Write your message here..

Related Questions

State the objectives of object design, Determine the OBJECTIVES of  object ... Determine the OBJECTIVES of  object design After passing through this unit, you should be able to: describe and apply concept of generalisation; understand and appl

Participation constraints, The participation Constraints shows whether the ... The participation Constraints shows whether the existence of an entity depends on its being associated to another entity by the relationship type. There are two kinds of participat

Attributes, Attributes and its types explain? Attributes and its types explain?

Eliminate redundant data, Eliminate Redundant Data In the "Database Rel... Eliminate Redundant Data In the "Database Relation" above, the primary key is made up of the D-ID and the Emp-ID. The database-name relies only on the D-ID. The similar databas

What is oracle databse structure, What is Oracle databse structure? Or... What is Oracle databse structure? Oracle database structure: The relational model has three main aspects: Structures: Structures are well-defined objects which store th

Computer, 1. Will you advise that your organization uses open source softwa... 1. Will you advise that your organization uses open source software and why? 2. Why is it important for business managers to have a basic understanding of the software development

What are the various properties of relational tables, What are the various ... What are the various properties of Relational tables? Relational tables have 6 properties: 1. Each row is unique. 2. Column values are of the same kind. 3. Values are

Hashing technique, note on hashing technique note on hashing technique

Conversion of er diagram to relational database, Conversion of entity sets:... Conversion of entity sets: I)   For  every  strong  entity  type  E  in  the  ER  diagram,  we  make  a  relation  R containing all the easy attributes of E. The relation R pri

What are the three classes of sql expression, What are the three classes of... What are the three classes of SQL expression? SQL expression consists of three clauses:  Select  From  Where