Alternate keys.

From: <ssg_at_srasys.co.in>
Date: Fri, 20 Oct 2000 04:40:16 GMT
Message-ID: <8soibf$bar$1@nnrp1.deja.com>

Hi..

I am in the process of learning Data modeling and Data Designing. 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 Cosya as alternate keys? I request for some assistance.

Bye
Sangeetha

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Oct 19 2000 - 23:40:16 CDT