Re: Classic Problem - Side by Side Blocks
Date: Sun, 13 Dec 1992 02:55:49 GMT
Message-ID: <Bz6G51.6xI_at_mach1.wlu.ca>
Jennifer Farnham (v045100_at_otis1.stortek.com) wrote:
: Block A has: Block B has:
: Name Age Sex
:
: Jenny 20 F
: Bob 30 M
: Sue 40 F
:
: I don't want to put Sex as a non-database field in
: Block A, (i've got a reason for this).
: Since i'm not real familiar with 3.0, I thought there
: might be something out there I'm missing...
Hi Jenny,
My e-mail reply to you bounced, so I am posting my reply.
Hopefully, this application is not so far into the design stage that it cannot be changed. I see a one-to-one relation between NAME and SEX, and such a relationship is usually an indication that the two attributes belong in the same entity, i.e. in the same table. Why are they not in the same table? If they were, you wouldn't have this problem.
-- Niels Ejvind Andersen eandersn_at_mach2.wlu.ca / 70511.2302_at_compuserve.com Information Systems Phone: (519) 884-1970 x2760 Wilfrid Laurier University Fax: (519) 886-9351 Waterloo, ON N2L 3C5 Canada ... VFR NC4 -- Niels Ejvind Andersen eandersn_at_mach2.wlu.ca / 70511.2302_at_compuserve.com Information Systems Phone: (519) 884-1970 x2760 Wilfrid Laurier University Fax: (519) 886-9351 Waterloo, ON N2L 3C5 Canada ... VFR NC4Received on Sun Dec 13 1992 - 03:55:49 CET