Re: Is this bad design ?

"Bob Badour" <bbadour_at_golden.net> wrote in message news:yt2dnQ4g-dO_MM3dRVn-uA_at_golden.net...
> "ben brugman" <ben_at_niethier.nl> wrote in message
> news:40503104$0$6567$4d4ebb8e_at_read.news.nl.uu.net...
> >
> > > >
> > > > But then the application has to be changed.
> > >
> > > No, it doesn't. A simple view serves the application well.
> > >
> > >
> >
> > If a view is used (I assume a union over both tables),
> > how does the application change the data from
> > valid to non-valid and vice versa ?
>
> By updating an attribute in the view or in the base table depending on
which
> relvars one decides to make views and which base tables.
>
>

I can not manage to change the 'valid' attribute by changing it in the view. Making the mother valid was done by creating an extra row in the solution by Fabian.
The existence of this row made the 'attribute' valid. (In a view I can not create an extra row in a valid mothers base table for a row present in the view, because it is present in the mothers table.).

In general your short answers are not very helpfull to me. Maybe our vocabulary is somewhat different, maybe some background is lacking to me, but in general I do not get what you are writing.
This often leads to misunderstanding and I do not experience this as a pleasant way to communicate.

At the occurences I missed something (or did not understand) something you short answers did not help me into the right direction.

ben brugman Received on Thu Mar 11 2004 - 21:45:30 CET