16 Jun
2018
16 Jun
'18
4:53 a.m.
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, mbsoftwaresolutions@mbsoftwaresolutions.com 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!