When normalising to 3NF, can you migrate compound keys and/or foreign keys to other tables? (third normal form)
0
0
Entering edit mode
15 months ago

My database design is now at 3NF. Foreign keys, and in certain circumstances compound keys, are at problem.

Can you transfer compound keys and/or foreign keys to create new tables as long as the properties associated with the compound/foreign keys are not dependent on the primary key?

relational-database • 237 views
ADD COMMENT

Login before adding your answer.

Traffic: 1858 users visited in the last hour
Help About
FAQ
Access RSS
API
Stats

Use of this site constitutes acceptance of our User Agreement and Privacy Policy.

Powered by the version 2.3.6