On 28/08/03 13:29 +0530, Kamlesh Parmar wrote:
1. It will be mainly a small 3000 to 5000 record database with student details
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.
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
* 1st & 3rd part functions should be extremely user friendly.
Depends on the
Have a few simple forms for data entry.
Single button job to generate and batch print all the reports in a
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
I don't know if TeX has Gujarati fonts, but I guess it does.
1) If at all LAMP is feasible? If yes, how can LAMP setup be utilized?
Linux, Perl, PostgreSQL, Tk and perhaps TCl/Python.
2) Application should be Desktop based or web based?
Three tier, desktop clients.