|
Posted by Tom on 10/11/05 23:03
Hi,
Is there a reason for using one and only one column as the key?
I find it hard to enforce the integrity of the database with this design.
for example,
let's say the [company]-[employee]-[sale] tables.
company A has an employee B.
employee B makes a sale C.
If employee B moves to another company, the sale C in the [sale] table will
move along with employee B to the new company.
This doesn't look correct to me.
<dbahooker@hotmail.com> wrote in message
news:1129059631.679988.51060@g47g2000cwa.googlegroups.com...
> always use an autonumber identity for everythign you do
>
> single-column primary key
>
Navigation:
[Reply to this message]
|