Relationships?

[sirjon]

Hi,

I am just wondering if this is correct.

I have a users Table with a unique UserID and a schools table with a unique SCID

UserID and SCID are the same and related. It works of course but is this correct form?

Should SCID be a foreign key in the schools table, one that is not unique or an identity field?

Cheers,
J

----------------------------------------------------------------------------------------
A community development project in asp.net -

http://www.whatsthehampton.com/

 

[DotNetGnat]

should be something like this:

Table - Schools

SchoolID | SchoolName

here SchoolID is unique and primary key to the Schools table

Table - Users

UserID | UserName | SchoolID

here UserID should be unique and primary key
and
SchoolId is the foreign key referring to the SchoolID of table Schools

-DNG

 

[samo1997]

Hello,

You should have in the user table:
UserID primary key
SCDI foreign key

And in the School table:
SCID primary key

The relationship should be
1 (school tble) to many (user tble)