Relationship and tables questions...

[Ivan]

Hi I created a databse system but i have a problem figuring out how to
create some tables / relationships....

The part of the systems that i am having problems with is the
following i have a person (person table) that a specific date & time
might be busy / available / tentative.

I tried to create a different table for date and time so that i can
define the times 01-24 and then i can reuse them.

But i am having trouble thinging the relationship / tables and how
this can happend ..

one person can be busy / available / tentative at many dates but busy
availble tentative at only one time...

I am confused ;-(

I am also confused about the contents of the tables.i think that date
must have date(primary key) and person foreign key :e.g 12/12/2009 .
time should have time (primary key) and date foreign key..
Please help me.. ;-)

[Dominic Vella]

I'd default that a person is available unless otherwise stated
I'd set my tables as follows:

tblPerson
person_id Autonumber
person_name Text

tblAppointments
appointment_id Autonumber
appointment_type Number (byte, 1=Tentative;2=Busy)
appointment_start Date/Time
appointment_end Date/Time
appointment_person_id Number (FK to tblPerson.person_id)

I hope that'll get you started.
Dominic

"Ivan" <iv*************@gmail.comwrote in message
news:71**********************************@y5g2000h sf.googlegroups.com...

Hi I created a databse system but i have a problem figuring out how to
create some tables / relationships....

The part of the systems that i am having problems with is the
following i have a person (person table) that a specific date & time
might be busy / available / tentative.

I tried to create a different table for date and time so that i can
define the times 01-24 and then i can reuse them.

But i am having trouble thinging the relationship / tables and how
this can happend ..

one person can be busy / available / tentative at many dates but busy
availble tentative at only one time...

I am confused ;-(

I am also confused about the contents of the tables.i think that date
must have date(primary key) and person foreign key :e.g 12/12/2009 .
time should have time (primary key) and date foreign key..
Please help me.. ;-)