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

Database Management System, Assume that you are responsible for selecting a... Assume that you are responsible for selecting a new DBMS product for Sohar Hospital

Phase 1 Individual Project, How do I begi How do I begin

Example-revoke all on emp from mca12, Example:  //REVOKE ALL ON EMP FROM MC... Example:  //REVOKE ALL ON EMP FROM MCA12;                              (All permissions will be cancelled) You can also cancel only some of the permissions. Drop: A user-

Mysql database merge, MySQL Database Merge Project Description: I hav... MySQL Database Merge Project Description: I have two databases, I need merge the data of one database into another Work to be done online right now. Payment can be done

What is de-normalization, What is De-normalization? De-normalization is... What is De-normalization? De-normalization is the method of attempting to optimize the performance of a database by adding redundant data. It is sometimes essential because cur

Find out the names of all employees from database, Find out the names of al... Find out the names of all employees who work for first Bank Corporation from database. SELECT EMPLOYEE_NAME FROM WORKS WHERE COMPANYNAME = ‘First Bank Corporation';

Determine candidate and primary key, A video rental company has several bra... A video rental company has several branches. The data held on each branch is the branch address made up of street, city, state, and zip code, and the telephone number. Ea

Explain data sublangauges, Explain Data Sublangauges ? Data sublanguage... Explain Data Sublangauges ? Data sublanguage: In relational database theory, the term sublanguage, first used for this purpose through E. F. Codd in the year of 1970, refers t

What is horizontal fragmentation, What is horizontal fragmentation? Hor... What is horizontal fragmentation? Horizontal fragmentation divides the relation by assuming every tuple of r to one or more fragments

Assignment, Birla Institute of Technology & Science, Pilani Work-Integrated... Birla Institute of Technology & Science, Pilani Work-Integrated Learning Programmes Division Second Semester 2012-2013 EC-1 Assignment 2 (7.5% of the grade) Course No. : SS ZG