| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> Re: The fable of DEMETRIUS, CONSTRAINTICUS, and AUTOMATICUS
Kenneth Downs <firstinit.lastname_at_lastnameplusfam.net> wrote:
>Gene Wirchenko wrote:
>
>>>>
>>>> The complex rule is:
>>>> An employee may only book time (via a timesheet_line) to a task on a
>>>> project to which the employee is assigned on ts_date, and where the
>>>> billable_flag on the emp_proj_assignment matches that of the task.
>>>> (The trouble with complex rule examples is they are so, well, complex!)
>>>
>>>Well, as long as we are going by memory and experience, here is mine:
>>>
>>>(drumroll......)
>>>
>>>Constraints such as these are always abandoned in real life. A cowboy
>> ^^^^^^
>> Prove it.
>
>Once somebody asks me to "prove" a statement from personal experience, I can
>sense the thread coming to an end...
You said "always". It is up to you to prove your claims. "always" is a much stronger statement than "IME".
[snip]
>> What is wrong with assigning the worker to the project, then
>> entering his time?
>>
>> Can you answer the constraint question?
>I did. But I'll try again.
I understand your case, but it is inapplicable to the problem specified. If an employee is not assigned to a project, then assign him to it.
[case snipped]
Sincerely,
Gene Wirchenko
Computerese Irregular Verb Conjugation:
I have preferences.
You have biases.
He/She has prejudices.
Received on Tue Oct 19 2004 - 19:58:25 CDT
![]() |
![]() |