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.