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

What is called query processing, What is called query processing? Query... What is called query processing? Query processing refers to the range of activities included in extracting data from a database.

Convert the erd into its relevant relational schema, Question: Describe... Question: Describe briefly the three parts of the Relational Model. (a) The term integrity refers to the accuracy or correctness of the data in the database. Define the fol

What are partial and natural key, What are partial, alternate,, artificial,... What are partial, alternate,, artificial, compound and natural key? Partial Key: It is a set of attributes that can uniquely recognize weak entities and that are related to s

Types of online analytical processing tools, Describe the various types of ... Describe the various types of Online Analytical Processing (OLAP) tools and briefly discuss how the support common analytical operations.

Critically evaluate the bulleted list of information, Critically evaluate t... Critically evaluate the bulleted list of information-related items in this case study. How are each contradictory to the notion of being an information-literate knowledge worker?

What is difference among mysql_connect and mysql_pconnect, What is differen... What is difference among mysql_connect and mysql_pconnect? Mysql_connect() opens a new connection to the database while mysql_pconnect() opens persistent connection to the data

Normalization, Normalize the given relation to 3NF, justifying each step Normalize the given relation to 3NF, justifying each step

Computing the closure of a set of functional dependency, What is meant by c... What is meant by computing the closure of a set of functional dependency? The closure of F denoted by F + is the set of functional dependencies logically implied by F.

Explain nested relations, Explain nested relations? Nested relations ... Explain nested relations? Nested relations The assumption of INF is a natural one in the bank examples we have considered. However, not all applications are best modelled

List the sql domain types, List the SQL domain Types? SQL supports the ... List the SQL domain Types? SQL supports the following domain types. 1) Char(n) 2) varchar(n) 3) int 4) numeric(p,d) 5) float(n) 6) date.