Advanced Database Management System - Tutorials and Notes: Conversion of Composite Attribute to Relation Schema

Search Engine

Please visit, subscribe and share 10 Minutes Lectures in Computer Science

Sunday, 16 March 2014

Conversion of Composite Attribute to Relation Schema

Composite Attribute to Relation Schema

A Composite Attribute can be converted into Relation Schema using the following rule;
  • Create separate columns for every component attributes (only simple attributes) of any composite attribute. Do not include separate column for composite attribute itself.
Figure 1
Consider the ER diagram given in Figure 1. Let us consider the Entity Set Employee which has two composite attributes namely, EName and Address with component attributes (FName, LName) and (DoorNo, Street, City, Phone) respectively.
According to the rule, we need to create column for every component attribute and not for composite attribute itself. Hence, the relation schema will like the following;

Employee(EID, FName, LName, DoorNo, Street, City, Phone)

The component attributes are underlined. Note that, the composite attributes are not included.



No comments:

Post a comment

Featured Content

Multiple choice questions in Natural Language Processing Home

MCQ in Natural Language Processing, Quiz questions with answers in NLP, Top interview questions in NLP with answers Multiple Choice Que...

All time most popular contents