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

Why, generally does an object-oriented system use the relational DBMS? The reasons for using relational DBMS for OO systems could be any combination of following: a. Many or

The objectives of this assignment are:  - to develop skills in the design of database driven applications  - to develop skills in applying SQL to implement the relational and

Consider an information system designed for an online company which provides IT products and services These include desktops, laptops, networking products, IT books, parts, and

Explain the Exec statement in SQL Ans: Exec statement has the structure    EXEC SQL END-EXEC   Embeded SQl statements are of a form identical to non embedded SQL statem

What are the two statements regarding transaction? The two statements regarding transaction of the form are:- A)     Begin transaction B)      End transaction

Which of the operations constitute a basic set of operations for manipulating relational data? Relational algebra operations constitute a basic set of operations for manipulati

Project Description: The work is about founding the best skilled person for the job. I will give you the job description. Skills required are Data Entry, Database Administrat

I need some help with my normalization database homework.