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
Given the subsequent relations:    vehicle (reg_no, make, colour)    Person (eno, name, address)    Owner (eno, reg_no)   Write expressions

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.

Critically evaluate the bulleted list of information-related items in this case study. How are each contradictory to the notion of being an information-literate knowledge worker?

A database administrator''s responsibilities and data contents

Question : (a) Differentiate between database integrity and database security (b) Database security involves measures to avoid loss of privacy and loss of confidentiality. D

What is substitutability? Any method of a class-say A can equally well be adjured with any object belonging to any subclasses B of A. This characteristic leads to code reuse, a

Section A:  Use the following tables to create a database called College.  Use SQL commands. Student stuid(primary) lastName firstName

In a relational model how relations are termed? In a relational model, relations are termed as tables. (The term ‘relation’ is the technical name of the ‘table’ in RDBMS)

What do you mean by persistence? How you will make your data persistent? Persistent data is the data, which has a longer lifetime than program which has created it. Enabling th

Give the forms of triggers? The triggering event can be insert or delete. For updated the trigger can state columns. The referencing old row as clause The referencing