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
How much would you charge to create a database encompassing an Online Bakery with all the elements below? I. Describe the application that you would like to design. This should

Now that she understands more about the benefits of databases, the play-scheme manager would like to extend the play-scheme database to include data for schools and instructors as

ER diagram on cosmetics

Relational and E-R Model There are three types of constraints on relational database that have: DOMAIN CONSTRAINT PRIMARY KEY CONSTRAINT INTEGRITY CONSTRAINT

Give an example of enforcement in Typing. You can understand the idea of enforcement as it makes sure objects of dissimilar classes may not be interchanged as below:  Exampl

A Functional dependency is described by X Y between two groups of attributes Y and X that are subsets of R specifies a constraint on the possible tuple that can make a relation

Draw an entity relationship diagram (ERD) for the following situation: A company has a number of employees. Each employee is identified by an Employee_Id. The company wants to st

Locks: Serialisabilty is just a test whether a given interleaved schedule is ok or has a concurrency related trouble. Though, it does not make sure that the interleaved concurrent

A View may be defined of as a virtual table, that is, a table that does not really exist in its own right but is instead inferred from one or more underlying base data table. T

Architectural standard: Designation : Architect , Consultant Job Profile : As a part of Oracle Fusion Middleware at Satyam, I am involved with Presales, Delivery, A