Tag Info

New answers tagged


We have X (A, B, D, E, F, G, H, J) with A and B as primary key Y (K, L, M, N, O, P, Q, R) with K and L as primary key With functional dependencies: A -> G, H B -> D, E, F E -> F H -> G L -> N, O, P, Q N -> Q 2NF Normalization R1((A,B) (PK), J) R2(A (PK) ,G,H) R3(B (PK) ,D,E,F) R4((K,L) (PK), M,R) R5(L (PK) ,N,O,P,Q) 3NF ...


You are being asked to engage in reverse engineering. Reverse engineering is often done in the case of legacy systems, in order to find out what goals the original designers might have been pursuing. It's really an iffy proposition, nevertheless. You best handle is the foreign key constraints. These reveal the FDs, presumably. Also, you can presume that ...

Top 50 recent answers are included