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

Northwind Pty Ltd sells a variety of food products throughou, i want help t... i want help to complete my task

How does query tree represent relational algebra expression, How does a que... How does a query tree represent a relational algebra expression?  Discuss any three rules for query optimisation, giving example as to when should each rule be applied.     Ans

Explain the two constraints check and foreign key in sql, Explain the two c... Explain the two constraints, check and foreign key in SQL along with an example for each. Give the syntax. CHECK constraint - CHECK constraint specifies an expression which

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

Explain heap file with advantages, Explain heap file with advantages? H... Explain heap file with advantages? Heap File is an unordered set or a group of records, stored on a set of pages. This class gives basic support for inserting, updating, select

What is difference between primary index and secondary index, What is diffe... What is difference between primary index and secondary index? Primary Index a) It is an ordered file whose records are of fixed length along with two fields. b) Only base

Clinic, Need a sample of a clinic database relationships Need a sample of a clinic database relationships

How to operate database in access, how to operate database in access ? how to operate database in access ?

Dataware house, ) Define a job scheduling strategy that will meet business ... ) Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a picto

Define the categories of sql statements, Define the categories of SQL State... Define the categories of SQL Statements? 1) Statements that don't return a result set. This statement class includes INSERT, DELETE, and UPDATE. 2)Statements that return