On 28/08/03 13:29 +0530, Kamlesh Parmar wrote: <snip>
System Requirement:
- 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?
- As of now, main application of it is to generate exam grade reports...
- 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.
- 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,
- Data Entry of records
- Algorithm to generate reports based on schools grading logic
- 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,
- If at all LAMP is feasible? If yes, how can LAMP setup be utilized?
Personally, Linux, Perl, PostgreSQL, Tk and perhaps TCl/Python.
- Application should be Desktop based or web based?
Three tier, desktop clients.
Devdas Bhagat