Re: Relationships. Does anyone use them?

salad <oil@xxxxxxxxxxx> wrote in
news:UrS4g.7411$BS2.3663@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx:

Sounds like screwed up developing to me. In reality, no user
actually needs to use forms for data entry. They can simply pound
in data into the tables. What happens then is that there is no
data verification and that's where problems occur.

Well, consider this scenario then:

An application is built to enter data into a database. There is no
RI in the database.

Later, for different users, a different application is build for
manipulating the same database.

Now, consider that data integrity was enforced in the first
application's design, but to insure data integrity, the developer of
the second app has to re-implement the same features in the new
front end application.

This is extra work that engine-level RI enforcement makes completely
unnecesary.

Secondly, if the second developer misunderstands the data structure,
she may introduce invalid data that works fine in *her* application,
but that breaks the original application.

Using RI insures that any application running against the same
database will be completely unable to write or edit invalid data.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
.

Relevant Pages

  • Re: Splitting and archiving a large database
    ... physical databases is that you lose the enforcement of referential integrity ... MSDE will not only allow you to develop your database, ... it's limitations, the migration will be painless, except for the cost of SQL ...
    (microsoft.public.access.tablesdbdesign)
  • Re: "Business Logic / Rules should never be in the database or stored procedures"
    ... you want enforcement of business rules in the database ... because there is where all the business logic resides. ... constraints are enforced in the database (uniqueness, NOT NULL, ... You all seem to view stored procedures as "part of the database" because ...
    (comp.databases.oracle.misc)
  • RE: TextBox easy lost focus
    ... This TextBox is connected with the field in database. ... LostFocus event to this TextBox. ... database update occurs and give feedback on any invalid data found. ...
    (microsoft.public.dotnet.framework.windowsforms.controls)
  • Re: Nested Database Results
    ... Microsoft MVP - FrontPage ... > I have a form with several fields that are fed from database results. ... > where people are updating records with invalid data for one of the ... > valid alternatives to the data currently stored in the record. ...
    (microsoft.public.frontpage.programming)
  • Nested Database Results
    ... I have a form with several fields that are fed from database results. ... people are updating records with invalid data for one of the fields. ... database to allow users to pick from a list of valid alternatives to the ... Prev by Date: ...
    (microsoft.public.frontpage.programming)