Re: tracking shipments, inventory

From: -CELKO- <jcelko212_at_earthlink.net>
Date: 23 Dec 2004 07:35:04 -0800
Message-ID: <1103816103.977166.198250_at_z14g2000cwz.googlegroups.com>

You might want to look at a book on temporal queries in SQL by Rick Snodgrass, which you can get in PDF at his website at the University of Arizona.

Can you explain why you have separate tables for each transfer? Isn't every shipment logically made up of a set of items, a source and a destination? Add some transformation constraints, of course.

Also, in RDBMS, rows are not records, columns are not fields and tables are not files. Thre are no parent and child tables (those are older navigational database terms); we have referenced and referencing tables. Received on Thu Dec 23 2004 - 16:35:04 CET

This message: [ Message body ]
Next message: Alan: "Re: tracking shipments, inventory"
Previous message: Wojtek Narczynski: "Timestamp Ordering granularity"
In reply to: Jeme: "tracking shipments, inventory"
Next in thread: ak_tiredofspam_at_yahoo.com: "Re: tracking shipments, inventory"
Reply: Alan: "Re: tracking shipments, inventory"
Reply: Jeme: "Re: tracking shipments, inventory"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message