Dimitris Papageorgiou Wrote:
-------------------------------------------------------
> Peter Brawley Wrote:
> --------------------------------------------------
> -----
> > dates:times is 1:many
>
> >
> > dates(date date pk)
> >
> > times(time time pk)
>
> I am going to focus on the above as some questions
> arise.
>
> First of all the above design...with 2
> tables...comes in contrast with this
>
http://www.artfulsoftware.com/infotree/qrytip.php?
> id=98 where there is one dates table(with 2
> columns).
>
> Second.I assume the times table stores the format
> like this:12:00:00 and it has one column...time.
>
> How am I going to connect these two...don't we
> need additional columns.Just show me an example to
> understand better...
Will there be a foreign key between the dates and the times table?