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

The need for three level architecture, The need for three level architectur... The need for three level architecture The aim of the three level architecture is to divide each user's view of the database from the way the database is physically shown.

Physical records, Physical Records These are the records that are store... Physical Records These are the records that are stored in the secondary storage devices. For the database relation, physical records are the group of fields kept in adjacent me

Explain about primary key, Explain about primary key Primary Key: It ... Explain about primary key Primary Key: It is one of the candidate keys that are taken to be the recognizing key for the entire table. E.g. although there are two candidate ke

Muliti key file organisation, explain multi key file organisation explain multi key file organisation

Explain the concept of two-phase locking, Explain the Concept of Two-phase ... Explain the Concept of Two-phase Locking It concerns the positions of locking and unlocking operations in each transaction.  In this protocol every transaction issue lock and u

Project on designing and creating a database , This project will involve de... This project will involve designing and creating a database for an organization.  In the design of a database, there is no single "perfect" design.  So your database design may not

Improved reliability, Improved Reliability: In a centralised DBMS, a server... Improved Reliability: In a centralised DBMS, a server failure stops the operations of the DBMS. Though, a failure at single site of a DDBMS, or a failure of a communication link cr

What is the candidate key for a table with columns, For problems 1-4, give ... For problems 1-4, give all candidate keys for the tables with FDs specified.  Composite candidate keys must be put in parentheses, and candidate keys must be separated with commas

ER Modeling, explain ER Modeling? explain ER Modeling?

Attribute, composite attribute composite attribute