急，一个关于数据库的project。

liguokai 2003-10-23 05:29:29

学校给我了一个关于数据库的project.
现在我学的不多，很多还搞不懂。希望得到高人的指点。

这个数据库应该用什么开发比较好？
是MS-SQL SERVER ,MYSQL,ACCESS?
用JAVA+ACCESS可以实现吗？（因为现在只会JAVA）。

ACCESS可以实现多用户吗？
谢谢了，搞定后一定散分，如果分不够单独发个帖散分。
急！

-----------------------
A primary school (for childeren of the age of 6 to 12 years) has the following problem :

The school has a lot of information (=records) on every schoolboy/schoolgirl :
* age, birthday, address, name , profession of parents, family situation, etc etc
* results for all examens
* results for all small tests and regular evaluations
* results of "behaviour"
* remarks of the teacher,
* remarks of the social assistant
* etc etc etc

For every scholar there is a floppy diskette.

At the moment : some 300 scholars -----> some 300 floppy diskettes...!

Problems:
-------------
1. If anyone (teacher, administration, ...) would like to update the records for a certain scholar then
he/she has to look for this diskette. In most cases, this diskette will be on the desk of another colleague, but who ?

2. from time to time the parents can have a meeting at the school to discuss about their child.
Once again : where is the floppy....?

3. No automatic report generator

3. During the examen period a lot of persons would like to update the records
----> bottleneck....

4. Backup problems…

Proposal for solution
-----------------------------
The school has a lot of computers (at least one in every classroom) and all are connected on a local network + Internet.

Create one general central database on a server computer. From any remote computer any user (with the correct authority) should be able to updata/read/modify the central database.

The database can be consulted at any time by a lot of people at the same time.

The staf should be able to remotely (=from home) consult the database (via internet ... ftp .... whatsoever....)

Report generation is a nice option…

...全文