On 28/08/03 13:29 +0530, Kamlesh Parmar wrote: <snip> > System Requirement: > 1. It will be mainly a small 3000 to 5000 record database with student details What details? Does your data need foreign keys? Do you need to validate entered data? Do you need stored procedures? Views?
> 2. As of now, main application of it is to generate exam grade reports... > 3. And it should be able to give concise & well formatted reports, which > could be printed on ordinary printers Sounds like a call for TeX, and possibly Perl. A single batch job can do this automatically. Pull the data out of the database, format it in TeX, convert to PDF, send to printer. > 4. The periodic backup of records, if it can be integrated in automation > system, rather than relying on OS level backup. mysqldump, pg_dump > > According to me, there are three main parts of the system, > > 1) Data Entry of records > 2) Algorithm to generate reports based on schools grading logic > 3) Report Generation & Printing > > My View > * 1st & 3rd part functions should be extremely user friendly. Depends on the users :). Have a few simple forms for data entry. Single button job to generate and batch print all the reports in a single shot. Optional preview of a report? > * Business logic should be isolated into module of its own, and tightly > secured. (I don't know how?) Yikes! Do as much data integrity stuff as you can in the backend. Business logic is in a server which sits between the database and the frontend user application. > * Report generation will be multilingual (English, Gujarati), so better > printing support. I don't know if TeX has Gujarati fonts, but I guess it does. > Now, > > 1) If at all LAMP is feasible? If yes, how can LAMP setup be utilized? Personally, Linux, Perl, PostgreSQL, Tk and perhaps TCl/Python. > 2) Application should be Desktop based or web based? Three tier, desktop clients. Devdas Bhagat -- http://mm.ilug-bom.org.in/mailman/listinfo/linuxers
