Explain the two types of participation constraint, Database Management System

Assignment Help:

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.

Related Discussions:- Explain the two types of participation constraint

Keys - relational database integrity, Candidate Key: In a relation R, a ca...

Candidate Key: In a relation R, a candidate key for R is a subset of the set of attributes of R, which have the differnt two properties: (1) Uniqueness: N

Draw an erd for the above relational schema, The following relational datab...

The following relational database schema represents part of a simplified database used by a library: tblBook (BookID, Title, PublisherID, Category,Price) tblPublisher (Publishe

Determine the advanced modeling concepts, Determine the Advanced modeling c...

Determine the Advanced modeling concepts You have to follow some steps for object-oriented design. These steps for OO Design methodology are as follow: 1) Produce objec

Back up files, what is the importance of back up files

what is the importance of back up files

What are stand-alone procedures, What are stand-alone procedures? Proce...

What are stand-alone procedures? Procedures that are not part of a package are called as stand-alone because they independently defined. A good example of a stand-alone procedu

Employees and projects scenario, how many hourse have been spent on a certa...

how many hourse have been spent on a certain project

Explain the five levels of capability maturity models, Question 1 What is ...

Question 1 What is data mining? Write Data Mining applications Question 2 What is OLAP? Write the benefits of OLAP Question 3 What is Business Intelligence? Explai

Horizontal Fragmentation, I want to fragment existing table using java code...

I want to fragment existing table using java code... help me..!!

What are stored-procedures, What are stored-procedures? And what are the ad...

What are stored-procedures? And what are the advantages of using them? Stored procedures are database objects that perform a user defined operation. A stored procedure can have

Define the schema at the intermediate level of abstraction, Define Accordin...

Define According to the levels of abstraction, the schema at the intermediate level is called Ans: As per to the levels of abstraction, the schema at the intermediate level is

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages