Thursday, November 18, 2010

For love

Everything is pink in my eyes!
Anh ơi! nhớ anh quá :((

Wednesday, November 17, 2010

Primary School Management System

DIPLOMA IN COMPUTER STUDIES PROJECT
NUMBER: 05
Primary School Management System

Scenario
Emeral Primary School, located in the Dandenong Ranges (50km from Melbourne), Victoria Australia.  The school has offered an unique place for the educationn of the children of the area for more than 100 years, is the largest primary school and has an enrolment of 640+ pupils each years so to manage student's mark and document is a problem. Directors decide to develop an information system for solving this.

The information system must have the following requirement:
1. Teacher must log on to use the program. Accounts of teach are stored in the database.
2. Teacher can Input data, Edit data for pupil's mark and information.
3. Teacher can search information of pupil's mark and...
a. Search pupil by pupil's code.
b. Search pupil by pupil's name.
c. Search pupil by pupil's birthday.
d. Search pupil by pupil's mark.
4. Teacher can view information of pupil:
a. List all pupil's information.
b. List all pupil's mark according to each subject.
c. List all pupil's information according to each class.
5. Teacher can generate the reports as following:
a. Generate report about pupil's information. The report must display all information of pupil.
b. Generate subject's report. The report must display all information of subjects and mark for each subject.
c. Generate report for mark of each pupil and calculate average mark.
6. User can backup and recovery the database.

Project:
Sutudent has to build this information system with any programming languages:
VB.Net#, Visual Basic, Java...
The database has been normalized in 3NF as te following; it should be creadted width Microsoft Access or SQL Server.