Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Design of database table and PK update Expand / Collapse
Posted Tuesday, March 19, 2013 6:05 PM


Group: General Forum Members
Last Login: Friday, October 21, 2016 4:12 PM
Points: 1,975, Visits: 3,706
We are creating an address database to maintain student address info.

I have two tables like this :

The address table is a master table that holds all addresses. The studHomeAddress table will hold all students and their address- the addressID comes from the master address table. The primary key of the Address table is Address ID, the PK for studHomeAddress table is studentID and AddressID,

we are going to have a screen for user to add or edit for each of the two tables.

They can add and edit records, for both of the tables.

For the first table Address, I think it is no problem. For the second table, if we want to change the address of the student to another one, then the AddressID will be changed for this record, but it is the PK, the PK for the row will be changed. Is that an OK design?


Post #1432951
Posted Tuesday, March 19, 2013 6:11 PM


Group: General Forum Members
Last Login: Friday, April 29, 2016 8:08 AM
Points: 2,934, Visits: 5,473
I guess your StudentAddress table is a link table between Address and Student tables, right?
If so, when you edit the link you better delete and insert "link" rows if they change, not update them.

"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!"
(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help
Post #1432954
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse