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 6

In this step all relationships of order n are transformed into the relational database scheme. This happens according to rule 5.

Definition rule 6

For all n-ary relationship types (n>2) use rule 5: Create a new relational scheme R and use the primary keys of all connected relational schemes (S, T, etc.) as foreign keys. Together they form the primary key for this new relational scheme R.

See the example of rule 5.

Top Go to previous page Go to next page