GITTA-Logo
PDF Version of this document Search Help Glossary

Lesson Navigation IconRelationales Datenmodell

Unit Navigation IconKonzepte

Unit Navigation IconAbbildung 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 IconAnwendung der Regeln

LO Navigation IconUmwandlungsübung

Unit Navigation IconData integrity

Unit Navigation IconNormalisierung

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 1

In this first step, all strong entity sets are transformed into the relational database schema. For subclasses use rule 8.

Definition rule 1

For each strong entity set G define a relational scheme R with the entity properties as attributes A. For multivalued attributes use rule 7. Define the primary key (identifier).

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

Rule 1

A strong entity set is taken for the creation of the relation:

Customer

All entity properties are used as attributes for the relation:

Customer (CustomerNo, FirstName, LastName, Street, StreetNo)

The primary key (or identifier) is defined. Here it is the attribute CustomerNo:

Customer (CustomerNo, FirstName, LastName, Street, StreetNo)

Top Go to previous page Go to next page