Extended e-r features, Database Management System

Although, the essential features of E-R diagrams are enough to design many database situations. Though, with more difficult relations and advanced database applications, it is need to move to enhanced features of E-R models. The three such features are:

  • Generalisation
  • Specialisation, and
  • Aggregation

In this part, we have described them with the help of an example. More detail on them are available in the further readings and MCS-043.

Example: A bank has an account entity set. The accounts of the bank can be of two parts:

  • Savings account
  • Current account

The statement as above shows a specialisation/generalisation hierarchy. It can be shown as

1135_Extended E-R features.png

Figure: Generalisation and Specialisation hierarchy

Posted Date: 3/6/2013 6:14:49 AM | Location : United States







Related Discussions:- Extended e-r features, Assignment Help, Ask Question on Extended e-r features, Get Answer, Expert's Help, Extended e-r features Discussions

Write discussion on Extended e-r features
Your posts are moderated
Related Questions
A View may be defined of as a virtual table, that is, a table that does not really exist in its own right but is instead inferred from one or more underlying base data table. T

Define the concept of aggregation.  Give two examples where this concept is useful. Ans: Aggregation transforms a relationship among the objects into a higher-level object. A

I just purchased a document for you guys and wanted to confirm that it will be send within an hour or 2 to my email or where will document be sent to?

draw er diagram using entities crop,employee,department,plot,cultivation plan,machinery,seed,fertilizer

Describe the development process of Object oriented methods Object oriented methods have roots which are strongly anchored back in the 60s, functional and structured methods we

What does authentication refer? Authentication refers to the task of verifying the uniqueness of a person.

The Locking Protocol: To manage concurrency related problems we use locking. A lock is mainly a variable that is associated with a data item in the database. A lock can be located

What is the use of group by clause? Group by clause is used to be relevant aggregate functions to a set of tuples. The attributes given in the group by clause are used to shape

What is Explicit update In explicit update, each derived attribute is defined with respect to one, or more fundamental base object(s). The object designer determines that de

Define the concept of generalization A generalization is relationship between specific kind of thing and general thing. It is also known as "is-a-kind-of" relationship. Inher