Explain the two types of participation constraint, Database Management System

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







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
Related Questions
Example : Search the name, department number and salary of employees drawing minimum salary in that department. SELECT ENAME, SAL, DEPTNO  FROM EMP WHERE SAL IN (SELECT MI

Explain the Project-Join normal form A relation R is in PJNF along with respect to a set of functional dependencies D if for all join dependencies of the outline *(R 1 , R 2 ,

Given the following set of functional dependencies {cf→ bg, g → d, cdg → f, b → de, d → c} defined on R(b,c,d,e,f,g) a. Is cf→ e implied by the FDs? b. Is dg a superkey?

What are domain constraints? A domain is a set of values that might be assigned to an attribute .all values that appear in a column of a relation must be taken from the similar

Saving Derived Attributes to Avoid Re-computation Data that is derived from other data should be stored in the computed form to avoid re-computation. For this, we could define

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

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

what is inverted and multilist structure

What is deadlock? How can it be avoided? How can it be resolved once it occurs? Deadlock happens when two transactions are each waiting on a resource that the other transaction

CREATE YOUR DATABASE TABLES Your database project must have a minimum of four tables. Include the SQL scripts used to create the tables in your documentation. Explain the tables