----- 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
