G
Guest
Tables:
=====
User
------
ID
Name
NationID
StateID
Nation
-------
ID
Nation
State
-----
ID
Question:
Should an asp database solution enfore referential integrity on control
tables like:
- country
- State
....in a primary Website User Table [Users]?
Or,
Should these be hard-coded into the web page and simply inserted into the
Piimary [User] Table:
User
----
ID
Name
Nation
State
Why do I ask?
----------------
By enforcing a relationship between the tables I am creating extra work for
future stored procedures and allow for possible errors when inserting a new
registrant
into my system if for some reason one of the control table values was
deleted without cascading it to the Primary?
Appreciate any advice on this scenario...
Thanks
Jason
=====
User
------
ID
Name
NationID
StateID
Nation
-------
ID
Nation
State
-----
ID
Question:
Should an asp database solution enfore referential integrity on control
tables like:
- country
- State
....in a primary Website User Table [Users]?
Or,
Should these be hard-coded into the web page and simply inserted into the
Piimary [User] Table:
User
----
ID
Name
Nation
State
Why do I ask?
----------------
By enforcing a relationship between the tables I am creating extra work for
future stored procedures and allow for possible errors when inserting a new
registrant
into my system if for some reason one of the control table values was
deleted without cascading it to the Primary?
Appreciate any advice on this scenario...
Thanks
Jason