hia
er, cud u suggest any gui tool (free) for windoz postgresql clients ??
-sdg-
On Fri, 2002-06-21 at 00:21, Amitabh Das wrote:
>
> ----- Original Message -----
> From: "Sayamindu Dasgupta" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, June 20, 2002 9:19 PM
> Subject: [ilug-cal] trouble in my school - somebody please help
>
>
> >
> > Hia,
> > today, i was requested by some of my friends to make them do their compu
> > sb lessons on non M$ things 'n they have somehow managed to convince the
> > teacher in charge who has said that if i can supply the right software,
> > he will allow us to not to work on Access
> > now the problem is that i know very little regarding this db stuff,
> > except for the things absolutely required for PHP
> > (pctelcompdb.sourceforge.net)
> NOT NECESSARLY ;-)
> >
> > basically, here's what we are supposed to learn
> >
> > Theory
> > ======
> > Record structure File organisation and Acess methods
> > Concept of keys for data retrieval
> > Physical storage organisation
> > Basic concept of Relation db
> > Normalisation (up to 3nf)
> > Intro to SQL (exposure to DDL, DML, DCL)
> > Query proccessing and report generation
>
> The theory part can be handled by the book of CJ Dates (introduction of
> DBMS) however the books related to IGNOU esp for CS-05 will be more to the
> point
>
> > Practo
> > ======
> > Interaction with a client/server RDBMS package
> > Application Project and Implementation using Access or RDBMS package
> > PPT presentation of Project Report :(
> >
>
> > So, now the question is, what software do I use here??
>
> The best for this is PostgreSQL available with any linux distro, it is
> basically an OODBMS which can handle all the stuff like foriegn key, nested
> query etc. MySQL will do but nested queries and strict following of foriegn
> key is not possible.
>
> > I have 2 (that can be extended to 3) Linux boxes in the lab at this
> > moment (on a Celeron and the other a P III - all with 64 megs) and there
> > are 21 usable winblows boxes in the network, which will be, I guess, the
> > clients.
> > What do I use??
> > Please help
> > -sdg-
> >
> > PS: For some reasons (probably since I always sleep in the last bench,
> > the teacher has assumed that I know a few things regarding db and he has
> > requested me to let him know of any good DBMS notes ("chota") on the net
> > - any suggestions??
> >
> The manuals provided with MySQL and PostgreSQL are very helpful at times
> also check these sites out
> http://www.cse.cuhk.edu.hk/~csc3170/
> http://www.bell-labs.com/topic/books/db-book/
>
>
> --
> To unsubscribe, send mail to [EMAIL PROTECTED] with the body
> "unsubscribe ilug-cal" and an empty subject line.
> FAQ: http://www.ilug-cal.org/help/faq_list.html
--
--
To unsubscribe, send mail to [EMAIL PROTECTED] with the body
"unsubscribe ilug-cal" and an empty subject line.
FAQ: http://www.ilug-cal.org/help/faq_list.html
