When normalising to 3NF, can you migrate compound keys and/or foreign keys to other tables? (third normal form)
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?
• 463 views
•
link
written
by
jessewhite8077 •
0 answers
No answers yet.
Log in to answer this question.
More posts like this
-
Why Does the Same Compound Have Different CIDs in PubChem?
written by Elka •
-
So how would I tell the difference between data structures and abstract data types?
written by jessewhite8077 •
-
How Do I Convert a Binary Tree to a Double Threaded Binary Tree?
written by jessewhite8077 •
-
construction of a database of bacterial genomic and protein sequences
written by Debut •
-
16S sequencing analysis: from fasta to otu to PCA&Heatmap
written by shlomsauce •
-
create a mysql table with repetitive key values
written by ahmedakhokhar
-
Mapping Human metabolite in Pathways
written by Amk
-
Designing a relational database
written by int11ap1
-
Mapping From Ensembl Main Database Schema To Ensembl Mart
written by User 6659 •
-
The 'Bin' Column Used By Sam, Ucsc...
written by Pierre Lindenbaum
