GITTA-Logo
PDF Version of this document Search Help Glossary

Lesson Navigation IconRelational database model

Unit Navigation IconConcepts

Unit Navigation IconTransforming ER-schema

LO Navigation IconERM concepts

LO Navigation IconRule 1

LO Navigation IconRule 2

LO Navigation IconRule 3

LO Navigation IconRule 4

LO Navigation IconRule 5

LO Navigation IconRule 6

LO Navigation IconRule 7

LO Navigation IconRule 8

LO Navigation IconUsing the 8 rules

LO Navigation IconExercise transformation

Unit Navigation IconData integrity

Unit Navigation IconNormalization

Unit Navigation IconSummary

Unit Navigation IconRecommended Reading

Unit Navigation IconGlossary

Unit Navigation IconBibliography

Unit Navigation IconMetadata


GITTA/CartouCHe news:


Go to previous page Go to next page

Rule 7

If in rule 1 multivalued attributes are encountered, they are transformed into separate relational schemes according to this rule.

Definition rule 7

Define for each multivalued attribute A a new relational scheme R' which also contains this attribute A and the primary key of the according relational scheme R. Together they form the primary key for R'.

In this example you can see the application of rule 7:

RuleRegel 7

A new relational scheme is created for the multivalued attribute TelNo containing TelNo as attribute:

ChiefTelNo(TelNo)

The primary key of this multivalued attribute connected to the relational scheme is used as foreign key in the new scheme:

ChiefTelNo(ChiefEditor_PersNo, TelNo)

The foreign key and the attribute together form the primary key for this new relational scheme:

ChiefTelNo( ChiefEditor_PersNo, TelNo)

Top Go to previous page Go to next page