Subject | General questions |
---|---|
Author | Nico Callewaert |
Post date | 2002-11-05T21:52:36Z |
Hi,
A few days ago, I had a visit from mr. consultant again :-)
He analyzed the database and made a report of it, here are the
remarks that I would like to have a second opinion of.
1) Don't use triggers and stored procedures, all the DB logic should
exist in your application ?
For me I thought good designers use the full power of the DBMS
engine ?
2) A primary key should not have any meaning related to the data in
the table. So, that means all primary keys of all tables should be
build up out of generators.
The primary key of my customers table is the customer no. Is that
wrong ??
Thaks for comments, Nico
A few days ago, I had a visit from mr. consultant again :-)
He analyzed the database and made a report of it, here are the
remarks that I would like to have a second opinion of.
1) Don't use triggers and stored procedures, all the DB logic should
exist in your application ?
For me I thought good designers use the full power of the DBMS
engine ?
2) A primary key should not have any meaning related to the data in
the table. So, that means all primary keys of all tables should be
build up out of generators.
The primary key of my customers table is the customer no. Is that
wrong ??
Thaks for comments, Nico