Search Postgresql Archives

RE : Re: database design ...

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



X-No-Archive: true
 
Thanks.  The main uses will be ..
 
1. available on www to query catalogue (open to everyone)
2 avail. from the web for teachers and students to check their library account (necessitates an account)
3. available in the library itself both on a web interface (to allow the librarian to check records, add/remove stock etc and to allow people physically present in the library to do 1 and 2 above), and on the barcode reader, for loans and returns. 
 
I've modified a .sql file already found somewhere in an install's source doc... this is it..
 
http://www.chez.com/desmondcoughlan/unix/cdi_gt.sql
 
It's not much for the moment, but any tips?

D.
 
 
 
 
 

Ben <bench@xxxxxxxxxxxxxxx> a écrit :
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.


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.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux