Re: Database Design Problem...

From: Gabriel B. Gonzalez <gabriel_at_uci.edu>
Date: 1998/03/09
Message-ID: <35038b43.1406822@news2.ibm.net>#1/1

On Mon, 09 Mar 1998 18:08:22 -0800, Jimmy <c6635500_at_comp.polyu.edu.hk> wrote:

> However, one day, a person ask me, "Why you put book_id in the table
>BOOK? book_name is unique all the time, why you create additional column
>(book_id) in table BOOK? Moreover, I don't know which book is from the

Definitely leave the design as-is. I'd never make a string a primary key, I'd never make anything the customer can see/change a primary key either. Leave the design as-is and let the person you speak of learn this lesson from experience.

gg Received on Mon Mar 09 1998 - 00:00:00 CST