I disagree with the first one. But I suppose he just wants to separate the
backend from the application. Where does he stand on 3 tier work? BUsiness
logic is always (supposedly) separated from the application and the database
and placed in the middle tier from my reading.

I agree to the second. I always use a non data related primary key

Alan
-----Original Message-----
From: Nico Callewaert [mailto:nico-callewaert@...]
Sent: Wednesday, 6 November 2002 8:53
To: ib-support@yahoogroups.com
Subject: [ib-support] General questions


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


Yahoo! Groups Sponsor
ADVERTISEMENT




To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]