Re: database design ...

And, when coming up with the use cases you should be working with the
people who will actually be using the application. Wrt barcode
scanners, they typically just translate the barcode into a number. So,
you'll need a barcode printer to print barcodes for your ids to put on
the books.

Ben wrote:
> It depends how you plan to use it?
>
> Maybe a helpful excercise for you to go through is to come up with
> some use cases and see if you are storing all the data you'll need in
> a way that makes it easy for you to use.
>
> On Tue, 14 Nov 2006, Desmond Coughlan wrote:
>
>> X-No-Archive: true
>>
>> Hi,
>> Thanks for all the help: we have our postgreSQL server on a
>> 'backend' machine, and the client on a webserver.
>>
>> The application I want to develop is a school library, and as this
>> is new to me, I come looking for ideas. Here's what I've done: on
>> the backend, two users (in addition to 'pgsql'): dba and 'cdi' (the
>> name of the library, as in the _premises_ where the library is
>> located). I create a database 'library', owned by dba, but with cdi
>> having update privileges (but not 'drop table' etc).
>>
>> 'library' has four tables...
>>
>> 1. users (with user_ids, surname, first_name, dob, address etc...)
>> 2. stock (stock_id, ISBN, title...)
>> 3. loans (loan_id, stock_id [foreign key to stock_id], date_due)...
>>
>> Is there anything else that such a db would need ?
>>
>> Thanks.
>>
>> D.
>>
>>
>> ---------------------------------
>> Découvrez une nouvelle façon d'obtenir des réponses à toutes vos
>> questions ! Profitez des connaissances, des opinions et des
>> expériences des internautes sur Yahoo! Questions/Réponses.
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster

--
erik jones <erik(at)myemma(dot)com>
software development
emma(r)