Help needed for Alternate Kye
From: <sangs5_at_my-deja.com>
Date: Fri, 20 Oct 2000 04:11:16 GMT
Message-ID: <8sogl0$a1f$1_at_nnrp1.deja.com>
Date: Fri, 20 Oct 2000 04:11:16 GMT
Message-ID: <8sogl0$a1f$1_at_nnrp1.deja.com>
Hi..
I am in the process of learning Data modeling and Data Desogining. I would like to know how to identify an alternate key. To me any candiate key which is not selected to be a primary key is an alternate key. I have a sample table called as Order. It has Order No, Cust no, Order Date, Order Cost. Here Order No is the primary key. Customer No is the foreign key. Should I consider Order Date and Order Cost as alternate keys? I request for some assistance.
Bye
Sangeetha
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Fri Oct 20 2000 - 06:11:16 CEST