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
discuss the array implementation of a stack.

(a) Explain briefly the three parts of a relational Model. (b) Contrast the following terms with an appropriate example: (i) stored attribute v/s derived attribute (ii) en

What do you mean by DBMS? What is its need and what are its goals. Explain?        OR   Explain Data Base Management System? Sol.  Database management system is a

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 Network DBMS The NDBMS is built primarily on a one-to-many relationship, but where a parent-child representation between the data items cannot be ensured. This may occur

What are the three data anomalies that are likely to occur as a result of data redundancy?  Can data redundancy be completely eliminated in database approach?  Why or why not? A

Data Manipulation Language Data manipulation language (DML) describes a set of commands that are used to query and change data within existing schema objects. In this case comm

PRINCIPLES OF DATABASE 1. State the following terms: a) Database b) Database Management System c) Entity d) Attribute e) Relationship 2. Discuss the Three Level Architecture

Draw and explain the three level architecture of the database system? A DBMS gives three levels of data is said to follow three-level architecture. The trget of the three-schem