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
Ask question #MinimRead Dennis et al. Chapter 6: Minicase 2. Work through it and answer the questions. See the attached example. SequenceDiagram.png Based on the structural mod

Describe the responsibilities of the DBA and the database designer ? The responsibilities of DBA and database designer are: 1. Planning for the database's future storage needs

Write a short note on oracle Instance? Oracle Instances: An instance is the (executed) Oracle software and the memory they use. It is the instance which manipulates the data s

Describe domain constraints. Domain constraints contain entity integrity and referential integrity. The domain is a set of values that might be assigned to an attribute. The en

List the SQL domain Types? SQL supports the following domain types. 1) Char(n) 2) varchar(n) 3) int 4) numeric(p,d) 5) float(n) 6) date.

Write A short note on temporary tables? Temporary Tables - Temporary tables exists solely for a particular session, or whose data persists for the duration of the transaction

What is data model? Explain object based and record based data models? Ans: A data model is an abstract model in which describes how data is represented and accessed. (i)

compare the features of oracle RDBMS with MySQL and Microsoft SQL server

Define in which normalisation form if an attribute of a composite key is dependent on an attribute of other composite key. Ans: 3NF A relation is in 3 NF if an attribute of

Question: (a) What are the challenges in the development of Large Scale Distributed Real Systems? (b) What is backward engineering and forward engineering in a design packa