Skip to main content

Generalisation and Specialisation

GENERALISATION
Consider the account entity set with attributes accno and balance. Each account can be classified as SAVINGS ACCOUNT or CURRENT ACCOUNT. Each of these is described by a set of attributes which include all the attributes of the account entity set PLUS some additional attributes , SAVINGS ACCOUNT entities are described by the attribute INTEREST RATE ,while CURRENT ACCOUNT are described by the attribute OVER DRAFT AMOUNT. There are similarities between the current account entity set and the saving account entity set in the sense that they have several attributes in common . This commonality can be expressed by generalization. Generalization is a containment relationship that exist between a higher level entity set and one or more lower level entity sets .Here the ACCOUNT is the higher level entity and SAVINGS ACCOUNT & CURRENT ACCOUNT are LOWERLEVEL ENTITY SETS. In an ER diagram generalization is represented by a triangular component labeled “ISA" it stands for "is a ". For example Savings Account "is an " account .The attributes of higher level entity sets are inherited by the lower level entity sets.




ISA realtionship between ACCOUNT - SAVINGS ACCOUNT & CURRENT ACCOUNT

There are two methods for transforming an ER diagram, which includes generalization, to a tabular form.
FIRST METHOD - Create a table for the higher level entity set. For each lower level entity set create a table which includes columns for each of the attributes of that entity set, plus columns for each of the attributes of the primary key of the higher level entity set.
Then we will have three tables for the above ER diagram .
a). Account with columns accno & balance
b). Savings account with columns accno & interest rate
c). Current account with columns accno. & overdraft amount
SECOND METHOD - Do not create a table for higher level entity set. For each lower level entity set create a table which includes columns for each of the attributes of that entity set, plus columns for each of the attributes of the higher level entity set.
Then we will have two tables for the above ER diagram .
a). Savings account with columns accno, balance & interest rate
b). Current Account with columns accno, balance & overdraft amount.

AGGREGATION
Consider a data base describing information about employees who work on a particular project and uses a number of different machines in there work ,we will obtain the following ER diagram using our basic ER model. We may think that the relation ship sets WORKS & USES can be combined into one single relationship set. But they cannot be combined. Because the ternary relationship obtained by combining these cannot represent a relationship between a manager, (who doesn’t uses any machine) and a project.
Aggregation is an abstraction through which relationships are treated as higher level entities. In this case we consider the relationship set work and the entity sets employee and project as a higher level entity set WORKS. Such an entity is treated in the same manner as any other entity set using the diagram WORKS.






Aggregation :: EMPLOYEE - PROJECT - MACHINE relationship

Using the normal transformation procedure, we will get table for employee, project, machine , works and uses. The table for relationship set uses will include columns for each attribute in the primary key of the entity set machine and the relation ship works. ie. { empcode, pcode, mcode}.

Comments

Post a Comment

Popular posts from this blog

Introduction to Data Structures

Visit My Data Structure Blog for Programs... It is important for every Computer Science student to understand the concept of Information and how it is organized or how it can be utilized. If we arrange some data in an appropriate sequence, then it forms a Structure and gives us a meaning. This meaning is called Information . A data structure is a particular way of storing and organizing data in a computer so that it can be used efficiently. Data may be organized in many different ways. The logical model of a particular organization of data in a computer is called data structure. The choice of the model based on two considerations. It should be reflect the data in the real world. It should be simple that one can effectively process the data when necessary. E.g. Array, linked list, stack, queue, tree, graph Data structure can be classified into two: Linear: A data structure is said to be linear if its elements form a sequence E.g. Array, linked list, stack, queue Non-Linear: A dat

Basic Linux Commands For Beginner's

Basic Linux Commands for Beginners Linux is an Operating System’s Kernel. You might have heard of UNIX. Well, Linux is a UNIX clone. But it was actually created by Linus Torvalds from Scratch. Linux is free and open-source, that means that you can simply change anything in Linux and redistribute it in your own name! There are several Linux Distributions, commonly called “distros”. A few of them are: Mint Ubuntu Linux Red Hat Enterprise Linux Debian Fedora Kali Linux is Mainly used in Servers. About 90% of the Internet is powered by Linux Servers. This is because Linux is fast, secure, and free! The main problem of using Windows Servers are their cost. This is solved by using Linux Servers. Forgot to mention, the OS that runs in about 80% of the Smartphones in the World, Android, is also made from the Linux Kernel. Yes, Linux is amazing! A simple example of its security is that most of the viruses in the world run on Windows, but not on Linux

KTU-FOSS LAB Solutions

Write shell scripts to show the following  ( you can write menu driven programs)  Currently logged user and his logname   ( logname, id -un, echo $USER)  Your current shell ( echo $SHELL)  Your home directory ( echo $HOME)  Your operating system type (echo $OSTYPE)  Your current path setting ( echo $PATH)  Your current working directory ( echo $PWD )  Show Currently logged  users ( w or who -H)      Show only the user name of logged users in the host ( users)      Details of last login ( last mec  ;where mec is the user id )  About your OS and version, release number, kernel version                                                 ( uname -a or  cat  /proc/version)  Show all available shells ( cat /etc/shells )  Show mouse settings (cat  /sys/class/input/mouse*/device/name )  Show computer CPU information       CPU details      ( cat /proc/cpuinfo | more )       Show information on  CPU architecture ( lscpu)       Number of Processo