Re: Plea for help - Normalisation Problem
From: billysielu <member23275_at_dbforums.com>
Date: Wed, 22 Jan 2003 09:42:18 +0000
Message-ID: <2421482.1043228538_at_dbforums.com>
Date: Wed, 22 Jan 2003 09:42:18 +0000
Message-ID: <2421482.1043228538_at_dbforums.com>
CDs Borrowed(#LoanNo, #cdID)
CDs Bought(#cdID, releaseID, DateBought)
I'm just learning this stuff but I know that someone can buy + borrow the same cd more than once. You should include the date in the composite key.
-Mike
-admin_at_billysielu.co.uk
--
Posted via http://dbforums.com
Received on Wed Jan 22 2003 - 10:42:18 CET