|
|
Posted by --CELKO-- on 11/06/88 11:29
>> All we know is that Promised Oyster needs is a temporary table of some sort that gives him all dates in an interval. <<
No. We have experence and have seen this before. This is like a
doctor who treats every pain with a dose of drugs versus a doctor who
actually diagnoses the problem and looks for a long-term solution.
>> The table with all the dates puts no attributes on the dates, and is only a help table for some operations. The other table lists only holidays. <<
Would you also design a schema with a table for male employees and one
for female employees? That wouild be splitting the entit on the gender
attribute. The holidays and non-holidays are still days. The holiday
attribute can change by decree or by definition (Easter, Chinese New
Years or other lunar-solar calendar holidays). Nobody can stop time or
skip a day.
As a simple test, when you have a printed calendar, do you put the
holidays on the pages of the calendar or on a separate piece of paper
on the other side fo the room? Can a holiday exist without a date
(ii.e. Can I put Christmas in a bottle by itself and pull it out as
needed)?
Navigation:
[Reply to this message]
|