I Content: Database system implementation (Choose one of the following subjects or other topics)

Subject 1: Students’ information management system

Subject 2: Teaching management system

Subject 3: Salary management system

II Objects and requirements

1. Objects

Students should

1) master high-level programming language of Delphi with basic knowledge and programming skills;

2) master the basic idea of structured and methods of object-oriented programming;

3) be skillfully at Delphi components, be able to program, compile and distribute applications;

4) master the procedure of large scale application development.

2. Requirements

Basic Requirements:

Students should

1) be able to present the functional block diagram of the system;

2) be able to draw the system data flow chart;

3) design the database and present the structure of the database table;

4) construct friendly interface;

5) realize the following functions: information record, insertion, removing, rewriting, inquiring and ranking;

6) realize the function of output and display of particular record (like print report forms);

7) pay attention to utility and security of the program;

8) keep designing record (for future reference, but also for the preparation of design instruction);

9) be able to present the following documents: design instruction (appendix: format and requirement of instruction), source programming (compliable and functional) and other relative documents.

Advanced Requirements:

Based on the achievement of basic requirements, students could challenge themselves with advanced requirements, such as interface landscaping, extensions, etc.

III System functional requirements (if the subjects are chosen from the given topics)

Subject 1: Students information management system

The main function of this system is collecting personal information of students and provides it to tutors. Other functions are as following:

(1)Input of students’ personal information. The personal information includes student number, name, gender, date of birth, place of birth, native towns, etc.

(2)Input of students’ turnover information. The turnover information includes transformation of departments, suspension, resumption, quit and graduation;

(3)Input of students’ reward and punishment;

(4)Inquiry and rewriting of students’ personal information, including turnover, reward and punishment information.

Subject 2: Teaching management system

The main functions of this system are as following:

(1)Setting of the course, including course information addition, removing, inquiry and rewriting;

(2)Arrangement of course schedule and classroom, print and output of course list;

(3)Print and output of student’s personal class schedule;

(4)Print and output of class roster and final grades;

(5)Inquiry of grades.

Subject 3: Salary management system

The main functions of this system are as following:

(1)Setting of employees’ basic salary;

(2)Setting of bonus and benefits;

(3)Adjustment of net pay calculation;

(4)Calculation of net pay according to attendance record;

(5)Input of the salary record.

IV Solution

1. Analyze the requirements, clarify the system functions, present the functional block diagram of the system;

2. Analyze system relation, find out the data flow and draw the flow chart;

3. Design database according to the flow chart;

4. Construct functional modules, realize the corresponding application;

5. Compile and distribute program.

V Schedule

Design work is arranged in two weeks as four stages:

1. Analysis and designing: Students research issues independently under the guidance of tutors. They should clarify the design requirements, find out implementation methods. Their work includes requirements analysis, overall designing and detailed designing. This stage is carried out at the 1^st-2^nd days.

2. Coding and debugging: Students code and debug with Delphi programming language according to design analysis. This stage is carried out at the 3^rd-7^th days.

3. Conclusion and reporting: Students conclude their work. The design work instruction should be presented with requirement analysis, overall designing, detailed designing, coding and testing results. This stage is carried out at the 8^th-9^thdays.

4. Assessment: this stage is carried out at the 10^thday.

VI Report of design work

The report of design work includes requirement analysis, system designing, database designing, coding (key codes), testing procedure and content, conclusion and reference. Report without those contents will be remarked as disqualified.

VII Reference

[1] Delphi 7, From entry to the master

[2] Delphi 6 database examples navigation systems development, Chen yulong, He Xuhong, Posts & Telecom Press

[3] Pristine examples of Delphi Systems Development, Posts & Telecom Press