You are supposed to design the ER using the best normal form, at least according to school textbooks! :)
On Sat, Jun 16, 2018 at 12:30 AM, <[email protected]> wrote: > (VFP9SP2 app with MySQL backend) > > Some years ago I had created a solution where I had split the main data > table into 5 separate tables, each with a 1:1 relationship. I kept the > commonly held fields in the table, and moved others off like so: >.... > On review, I think this just made more work and I should consolidate all of > these fields inside the single Job table. > > Your thoughts on either design approach? -- .~. Might, Courage, Vision. SINCERITY! / v \ 64-bit Fedora 25 Server Spin /( _ )\ http://sites.google.com/site/changmw ^ ^ May the Force and farces be with you! _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAGv=mjb3ng_bp8bb7wfvcp4ogpxkf0nnpkjrymnuffspoue...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
