Simple attributes E R attributes map directly onto the relation Composite

Simple attributes e r attributes map directly onto

This preview shows page 13 - 25 out of 71 pages.

Simple attributes : E - R attributes map directly onto the relation Composite attributes : Use only their simple, component attributes Multivalued Attribute : Becomes a separate relation with a foreign key taken from the superior entity
Image of page 13
(a) CUSTOMER entity type with simple attributes Figure 4-8 Mapping a regular entity (b) CUSTOMER relation Transforming EER Diagrams into Relations : Entities Simple attributes
Image of page 14
(a) CUSTOMER entity type with composite attribute Figure 4-9 Mapping a composite attribute (b) CUSTOMER relation with address detail Transforming EER Diagrams into Relations : Entities Composite attributes
Image of page 15