![Page 1: 1/5/20141 Sumitha C.H, SFIT. ER to relations model mapping – review EER to Relations model mapping Summary 1/5/20142Sumitha C.H, SFIT](https://reader036.vdocuments.us/reader036/viewer/2022062511/55140236550346e2488b4976/html5/thumbnails/1.jpg)
04/10/23 1Sumitha C.H, SFIT
![Page 2: 1/5/20141 Sumitha C.H, SFIT. ER to relations model mapping – review EER to Relations model mapping Summary 1/5/20142Sumitha C.H, SFIT](https://reader036.vdocuments.us/reader036/viewer/2022062511/55140236550346e2488b4976/html5/thumbnails/2.jpg)
ER to relations model mapping – review
EER to Relations model mapping
Summary
04/10/23 2Sumitha C.H, SFIT
![Page 3: 1/5/20141 Sumitha C.H, SFIT. ER to relations model mapping – review EER to Relations model mapping Summary 1/5/20142Sumitha C.H, SFIT](https://reader036.vdocuments.us/reader036/viewer/2022062511/55140236550346e2488b4976/html5/thumbnails/3.jpg)
04/10/23 3Sumitha C.H, SFIT
![Page 4: 1/5/20141 Sumitha C.H, SFIT. ER to relations model mapping – review EER to Relations model mapping Summary 1/5/20142Sumitha C.H, SFIT](https://reader036.vdocuments.us/reader036/viewer/2022062511/55140236550346e2488b4976/html5/thumbnails/4.jpg)
04/10/23 4
Step 1
Step 2
Step 6
Step 3
Step 5
Step 4
Sumitha C.H, SFIT
![Page 5: 1/5/20141 Sumitha C.H, SFIT. ER to relations model mapping – review EER to Relations model mapping Summary 1/5/20142Sumitha C.H, SFIT](https://reader036.vdocuments.us/reader036/viewer/2022062511/55140236550346e2488b4976/html5/thumbnails/5.jpg)
Step 1: Mapping of Regular Entity Types.
For each regular (strong) entity type in the ER schema, create a relation R that includes all the simple attributes of E.
Choose one of the key attributes of E as the primary key for the relation.
04/10/23 5Sumitha C.H, SFIT
![Page 6: 1/5/20141 Sumitha C.H, SFIT. ER to relations model mapping – review EER to Relations model mapping Summary 1/5/20142Sumitha C.H, SFIT](https://reader036.vdocuments.us/reader036/viewer/2022062511/55140236550346e2488b4976/html5/thumbnails/6.jpg)
Employee
Project
DepartmentPname Pnumber PLocation
Dname Dnumber
Fname Minit Lname Ssn Bdate Sex Address Salary
04/10/23 6
ERSumitha C.H, SFIT
![Page 7: 1/5/20141 Sumitha C.H, SFIT. ER to relations model mapping – review EER to Relations model mapping Summary 1/5/20142Sumitha C.H, SFIT](https://reader036.vdocuments.us/reader036/viewer/2022062511/55140236550346e2488b4976/html5/thumbnails/7.jpg)
Step 2: Mapping of Weak Entity Types
For each weak entity type W in the ER schema with owner entity type E, create a relation R and include all attributes of the weak entity as attributes of the new relation R.
Then, include the primary key of the owner entity as foreign key attributes of R.
The primary key of R is the combination of the primary key(s) of the owner(s) and the partial key of the weak entity type W, if any.
04/10/23 7Sumitha C.H, SFIT
![Page 8: 1/5/20141 Sumitha C.H, SFIT. ER to relations model mapping – review EER to Relations model mapping Summary 1/5/20142Sumitha C.H, SFIT](https://reader036.vdocuments.us/reader036/viewer/2022062511/55140236550346e2488b4976/html5/thumbnails/8.jpg)
Employee
Dependent
Fname Minit Lname Ssn Bdate Sex Address Salary
Essn Dep_name Sex Bdate Relationship
04/10/23 8
ER
Sumitha C.H, SFIT
![Page 9: 1/5/20141 Sumitha C.H, SFIT. ER to relations model mapping – review EER to Relations model mapping Summary 1/5/20142Sumitha C.H, SFIT](https://reader036.vdocuments.us/reader036/viewer/2022062511/55140236550346e2488b4976/html5/thumbnails/9.jpg)
Step 3: Mapping of 1:1 Relation Types
(1) Foreign Key approach:
Choose one of the relations and include as foreign key in one relation (S) which is the primary key of the other relation (T).
S an entity type with total participation in the relationship
(2) Merged relation option: Merge the two entity types and the relationship into a single
relation. Appropriate when both participations are total.
04/10/23 9Sumitha C.H, SFIT
![Page 10: 1/5/20141 Sumitha C.H, SFIT. ER to relations model mapping – review EER to Relations model mapping Summary 1/5/20142Sumitha C.H, SFIT](https://reader036.vdocuments.us/reader036/viewer/2022062511/55140236550346e2488b4976/html5/thumbnails/10.jpg)
Employee
Department
Dname Dnumber MgrSsn MgrStartDate
Fname Minit Lname Ssn Bdate Sex Address Salary
04/10/23 10
ERSumitha C.H, SFIT
![Page 11: 1/5/20141 Sumitha C.H, SFIT. ER to relations model mapping – review EER to Relations model mapping Summary 1/5/20142Sumitha C.H, SFIT](https://reader036.vdocuments.us/reader036/viewer/2022062511/55140236550346e2488b4976/html5/thumbnails/11.jpg)
Step 4: Mapping of Binary 1:N Relationship Types.
For each regular 1:N relationship type R, identify the relation S, which is the entity on the N-side of the relationship.
Include as foreign key in S the primary key of the relation which is on the 1 side of the relationship.
Include any simple attributes of the 1:N relation type as attributes of S.
04/10/23 11Sumitha C.H, SFIT
![Page 12: 1/5/20141 Sumitha C.H, SFIT. ER to relations model mapping – review EER to Relations model mapping Summary 1/5/20142Sumitha C.H, SFIT](https://reader036.vdocuments.us/reader036/viewer/2022062511/55140236550346e2488b4976/html5/thumbnails/12.jpg)
Employee
Department
Project
DependentPname Pnumber PLocation Dnum
Dname Dnumber MGrSSN MgrStartDate
Fname Minit Lname Ssn Bdate Sex Address Salary SuperSsn DNo
Essn Dep_name Sex Bdate Relationship
04/10/23 12
ERSumitha C.H, SFIT
![Page 13: 1/5/20141 Sumitha C.H, SFIT. ER to relations model mapping – review EER to Relations model mapping Summary 1/5/20142Sumitha C.H, SFIT](https://reader036.vdocuments.us/reader036/viewer/2022062511/55140236550346e2488b4976/html5/thumbnails/13.jpg)
Step 5: Mapping of Binary M:N Relationship Types.
For each M:N relationship type, create a new relation S to represent the relationship.
Include as foreign key attributes in S the primary keys of the entities on each side of the relationship;
the combination of the two primary keys will form the primary key of S.
Also include any simple attributes of the M:N relationship type as attributes of S.
04/10/23 13Sumitha C.H, SFIT
![Page 14: 1/5/20141 Sumitha C.H, SFIT. ER to relations model mapping – review EER to Relations model mapping Summary 1/5/20142Sumitha C.H, SFIT](https://reader036.vdocuments.us/reader036/viewer/2022062511/55140236550346e2488b4976/html5/thumbnails/14.jpg)
Employee
Department
Project
Dependent
Works_On
Pname
Pnumber
PLocation
Dnum
Dname Dnumber MGrSSN MgrStartDate
Fname
Minit Lname
Ssn Bdate
Sex Address
Salary
SuperSsn
DNo
Essn Dep_name Sex Bdate Relationship
Essn Pno Hours
04/10/23 14
ER
Sumitha C.H, SFIT
![Page 15: 1/5/20141 Sumitha C.H, SFIT. ER to relations model mapping – review EER to Relations model mapping Summary 1/5/20142Sumitha C.H, SFIT](https://reader036.vdocuments.us/reader036/viewer/2022062511/55140236550346e2488b4976/html5/thumbnails/15.jpg)
Step 6: Mapping of Multivalued attributes.
For each multivalued attribute A, create a new relation.
contains an attribute corresponding to the multi-valued attribute, plus the primary key attribute of the relation that has the multi-valued attribute, K.
The primary key of R is the combination of A and K.
04/10/23 15Sumitha C.H, SFIT
![Page 16: 1/5/20141 Sumitha C.H, SFIT. ER to relations model mapping – review EER to Relations model mapping Summary 1/5/20142Sumitha C.H, SFIT](https://reader036.vdocuments.us/reader036/viewer/2022062511/55140236550346e2488b4976/html5/thumbnails/16.jpg)
Employee
Department
Project
Dependent
Works_On
Dept_Locations
Pname Pnumber PLocation Dnum
Dname Dnumber MGrSSN MgrStartDate
Fname Minit Lname Ssn Bdate Sex Address Salary SuperSsn DNo
Essn Dep_name Sex Bdate Relationship
Essn Pno Hours
Dnumber DLocation
04/10/23 16
ER
Sumitha C.H, SFIT
![Page 17: 1/5/20141 Sumitha C.H, SFIT. ER to relations model mapping – review EER to Relations model mapping Summary 1/5/20142Sumitha C.H, SFIT](https://reader036.vdocuments.us/reader036/viewer/2022062511/55140236550346e2488b4976/html5/thumbnails/17.jpg)
04/10/23 17Sumitha C.H, SFIT
![Page 18: 1/5/20141 Sumitha C.H, SFIT. ER to relations model mapping – review EER to Relations model mapping Summary 1/5/20142Sumitha C.H, SFIT](https://reader036.vdocuments.us/reader036/viewer/2022062511/55140236550346e2488b4976/html5/thumbnails/18.jpg)
Step 7: Mapping of N-ary Relationship Types. (Non-binary relationships)
For each n-ary relationship type R, where n>2, create a new relation S to represent the relationship.
Include as foreign key attributes in S the primary keys of the relations that represent the participating entities.
Also include any simple attributes of the n-ary relationship type as attributes of S.
04/10/23 18Sumitha C.H, SFIT
![Page 19: 1/5/20141 Sumitha C.H, SFIT. ER to relations model mapping – review EER to Relations model mapping Summary 1/5/20142Sumitha C.H, SFIT](https://reader036.vdocuments.us/reader036/viewer/2022062511/55140236550346e2488b4976/html5/thumbnails/19.jpg)
04/10/23 Sumitha C.H, SFIT
![Page 20: 1/5/20141 Sumitha C.H, SFIT. ER to relations model mapping – review EER to Relations model mapping Summary 1/5/20142Sumitha C.H, SFIT](https://reader036.vdocuments.us/reader036/viewer/2022062511/55140236550346e2488b4976/html5/thumbnails/20.jpg)
04/10/23 20Sumitha C.H, SFIT
![Page 21: 1/5/20141 Sumitha C.H, SFIT. ER to relations model mapping – review EER to Relations model mapping Summary 1/5/20142Sumitha C.H, SFIT](https://reader036.vdocuments.us/reader036/viewer/2022062511/55140236550346e2488b4976/html5/thumbnails/21.jpg)
Step8: Options for Mapping Specialization or Generalization.
Option 8A: Multiple relations, Super class and subclasses.
Create a relation for the super class, including the super class attributes.
Create a relation for each subclass, which includes the primary key of the super class (which acts as the foreign key) and the attributes of the subclass specialization.
This works for any specialization (partial, total, disjoint, overlapping)
04/10/23 Sumitha C.H, SFIT
![Page 22: 1/5/20141 Sumitha C.H, SFIT. ER to relations model mapping – review EER to Relations model mapping Summary 1/5/20142Sumitha C.H, SFIT](https://reader036.vdocuments.us/reader036/viewer/2022062511/55140236550346e2488b4976/html5/thumbnails/22.jpg)
04/10/23 22Sumitha C.H, SFIT
![Page 23: 1/5/20141 Sumitha C.H, SFIT. ER to relations model mapping – review EER to Relations model mapping Summary 1/5/20142Sumitha C.H, SFIT](https://reader036.vdocuments.us/reader036/viewer/2022062511/55140236550346e2488b4976/html5/thumbnails/23.jpg)
Step8: Options for Mapping Specialization or Generalization.
Option 8B: Multiple relations, Subclass relations only
Create a relation for each subclass, with the attributes of both the super class and the attributes of the subclass.
works for total specializations
04/10/23 23Sumitha C.H, SFIT
![Page 24: 1/5/20141 Sumitha C.H, SFIT. ER to relations model mapping – review EER to Relations model mapping Summary 1/5/20142Sumitha C.H, SFIT](https://reader036.vdocuments.us/reader036/viewer/2022062511/55140236550346e2488b4976/html5/thumbnails/24.jpg)
04/10/23 24Sumitha C.H, SFIT
![Page 25: 1/5/20141 Sumitha C.H, SFIT. ER to relations model mapping – review EER to Relations model mapping Summary 1/5/20142Sumitha C.H, SFIT](https://reader036.vdocuments.us/reader036/viewer/2022062511/55140236550346e2488b4976/html5/thumbnails/25.jpg)
Step8: Options for Mapping Specialization or Generalization.
Option 8C: Single relation with one type attribute.
Create a single relation, with all the attributes of the super class and all the attributes of a subclass.
Include a ‘Type’ attribute, which is the discriminating attribute which indicates which subclass the row belongs to.
This only works if the specialization is disjoint, meaning the super class entity cannot be a member of more than one subclass.
04/10/23 Sumitha C.H, SFIT
![Page 26: 1/5/20141 Sumitha C.H, SFIT. ER to relations model mapping – review EER to Relations model mapping Summary 1/5/20142Sumitha C.H, SFIT](https://reader036.vdocuments.us/reader036/viewer/2022062511/55140236550346e2488b4976/html5/thumbnails/26.jpg)
EngType
04/10/23 Sumitha C.H, SFIT
![Page 27: 1/5/20141 Sumitha C.H, SFIT. ER to relations model mapping – review EER to Relations model mapping Summary 1/5/20142Sumitha C.H, SFIT](https://reader036.vdocuments.us/reader036/viewer/2022062511/55140236550346e2488b4976/html5/thumbnails/27.jpg)
Step8: Options for Mapping Specialization or Generalization.
Option 8D: Single relation with multiple type attributes.
Create a single relation with all the attributes of the super class and all the attributes of the subclass.
Include a Boolean “Type” attribute for each subclass, which indicates whether the row belongs to that subclass.
This works with overlapping specializations, to indicate if the super class entity belongs to more than one subclass.
04/10/23 27Sumitha C.H, SFIT
![Page 28: 1/5/20141 Sumitha C.H, SFIT. ER to relations model mapping – review EER to Relations model mapping Summary 1/5/20142Sumitha C.H, SFIT](https://reader036.vdocuments.us/reader036/viewer/2022062511/55140236550346e2488b4976/html5/thumbnails/28.jpg)
04/10/23 28Sumitha C.H, SFIT
![Page 29: 1/5/20141 Sumitha C.H, SFIT. ER to relations model mapping – review EER to Relations model mapping Summary 1/5/20142Sumitha C.H, SFIT](https://reader036.vdocuments.us/reader036/viewer/2022062511/55140236550346e2488b4976/html5/thumbnails/29.jpg)
Step 9: Mapping of Union Types (Categories).
For mapping a category whose defining super classes have different keys, you can specify a new key attribute, called a surrogate key, when creating a relation to correspond to the category.
Then create a relation for each category, which includes the attributes of the category, and the surrogate key, which acts as the foreign key.
04/10/23 Sumitha C.H, SFIT
![Page 30: 1/5/20141 Sumitha C.H, SFIT. ER to relations model mapping – review EER to Relations model mapping Summary 1/5/20142Sumitha C.H, SFIT](https://reader036.vdocuments.us/reader036/viewer/2022062511/55140236550346e2488b4976/html5/thumbnails/30.jpg)
04/10/23 Sumitha C.H, SFIT
![Page 31: 1/5/20141 Sumitha C.H, SFIT. ER to relations model mapping – review EER to Relations model mapping Summary 1/5/20142Sumitha C.H, SFIT](https://reader036.vdocuments.us/reader036/viewer/2022062511/55140236550346e2488b4976/html5/thumbnails/31.jpg)
OwnerId
CYear
04/10/23 31Sumitha C.H, SFIT
![Page 32: 1/5/20141 Sumitha C.H, SFIT. ER to relations model mapping – review EER to Relations model mapping Summary 1/5/20142Sumitha C.H, SFIT](https://reader036.vdocuments.us/reader036/viewer/2022062511/55140236550346e2488b4976/html5/thumbnails/32.jpg)
THANK YOU !!!
04/10/23 32Sumitha C.H, SFIT