Relational Database

Reply Fri 22 Feb, 2013 02:46 am
Why should the foreign key be placed in the table that is on the many side of the one-t-many relationship and not the one side?
  • Topic Stats
  • Top Replies
  • Link to this Topic
Type: Question • Score: 0 • Views: 525 • Replies: 1
No top replies

Reply Fri 22 Feb, 2013 06:59 am
Think about the function of a primary key, and the function of a foreign key.

Primary keys are, generally, designed to connect tables together. If you've got three tables about employees, then they might all have employee number as a field, which would be the primary key for the employee table and a foreign key for, say, the job titles table.
0 Replies

Related Topics

databases - Question by angelrocksvid
  1. Forums
  2. » Relational Database
Copyright © 2021 MadLab, LLC :: Terms of Service :: Privacy Policy :: Page generated in 0.03 seconds on 07/25/2021 at 11:07:31