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

Explain an attributes, What are attributes? Give examples. An entity is... What are attributes? Give examples. An entity is shown by a set of attributes. Attributes are descriptive properties possessed by every member of an entity set. Example: pos

Data Minnning, Can i get help with weka software Can i get help with weka software

What are the benefits of decomposing a system, What are the benefits of dec... What are the benefits of decomposing a system? The benefits of decomposing a system into subsystems are that after decomposition, each individual component become smaller and e

Clinic, Need a sample of a clinic database relationships Need a sample of a clinic database relationships

Consider relational schema and construct algebra query, Consider the follow... Consider the following relational schema: PERSON (SS#, NAME, ADDRESS) CAR (REGISTRATION_NUMBER, YEAR, MODEL) ACCIDENT (DATE, DRIVER, CAR_REG_NO) OWNS (SS#, LICENSE) Constru

Describe specialsation and generalization, Describe Specialsation and gener... Describe Specialsation and generalization? Specialisation /generalization: This is a top down and bottom up approach to the design of database. It displays the IS_A relation

Describe integrity and security, Describe integrity and security? a)   ... Describe integrity and security? a)      Domain constraint b)      Referential integrity A value that appears in one relation for a given set of attributes also appear fo

In e-r diagram how relationship type is represented, In E-R Diagram how rel... In E-R Diagram how relationship type is represented ? In E-R Diagram relationship type is represented as a Diamond.

Define the terms entity type and entity set, Define the terms i) Entity typ... Define the terms i) Entity type ii) Entity set Entity type: An entity type describes a collection of entities that have the similar attributes. Entity set: The set of all en

Rational Data Model, What is a trigger What is a trigger