Explain what is aggregation, Database Management System

Explain what is Aggregation ?

Aggregation: This is used whenever we intend to show a relationship between an entity and the relationship. There is no provision for this in the ER Model. This is shown by placing the relationship between two entities along with the entities in a box and setting up a relationship between this box and another entity.

Posted Date: 5/11/2013 2:16:49 AM | Location : United States

Related Discussions:- Explain what is aggregation, Assignment Help, Ask Question on Explain what is aggregation, Get Answer, Expert's Help, Explain what is aggregation Discussions

Write discussion on Explain what is aggregation
Your posts are moderated
Related Questions
What are the three classes of SQL expression? SQL expression consists of three clauses:  Select  From  Where

What is view in SQL? How is it defined? Any relation that is not part of the logical model, but is made visible to a user as a virtual relation is known as a view. We descri

Define lock? Lock is the most common used to execute the requirement is to permit a transaction to access a data item only if it is currently holding a lock on that item.

The Database administrator (DBA) uses the data dictionary in each phase of a database life cycle, beginning from the data gathering phase to the design, execution and maintenance p

In case of entity integrity, the primary key may be declared? In a case of entity integrity primary key may be not Null.

A constraint named less_than_20 was defined on the field date_of_birth of table student. Delete this constraint. ALTER TABLE student DROP CONSTRAINT less_than_20;

Normal 0 false false false EN-IN X-NONE X-NONE

What do you mean by atomicity and aggregation? Atomicity : Either all actions are carried out or none are. Users should not have to worry about the effect of incomplete trans

What is association? Give an example of association Association is used for establishing relationships among classes. Association describe links among/between classes. For exa