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 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