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
What is called query processing? Query processing refers to the range of activities included in extracting data from a database.

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, 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

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-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? Mysql_connect() opens a new connection to the database while mysql_pconnect() opens persistent connection to the data

Normalize the given relation to 3NF, justifying each step

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? 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? SQL supports the following domain types. 1) Char(n) 2) varchar(n) 3) int 4) numeric(p,d) 5) float(n) 6) date.