Remerciez-le!

Remerciez @Admin pour avoir partagé cet document gratuitement, de la manière la plus simple, en partageant sur les réseaux sociaux.

HANOI UNIVERSITY OF SCIENCE AND TECHNOLOGY, VIETNAM GENETIC SINGAPORE - HUT JOI

HANOI UNIVERSITY OF SCIENCE AND TECHNOLOGY, VIETNAM GENETIC SINGAPORE - HUT JOINT TRAINING PROGRAM ------------- HIGHER DIPLOMA IN COMPUTER STUDIES PROJECT 2013 (TEAM PROJECT) CANDIDATE AND MARK MANAGEMENT SYSTEM (SYSTEM GUIDE) GROUP: 22 SUPERVISOR: Msc. VU THI HAU PARTICIPANTS: NGUYEN THU HIEN (TEAM LEADER) REGNO: 0701-023-0139 HOANG THU HA REGNO: 0701-021-0159 NGUYEN THI NGOC HOA REGNO: 0701-023-0131 NGUYEN NGOC HUNG REGNO: 0701-023-0108 Copyright © Genetic Computer School, Singapore HANOI, VIET NAM – Jun 2013 Mark and candidate management system System guide HUT-Genetic Computer School Group 22 1 ACKNOWLEDGEMENT Studying in Genetic Computer School for a long time, we have been well provided and imparted for all the necessary and high valuable of professional knowledge by our lecturers. Besides, we have our faithful, careful style and creative mind in studying and working. They are very necessary characters to gain successes in the next steps of our future. Project is a very good opportunity to examine our knowledge and promote our work group ability. During executing this project, we have received a lot of helping from our guides, teachers, and study- management department. Firstly, We would like to give special thanks to Msc. Vu Thi Hau for her great moral support; guidance and feedback enable us to complete this project. Secondly, we wish to give our thankfulness to Mr. William Goh Principle of Genetic Computer School, Mr Nguyen Trung Dung – Director of Hanoi Open University, Prof. Dr. Nguyen Thi Viet Huong. Moreover, we wish to give our thankfulness to all the teachers of Genetic Computer School, who gave us the knowledge and enthusiastically helped us in studying, Because our project cannot avoid some mistakes, we wish to sympathize to professors, lecturers. To make the criticism, suggestion of our teachers is the precious experiences for our actual work in the future. In addition, we wish respectfully our teachers healthy, happiness; achieve the great results in study and career of education. Extra special thanks our parents and all of our friends in D13 for their help. We would like to thank sincerely! Group 22 HUT – Genetic Singapore International Join Program- 2013 Mark and candidate management system System guide HUT-Genetic Computer School Group 22 2 TABLE OF CONTENT CHAPTER I: SYSTEM SPECIFICATION ................................................................................ 3 1.1 SCENARIO...................................................................................................................... 3 1.2 INFRASTRUCTURE ...................................................................................................... 5 1.4 SCHEDULE OF PROJECT ............................................................................................. 6 1.5 METHOD OF INVESTIGATION ................................................................................... 7 1.6 UML (THE UNIFIED MODELING LANGUAGE) .................................................................... 9 1.6.1 USER CASE ................................................................................................................ 9 1.6.2 CLASS DIAGRAM .................................................................................................... 10 1.6.3 SEQUENCE DIAGRAM ........................................................................................... 14 1.6.4 ACTIVITY DIAGRAM ............................................................................................... 21 1.6.4.1 ADD NEW CANDIDATE ACTIVITY DIAGRAM ................................................ 22 1.6.4.2 ADD NEW MARK BY HAND ACTIVITY DIAGRAM.......................................... 23 1.6.4.3 ADD NEW MARK BY FILE ACTIVITY DIAGRAM .......................................... 24 1.7 DATABASE DESIGN (INCLUDING ERD) ................................................................ 37 1.7.1 Normalized Forms ................................................................................................. 37 CHAPTER 2: INPUT AND OUTPUT SPECIFICATION ....................................................... 43 2.1 FILE SPECIFICATION ................................................................................................... 43 2.2 RECORD SPECIFICATION ......................................................................................... 43 2.3 OUTPUT SPECIFICATION............................................................................................ 45 CHAPTER 3: PROGRAM DESIGN AND TESTING ............................................................. 46 3.1 PROGRAM DESIGN ...................................................................................................... 47 3.1.1 DECISION TABLE ................................................................................................... 47 3.1.2 UML (ACTIVITY DIAGRAM) ............................................................................... 50 3.2 PROGRAM TESTING .................................................................................................. 65 3.2.1 TEST PLAN ............................................................................................................... 65 3.2.2 TEST DATA ............................................................................................................... 66 Table “dbo.Info_Candidate” ............................................................................................. 66 Table”dbo.Candidate_Code” ............................................................................................ 66 Table”dbo.Mark” .............................................................................................................. 66 Table”dbo.Subject” ........................................................................................................... 67 CHAPTER 4: OPERATING INSTRUCTIONS........................................................................ 68 4. OPERATING INSTRUCTIONS ........................................................................................... 68 4.1 HARDWARE ARE REQUIREMENT ............................................................................ 70 4.2 SOFTWARE ARE REQUIREMENT .............................................................................. 71 CONCLUSION .......................................................................................................................... 72 Mark and candidate management system System guide HUT-Genetic Computer School Group 22 3 CHAPTER I: SYSTEM SPECIFICATION 1.1 SCENARIO Phuong Dong University (PDU) was established since 1994. After nearly 20 years of construction and development, PDU has been continuously growing thousands of students each year. PDU has a periodic examination of Candidates who want to enter for PDU. Formerly, they managed all the information of candidates and their marks by manual. It took so much time but the effect is not good because the accuracy was low, cost high expense. Nowadays information technology has been developing dramatically and is one of the most important roles in our lives. With development of Information Technology, especially Internet, people can easily access information from anywhere, at any time they want. It also blurs boundaries, makes people closer as if they are face to face and sharing information become easiest than ever. Information technology is applied flexibly and creatively in many areas and it actually gets many amazing achievements. So Managers decide to create a system to manage candidates and marks automatically. In this project we choose PDU for our system to develop. However, it got many benefits in a short time, especially everyone can easily use. However, it has been taken place in a limited or small scale, which is impossible to meet the huge demand of customer, especially who are busy or far from the school. For these reasons, we built the project to give out the solution for solving the limitations. Our System mainly focuses on candidate and mark which help customers easily lookup scores they want just by one click on system everywhere event at home. The system’s function: 1) (User)Admin must log on to use the program. Accounts of admin are stored in the database. 2) Admin can input data, edit data, delete data, view data about Candidates and Marks. 3) Admin can manage room-exam and subject. 4) Admin can search information of candidates and marks by many criteria: a. Search Candidates by Candidate’s code b. Search Candidates by Candidate’s name c. Search Marks by Candidate’s code d. Search Marks by Candidate’s name Mark and candidate management system System guide HUT-Genetic Computer School Group 22 4 e. Search Marks by Exam paper’s code. 5) Admin must create the following report: i. The quantity of register form(Sales/Register) ii. All Candidate’s marks (Print the notice about marks). The report must display the following information: 1. Candidate’s code. 2. Candidate’s full name. 3. DOB 4. Mark of each subject and sum of them. iii. Dispose candidate’s marks from higher to lower. iv. Report about list the Derogation examinee v. Generate candidates who pass the exam. The report must display the following information: 1. Candidate’s code. 2. Candidate’s full name. 3. Sex 4. DOB. 5. Mark of each subject and sum of them. 6. Specialty. 7. Address. vi. Ratio of candidates who pass the exam. vii. Advice note of candidates who pass the exam. vii. Advice note of the beginning of term for candidates who pass the exam 6) Admin must manage the files of the beginning of term. 7) Admin can backup and recovery the database. Mark and candidate management system System guide HUT-Genetic Computer School Group 22 5 1.2 INFRASTRUCTURE Genetic Computer School has 5 computer labs with 150 networked PCs that hook up to the school intranet. These computers also have direct Internet access. There is a server run by system administration and several computers used by school registrar staff. Meanwhile, centralized, multi-user functionalities are performed by the server. The database can be stored in a server for data safety. Figure 1: Infrastructure for Candidate and Mark Management System Mark and candidate management system System guide HUT-Genetic Computer School Group 22 6 1.4 SCHEDULE OF PROJECT Our project has been started at December 2012 and finished at 20th May 2013. Schedule of project is represented as below: PRELIMINARY INVESTIGATION (17 days) SYSTEM DESIGN (23 days) SYSTEM ANALYSIS (28 days) CODING (27 days) TESTING, MAINTENANCE AND DOCUMENTATION (15 days) Mark and candidate management system System guide HUT-Genetic Computer School Group 22 7 1.5 METHOD OF INVESTIGATION The using of some method for investigation is the first work before analyzing and designing programming. Although interviewing is the most commonly used, the others are also valuable and effective techniques for requirement determination. But we also use some other methods such as:  Observation method: There are two kinds of observation methods o Official observation:  It’s not a good method to observe every single element while collecting information to develop system.  The future system you’re building up may be deemed to change the current way of working.  Moreover, those you’re looking at may be uncomfortable and may behave unusually, which will affect your survey’s quality. o Unofficial observation: Researching through document is the final food method to get important. We choose unofficial observation method to collect data and develop our system.  Survey methods: o The interview: An interview is a planned meeting during which you obtain information from another person. The process of interviewing consists of six steps:  Determine who to interview  Establish objectives for the interview  Prepare for the interview  Conduct the interview  Document the interview  Evaluate the interview o Questions: You should carefully choose the kind of question you will ask. As each kind of question serves a particular context, you will suffer if you choose it wrongly.  You should take those questions which show your prediction and use the words that can help emphasize your idea. Mark and candidate management system System guide HUT-Genetic Computer School Group 22 8  Learn to know how uploads/Management/ system-guide 1 .pdf