You could try java w/ JDBC. This should give your course additional buzzword compliance!
Raja -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Sayamindu Dasgupta Sent: 24 June 2002 10:48 To: [EMAIL PROTECTED] Subject: Re: [ilug-cal] trouble in my school - somebody please help 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 -- 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
