RDB with Surrogate pkeys:

• A GEN Example: CS Dept View of SIS Database ERD:

• Entity: alternate (old pkey): surrogate (name = value):

• Dept deptNo = 91 DEid = DE000001

• Course courseNo = 91+522 COid = CO000220

• Section sectNo= 91+522+201 SEid = SE002601

Department DE

DE000001

91

Course CO

CO000220

DE000001

522

Section SE

SE002601

CO000220

201

A Persistence Requirement (WHY?):

Each table has a mnemonic abbreviation (DE,CO,SE) encoded into the pkey value of its objects.

(Note that the fkey only references the immediate ancestor or container of an object or tuple.)

Previous slide

Next slide

Back to first slide

View graphic version