Participation constraints, Database Management System

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 participation constraints:

Total: When the entire entities from an entity set participate in a relationship type, is known as total participation, for instance, the participation of the entity set student in the relationship set have to 'opts' is said to be total as each student enrolled must opt for a course.

Partial: When it is not necessary for all the entities from an entity set to partake in a relationship type, it is known as partial participation. For instance, the participation of the entity set student in 'represents' is partial, as not every student in a class is a class representative.

Posted Date: 3/6/2013 6:12:10 AM | Location : United States







Related Discussions:- Participation constraints, Assignment Help, Ask Question on Participation constraints, Get Answer, Expert's Help, Participation constraints Discussions

Write discussion on Participation constraints
Your posts are moderated
Related Questions
10A.53 Code an Oracle Database trigger to enforce the constraint that an employee can never change his or her department. 10A.54 Code an Oracle Database trigger to allow the

We define a view in SQL through using the create view command. To describe a view, we must provide the view a name and must state the query in which computers the view. The form of

What are the advantages of relational data model? Normal 0 false false false EN-IN X-NONE X-NONE MicrosoftInternetExplorer

write on the various type of relationalkey

Illustrate the view of software architecture A model is a semantically closed abstraction of system composes of elements. It can be visualized using any of the following five v

Discuss the term- Design Optimization  We have seen various ways of representing the objects.The fundamental design model uses analysis model as the framework for implementati

Can you help me with the following: Drop statements for all objects in the lab project. Create statements for all objects of the lab project Create indexes for foreign keys Cre

Draw an EER diagram that captures the "is-a" hierarchy of students in another simple database. The database captures both the "basic" information (say, student ID and student name)

#queDefine a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pic

What is Nested Queries explain in details? Nested Queries - A SELECT query could have subquery(s) in it. While a SELECT query having another SELECT query in it, is known as n