|
In this first step, all strong entity sets are transformed into the relational database schema. For subclasses use rule 8.
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::
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)