Subject: | Re: qbe to sql
| Date: | Wed, 25 Oct 2017 22:21:45 -0400
| From: | "Larry DiGiovanni" <nospam@nospam>
| Newsgroups: | pnews.paradox-dos
|
Bernie van't Hof wrote:
> Hard to see how your data model would change because of the presentation
> logic.
No, it shouldn't. But I've just seen a lot of denormalized tables that
result from the need to display denormalized. Days of the week is a common
example - the table has fields for each days of the week. 4GLs like Paradox
and Access were prime candidates because of the simplicity of binding a UI
form directly to a table. Developers (I use this term loosely) would often
take shortcuts when modeling the data, leading to, for example, tables with
a column for each day of the week. Not intermediate tables.
--
Larry DiGiovanni
|