Data aggregation, Database Management System

Assignment Help:

Q. Explain  data aggregation and discuss different design constraints.

Sol. Aggregation   One limitation of the E-R model is that it cannot express relationships among relationships. To illustrate the need for such a construct consider the ternary relationships works on which we will see between a employee, branch and job (see figure). Now, suppose we want to record managers for tasks performed by an employee at a branch that is we want to record managers for (employee branch job) combinations. Let us assume that there is an entity set manager. One alternative for representing these relationships is to create a quaternary relationship manages between employee, branch, job and manager (A quaternary relationships required a binary relationship between manager and employee would not permit us to represent which (branch, job) combinations of an employee are managed by which manager.) Using the basic E R modeling constructs we obtain the E R diagram of given figure.  It appears that the relationship sets works on and manages can be combined into one single relationship set. Nevertheless we should not combine them into a single relationship since some employee; branch job combinations may not have a manager.  There is redundant information in the resultant figure however since every employee; branch job combination it manages is also in works on. If the managers were a value rather than manager entity we could instead make manager a multivalued attribute of the relationship works on. But doing so makes it more difficult to find for example employee branch job triples for which a manager is responsible. Since the manager is manager entity this alternative is ruled out in any case.  The best way to model a situation such as the just described is to use aggregation. Aggregation is an abstraction through which relationship are treated as higher level entities. Thus for our example we regard the relationship set works on as a higher level entity set called works on. Such an entity set is treated in the same manager between works on and manager to represent who manages what tasks. Figure shows a notation for aggregation commonly used to represent the above situation. 

 

 


Related Discussions:- Data aggregation

Explain about the guard condition, What is a guard condition? Explain it wi...

What is a guard condition? Explain it with a suitable example. The guard-condition is a Boolean expression written with respect to parameters of triggering event and attributes

Find a 3nf decomposition , Find a 3NF decomposition of the following relati...

Find a 3NF decomposition of the following relation scheme: University (Faculty, Dean, Department, Chair, Professor, Rank, Student}. The University relation satisfies the following

Abap/4 program, It is not possible to make an ABAP/4 program, which having ...

It is not possible to make an ABAP/4 program, which having only Subroutines. False. We can make ABAP/4 program, which having only Subroutines.

Primary index, Primary index A primary index is a file that has a sorte...

Primary index A primary index is a file that has a sorted series of records having two columns: a block address for that key field in the data file; and the ordering key field.

Lock, lock and types of lock

lock and types of lock

Incident report to the database, The Form input elements are:           ...

The Form input elements are:             Reporter name                                                text type input             Password

Recovery techniques, Recovery Techniques: After Reading the types of failur...

Recovery Techniques: After Reading the types of failures and database errors, let us talk about how to recover from the failures. Recovery can be complete using/restoring the previ

Define the term- actors and data stores, Define the term- Actors and Data...

Define the term- Actors and Data Stores Actors: An actor is the active object which drives data flow graph by producing or consuming values. Actors are attached to inputs a

What are advantages of using an index and disadvantages, What are the advan...

What are the advantages of by using an index and what are its disadvantages ? In difference, if the search key of a secondary index is not a candidate key, it is not sufficient

List some security violations, List some security violations (or) name any ...

List some security violations (or) name any forms of malicious access. A) Unauthorized reading of data B) Unauthorized modification of data C) Unauthorized destruction of

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd