Notifications
Clear all

Naming convention for driving key in link  


Posts: 102
(@adarsh)
Estimable Member
Joined: 10 months ago

Does DV has any recommendation on the naming convention for driving key/keys in a link table?. Also in case the driving keys consists of a BK + dependent keys(weak keys) how can we indicate that in the model.

Example, source table Agreement_Income has following structure

PK AgreementNum

PK Income_Year

PK Income_Month

CompanyCd

PartyID

Amount

(Marked in bold are the BKs)

Income_year and Income_month are dependent keys in the LINK_AGREEMENT_COMPANY_PARTY

AGREEMENT_COMPANY_PARTY_HKEY

AGREEMENT_HKEY  -- Driving Key

COMPANY_HKEY

PARTY_HKEY

Income_Year          -- Driving Key

Income_Month       -- Driving Key

LDTS

RC

 

Reply
3 Replies