TGWSE_GY Posted May 28, 2009 Share Posted May 28, 2009 So I am creating a UMS(User Management System) and I have the tables and fields setup. What I am wondering is if as long as my DB is in 4th normal form that if I create a relationship between say the Height column in the Profile_Appearance tbl and the HeightID in the answer_height tbl than if I do a query against the Height column in Profile_Appearance tbl than will it retrieve what is stored in the Height field of the answer_height tbl? If I need to provide more info please let me know. Thanks Quote Link to comment https://forums.phpfreaks.com/topic/160030-solved-relationships-and-foriegn-keys/ Share on other sites More sharing options...
fenway Posted June 2, 2009 Share Posted June 2, 2009 4NF? That's likely going too far.... FKs don't auto-retrieve, they just serve as constraints. Quote Link to comment https://forums.phpfreaks.com/topic/160030-solved-relationships-and-foriegn-keys/#findComment-847741 Share on other sites More sharing options...
TGWSE_GY Posted June 5, 2009 Author Share Posted June 5, 2009 I thought they were a reference to the record on the foreign table. Quote Link to comment https://forums.phpfreaks.com/topic/160030-solved-relationships-and-foriegn-keys/#findComment-849942 Share on other sites More sharing options...
fenway Posted June 7, 2009 Share Posted June 7, 2009 I thought they were a reference to the record on the foreign table. Yes, but that doesn't require a constraint per se. Quote Link to comment https://forums.phpfreaks.com/topic/160030-solved-relationships-and-foriegn-keys/#findComment-851144 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.