Re: Design approaches about primary key

From: Peter Connolly <peter_at_alum.wpi.edu>
Date: 23 Dec 2003 06:04:36 -0800
Message-ID: <39fde041.0312230604.9bc4c1d@posting.google.com>

joe.celko_at_northface.edu (--CELKO--) wrote in message news:<a264e7ea.0312191619.47455886_at_posting.google.com>...

> That is what ON UPDATE CASCADE does for you automatically -- if you
> designed a database instead of a file in SQL. And what the heck are
> "detail table" and "master table"? I remember such terminology from
> an old Network database and sequential tape file systems, but NEVER in
> a relational database.

Detail table and master table are terms used to describe a set of tables where the detail is dependent on the master and the detail table provides more detailed information about the master. For example, if you have an "order" table (master) and an "order_detail" table (detail). The order table would contain the date, order_no, etc and the order_detail table would contain the line items and individual prices.

-Peter Received on Tue Dec 23 2003 - 08:04:36 CST