PDA

View Full Version : relational database issue



needhelp26
09-17-2004, 01:03 AM
I have two tables, dept and std. Database specs:

dept table:

d_id
d_loc
d_name

d_id: primary key
data type: autonumber

std table:

s_ssn
s_lastname
s_firstname
s_addr
s_city
s_zip
s_state
d_id

s_ssn: primary key
d_id: foreign key
data type for d_id: autonumber
data type for s_ssn: text

As you see, I have dept's primary key connected to std's table as foreign key and formed the relationship between the tables.

Can someone please tell whether whatever I have done so far is right? and If I want to query selecting fields from both tables, will it work? I am not sure whether my implemention is right? Please someone confirm. thanks.

Roelf
09-17-2004, 07:34 AM
it will work