ssm online examination system design and implementation (thesis + programming + database file) download

Abstract II
Abstract III
Chapter 1 Introduction 1
1.1 Research background and significance 1
1.2 Current research status at home and abroad 2
1.3 Research content 3
1.4 The structure of this article 3
Chapter 2 Introduction to related technologies 4
2.1 Development environment and tools 4
2.2 B/S architecture 4
2.3 MySQL Technology 4
2.4 IDEA Integrated Environment 5
2.5 Chapter Summary 6
Chapter 3 Requirements Analysis 7
3.1 Feasibility Analysis 7
3.2 Function Analysis 8
3.3 System Requirements and Use Case Description 10
3.4 Chapter Summary 11
Chapter 4 Detailed Design 12
4.1 Overall System Architecture 12
4.2 Database Design 13
4.3 System Module Design 16
4.4 Database Table Design 17
4.5 Core Code Detailed Design 20
4.6 Chapter Summary 27
Chapter 5 Testing 28
5.1 Test Summary 28
5.2 Test Results and Findings 28
5.3 Chapter Summary 36
Chapter 6 Summary 37
Acknowledgements 38
References 39

Summary
This management system in order to break the traditional mode of education, the introduction of the concept of online education information technology, design an online examination system, in order to reduce the workload of teachers, and in the context of the epidemic, to facilitate students in distance learning, exam, In order to achieve the purpose of testing their mastery of the knowledge they have learned. In colleges and universities, the road of informatization should go to the front, promote the progress of education, and improve the management efficiency of schools.
This article mainly adopts Java language to develop an online examination system that meets the needs of teachers and students. There are mainly needs analysis phase, overall design phase and test phase. The functions realized by the designed online examination system mainly include: student performance inquiry, online examination, examination question review and analysis; administrators can carry out basic information management, question bank management, examination increase and management, and so on.

Keywords: online examination; online management; distance teaching; B/S structure

Abstract
In order to break the traditional management model of education, this system introduces the concept of information-based online education, and designs an online examination system to reduce the workload of teachers. In the context of the epidemic, it is convenient for students to study remotely and take exams. To achieve the purpose of testing one's own mastery of the knowledge. In colleges and universities, the road of informatization should go to the front, promote the progress of education, and improve the management efficiency of schools.
This article mainly adopts Java language to develop an online examination system that meets the needs of teachers and students. There are mainly needs analysis phase, overall design phase and test phase. The functions realized by the designed online examination system mainly include: student performance inquiry , online examination, examination question review and analysis; the administrator can carry out basic information management, question bank management, examination increase and management, etc.

Keywords: Online examination; online management; remote teaching; B/S structure

Chapter 1 Introduction
1.1 Research background and significance
1.1.1 Research background In
today's society, with the globalization of information technology, the Internet is developing rapidly, and it continues to promote the informatization of various fields and industries [[]]. The school is a training center for scientific talents and modern leaders, so the use of computers is more common, and Internet technology is gradually participating in all aspects of education [[]]. In colleges and universities, the road of informatization should go to the front, promote the progress of education, and improve the management efficiency of schools [[]].
With the influence of the Internet on the field of education. One of the teacher's requirements is to improve students' academic performance, which is reflected in both regular and entrance exams. Therefore, the level of the questionnaire is very important. Only by continuously improving the level of the questionnaire can we better promote the progress of students' academic level. From the teacher's point of view, it often takes a lot of energy and time to compile test papers suitable for students to detect students' learning progress and improve their learning level. Traditional manual testing methods have led to excessive waste of manpower and material resources, the appearance of personal empiricism in education, and the subjectivity of judging papers [[]]. The workload of teachers is too heavy, which will also affect the improvement of students' performance, and affect the operation and control management of the entire educational institution. The traditional examination method highlights many shortcomings such as multiple steps, long cycles, heavy workload, error-proneness, and high cost [[]]. The emergence of online examination system [[]] has effectively made up for the shortcomings of traditional examination methods, has been widely used in the field of education, and has gradually become a research focus for most educators. The fully functional online examination system not only reduces the school's human resources, material resources and time investment, saves examination costs, and improves examination efficiency, but also has the characteristics of student independence and individualized use. This article provides a fair test platform, which plays a very important role in promoting the development of educational information. Therefore, it is necessary to develop an online examination platform that can centrally and comprehensively manage test papers and exams [[]].
The method of storing test questions used by students in daily practice on a computer has been developed overseas as early as the 1960s. Nowadays, various types of online examination systems have been gradually designed and developed at home and abroad. These systems are usually composed of secondary or tertiary structures. The most popular are C/S structure and B/S structure. Internet technology is developing rapidly. Foreign countries have established some mature English question bank systems for students' needs, such as IELTS, TOEFL and other English tests. Nowadays, science and technology are changing with each passing day, and a question bank system that meets the requirements of school management has been established by major universities [2]. For example, the Electronic Department of Beijing Normal University has completed an online examination system for the national general course examination. In addition, Tsinghua University has also completed In order to develop the corresponding material system of the course question bank, Beijing Institute of Technology has also completed the development of an online examination system for college mathematics problems.
1.1.2 Research significance
With the popularization of computer technology and Internet technology, more and more schools adopt computerized management models. In the past few decades, all the inquiries, revisions and preparations of test papers have been carried out by teachers using pens. However, through the online test platform, after discussion, teachers can directly input test questions into the database in the system and create a folder to store the test questions and corresponding answers. This makes the test question bank easier to use, easier to update and safer to manage, with more convenient and practical. Therefore, in order to improve work efficiency and reduce the burden on school staff, the development of an online examination platform is particularly important.
The overall design goal of the system development is to systematize, standardize and automate the test paper generation, and realize the centralized and integrated management of test paper materials, so that candidates can use this platform to answer questions and ensure the fairness of the test. The specific performance is as follows:
(1) For teachers, improving the degree of informatization of examinations is the main way for colleges and universities to ensure their core competitiveness. The online examination system can standardize and unify college examination management. It greatly facilitates the work of teachers and improves the quality and efficiency of teaching examinations [[]].
(2) For students, the examination information management system can replace the traditional paper-based examination management and bring convenience to students' study in school [[]].
1.2 Current research status at home and abroad
The development of computer Internet in China is relatively late. It was originally carried out from colleges and universities, and the research on this technology has also received support from the national education department in many ways [[]]. Yang Deshi and his colleagues put forward in the article "The Design and Implementation of Question Bank and Test Paper Management System Based on SSM Framework": “Online question bank and management system is an important part of information construction. He can reduce the burden on teachers and improve work efficiency. [[]]". Wang Ting pointed out in the article "Design and Implementation of a Test Question Bank Management System Based on B/S Mode": "Teachers need to get rid of the shackles of traditional exams and be able to meet the expectations of the contemporary information society for the improvement of teachers’ ability [[]]" . Yang Weihai and others proposed an online examination self-test system based on PHP as the basic development language and MySQL as a data management tool. The original purpose of the design was to establish a practical examination platform to provide people who need examinations with a wide range of questions. The scope and corresponding answers, its biggest advantage is to support automatic questioning and automatic grading, teacher grading function [[]], however, the system can only be used when an exam is required, and it cannot provide students with a practice platform.
In foreign countries, the question bank management system has been gradually expanded and used in all stages of education. It is especially widely used in the examinations and homework of junior and senior high schools. According to surveys, the UK has the world's first company to apply computer technology to test management, and is the first company to advocate the concept of computer-aided testing. Cheng Siqian pointed out that "traditional questioning methods not only require a lot of work, but it is also difficult for experts to control the difficulty, quantity and degree of standardization of questions [[]]". Yu Zhanqiu and Wen Jingjing put forward: "'Internet +'has become an educational development model, and it is an inevitable trend at present [[]]". The classroom teacher support system developed by IBM and the Los Angeles School District [[]]. Its design concept is to store a school history question bank, which stores 800 questions. This question can provide materials for secondary school teachers to generate tests, homework, class discussion questions, and extracurricular teaching. The system uses batch processing for data processing. The teacher first fills in the required number of questions, categories and related attributes on the application, and then inputs them into the computer through the photoelectric scanner.
1.3 Research content
This article aims at the development of online examination system. The main modules designed are user management, question bank management, examination paper management and examination management, etc. User roles are mainly divided into two types of users: system administrators and students. The system administrators implement the following functions: administrator login, user information management, subject situation management, candidate information management, test question management, test management, test paper management, answering questions Management, performance statistics and other functions. Users can answer the system, review test papers, modify personal information, etc.
1.4 The structure of
this article This article is divided into six chapters, and the main content of each chapter is as follows:
Chapter One Introduction, introduces the research background, significance and research status of the thesis, understands the research situation of the subject through literature research, and proposes the current field experience For some of the questions, the main content of this article and the structure of the thesis are introduced at the end.
The second chapter introduces the technology and instructions used according to the content of the project development.
The third chapter introduces demand analysis. Introduce related function points according to business requirements.
The fourth chapter is the detailed design description of the system. First, the system is divided into two modules, one is the administrator module and the other is the candidate module. The two modules are described in detail, and their functional modules are introduced. And carry on the database design and core function code design description, finally complete the summary of this chapter.
Chapter 5 tests the application of the system. First, the test summary is given, and then the different functions of the system and the performance of the system are tested according to the test summary, and finally the test results are given.
Chapter VI concludes. First summarize the main work done in this article, and then make a further outlook on the application of the online examination system.
Chapter 2 Related Technology Introduction
2.1 Development Environment and Tools
This system builds a JDK environment under Windows 10 system for development and realization, using Java integrated development tool idea. Steps to install Java development environment under Windows 10:
(1) Install JDK;
(2) Set Java environment variables;
(3) Download and install the idea development tool;
(4) Download and install the MySQL database;
2.2 Introduction to the
SSM framework SSM framework is currently the mainstream framework for development on the market, and many frameworks such as SpringBoot framework are all based on SSM framework The result of the above improvement, the shape of the gods remains unchanged, is the result of integrating Spring, SpringMVC, and MyBatis [[]].
Spring MVC has the development characteristics of MVC. By separating the development of the three modules of model, controller, and view, it not only standardizes the development process, but also reduces the workload of developers. Moreover, Spring is also rare in the industry and can be used by everyone. The framework of learning, and its open source features reduce people's learning threshold and cost [[]].
MyBatis is a Java-based POJO framework. It maps the get/set method of the persistence class in the interface to the database by configuring the mapper.xml file to help developers improve the efficiency of database operations. This can be used in the project. The method directly operates on the database [[]].
Due to the selection of the SSM framework to design the "online examination system", which greatly reduces the workload of this project, the SSM framework has the advantage of mobility. The control layer in the SSM framework will control the user's request (user behavior operations occurring in the front end) ) Is transferred to the Service layer, and then the SQL statement is accessed through the access layer. After the operation is implemented through the corresponding SQL statement, the result is returned to the view and displayed on the front-end interface, as shown in Figure 2.1, which is the general process of the SSM framework.
The overall architecture design of the project system should not only reflect that the interaction between the users of the system and the project platform we build is effective, but also ensure that the mutual interaction is relatively clear overall, so as to ensure that the design is After the code is completed, the data when it is actually put into use has the guarantee of scalability and security. Only if it conforms to the overall design can it be guaranteed that the project can add functions in the future to adapt to future development.
As shown in Figure 2.1, after the user issues an instruction, the controller transmits the instruction issued by the user to the Service service layer. The service layer accesses the Dao layer through the set interface. Dao is the bottom layer that directly defines the database statement. The front-end interface can be added, deleted, modified and checked by defining data operation statements, and returned in order after execution, and the execution results are returned to the user through the view interface. The SSM framework of this system clearly divides the entire project into Model, View, and Controller. Part, making the whole project more clear and impressive.

Insert picture description here


Figure 2.1 System SSM architecture
2.3 MySQL technology
MySQL is a relational database system. So far, the software engineering industry has developed many different types of large databases, such as Oracle, MongDB, and so on. But in terms of its popularity in the industry, MySQL is unmatched by other databases.
First of all, MySQL database stores the data entered into the system in different data tables. It does not put all the data parameters together. It can also establish views and create multi-table association mechanisms on each basic table. This is not only Increasing the speed of retrieving data can also increase the flexibility of the entire system. MySQL mainly has data operations, data definitions, and data query statements, and the access statements of the MySQL database are still the most commonly used standard statements in the current database construction-SQL statements.
2.4 IDEA integrated environment
IDEA is recognized as the best Java development tool in the industry. It is not only Eclipse, but also provides programmers who use the java programming language to refactor and use various versions such as Git, SVN, etc. Tools, to realize the integrated environment of JUnit and CVS integration, and also in many aspects such as code analysis, innovative GUI design, etc., especially in the functions of intelligent code assistant and code automatic prompting, it has a surprising performance. [[]]
Next, I will compare the two development tools from the following aspects.
(1) Interface style:
IDEA: IDEA is known for its well-designed interface. The overall interface uses black as the default color, which can be said to be caring for programmers who need to write code for a long time.
Eclipse: Since it has been produced for many years, its theme is not as avant-garde as IDEA, and its design is more traditional, but it can also increase the design sense of the user coding interface by configuring different themes. If you want to modify the interface of other windows, you need to pass the The registry file is re-encoded.
(2) Shortcut keys:
IDEA: IDEA comes with a shortcut key theme that can be configured as Eclipse compatible with Eclipse. If you modify the shortcut keys in the theme, the modified content will be instantiated automatically. We can view the example Record to see which shortcut keys have been modified.
Eclipse: Although the shortcut keys can be configured, there is no shortcut key theme.
(3) Code automatic prompting and completion:
IDEA: It has more excellent features in code prompting and completion, as if it understands the context, which is particularly significant in this Java project. IDEA will automatically analyze and retrieve all the contents of the project stored in the workbench, and construct the grammar tree, so that no matter where the developer focuses on the project when writing the project, IDEA can think what you think and predict the developer The next step of the operation greatly reduces the workload of developers.
Eclipse: Compared with the smart IDEA, Eclipse must use the alt+/ key or ctrl+1 key to query the method starting with the letter in terms of code completion.
(4) Memory usage:
IDEA: Developers who have used IDEA generally find that this compilation software has much higher requirements for memory, and it will be very difficult for a computer to have no 8G memory during operation.
eclipse: Because of its long existence as a development software, compared to IDEA, the memory requirements are not so strict.
(5) Automatic construction:
IDEA: The default project will not be automatically built. If there is an error in the code editing and it is in a black theme, the red wavy line prompt is not so obvious.
Eclipse: The default project is automatically built. If the developer saves the project after writing, the project will be automatically built and coding errors are more obvious than IDEA.
(6) Project dimension:
IDEA: A project project in IDEA can include multiple Modules.
Eclipse: A working interface in Eclipse can include multiple projects.
IDEA: Each workspace can only have one project.
Eclipse: Each workspace can contain multiple projects at the same time, with greater freedom.
(7) Error prompt:
IDEA: Default prompts for "The method is not defined" and "Field has never been assigned", but these warnings have no practical meaning when the get/set method and reflection mechanism of the persistent class are used.
Eclipse: The undefined method in the code will have a yellow wavy line, but there is no warning on the get/set method of the persistent class.
Comparing IntelliJ IDE and eclipse, these two are both Java programming language development tools. The difference is that IDEA has more access to the third-party plug-in market, and it is smarter than eclipse in terms of development efficiency and intelligent prompts. In terms of environment configuration generation IDEA is also relatively fast, and the interface design is relatively clean and simple.

Tomcat server is a free and open source web application server with advanced technology, stable performance, and free of charge. It occupies small system resources when running, has good scalability, and supports load balancing and mail service and other commonly used functions in development application systems. . As a small and lightweight application server, Tomcat is commonly used in small and medium-sized systems and occasions where there are not many concurrent users, so it has become a popular Web application server.

2.5 Summary of
this chapter This chapter explains the technology used in the development project, the system environment configuration and the use of development tools. The Spring and Mybatis framework, MySQL database and IDEA integrated environment used in the system backend are compared with the eclipse environment.
Chapter 3 Requirements Analysis
3.1 Feasibility Analysis
3.1.1 Technical Feasibility
As the software pre-development process, the project needs to be analyzed. First, we must understand what the business does and what functions are implemented, and subdivide each function in the functional module. The background of the use of each functional module, only in this way, in the software development, will not be repeated because of the flaws in the architecture design, resulting in the occurrence of the underlying data structure in the secondary design. In addition, there are some non-functional features, such as database performance and security. The consideration of the network speed and the reflection time of the network speed are both the constraints of the demand analysis, and are also the goals that need to be analyzed at runtime after the project is developed.

From the perspective of popular database development and management software in the IT industry, the system is based on a mature Windows operating system and a MySQL database using JAVA technology. Through the above technologies, we have designed and implemented an online examination system with relatively rich functions. Therefore, starting from the technical feasibility, it is feasible to develop the system [[]].
This system mainly builds a framework on the idea to realize system back-end management and web-side management, so that administrators can manage the system conveniently and improve system utilization.
3.1.2 Economic feasibility
(1) Business opportunities
In today's rapid development of Internet technology, the education industry has updated requirements for student assessment. As a teacher, you may not always have the energy and time to write the correct test papers for your students. The traditional method of manually asking questions not only leads to personal empiricism in education, but also wastes manpower and material resources. The workload of the teacher is too heavy, which also has an impact on improving the performance of the students, and affects the management of the entire organization. Therefore, it is necessary to develop a reasonable, effective, standardized, and practical online exam management system to centrally and comprehensively manage the test questions and materials, and allow students to directly participate in the exam through the platform to reduce the risk of the current epidemic.
(2) Customer needs
The examination process of this system is electronic, which is convenient for administrators. At the same time, for students, remote examinations can be conducted in the system in time to avoid the waste of manpower and material resources of traditional examinations. Therefore, this system can better meet the work needs of colleges and universities, and has more advantages and characteristics in the market.
The purpose of developing the online examination system is to reduce and ease the pressure of teachers to review test papers, and to reduce the labor costs paid by the school when organizing teachers to review test papers, and to facilitate students to take online exams in the context of the epidemic. So in this regard, the online examination system can bring economic benefits. At the same time, the main economic investment for the development of this system is in the final maintenance stage, so it will not bring excessive economic losses, and even has advantages for the economic development of the school.
3.1.3 Operational feasibility
(1) Market competition
As far as the existing online examination system on the market is concerned, this system can continuously update the test question bank and monitor the online examination of candidates. At the same time, this system is equipped with web page management, which is simple and convenient to use. Therefore, the system has low competitive pressure in the market and has good development potential.
(2) Development ability
The Java language and related frameworks are used in the development of this system, all of which are the application of knowledge integration and self-study knowledge learned in four years of university. It can be seen that the development of this system will promote my ability to learn, apply, and integrate knowledge.
(3) Technical support
The technology used in this system is the more mature technology currently on the market. During development, most of the technical problems encountered can be solved, reducing development difficulties. At the same time, it is also a major advantage of the system in the development process, which saves development time.

3.2 Function analysis
3.2.1 System function analysis
This system organically combines the popular SSM framework with the existing Java technology to realize an online examination system. The system not only effectively overcomes the traditional problems of low reliability, maintenance difficulties, complex use, waste of time and manpower, etc., but also the system realizes the characteristics of low power consumption, energy saving, and economical application. It is a complete and feasible set. system.
The text mainly develops an online examination system to realize the information management of the examination process in colleges and universities. The main functions are as follows:
1. Candidates' use of the system. Candidates can log in to the system according to their registered account, then select the exam they want to take, read the exam instructions and answer. After completing the exam, you can view the answered test papers and check scores. At the same time, candidates can modify their personal information in the system, and update the information in time to make better use of the system.
2. The administrator performs management operations on all sections. Mainly include user management, adding, modifying, and deleting operations of question bank management. And the management of the user's score after the test taker's answer sheet is completed. .
The summary analysis of requirements is shown in Table 3-1.
Table 3-1 Requirement summary analysis
Requirement number Requirement content
X1 User management, including user account, password, personal information management
X2 Candidate answer
X3 Candidate review test paper
X4 Subject management
X5 Test paper management
X6 Test management
X7 Score management
3.2.2 System functional structure
basis With the characteristics of system development, the project is mainly divided into two roles: candidate role and administrator role. Candidate role management functions are as follows:
(1) Register and log in: Candidates first need to register an account, only then can they log in to the system to take the exam. Candidate registration needs to fill in user name, password, mobile phone number and other information; after successful registration, candidates fill in the user name and password to log in to the system, use the system to take the exam and view the results.
(2) Exam answer: After the examinee enters the system, select the exam to take in the exam list, click to start the exam, read the exam requirements, and enter the answer page to answer the questions. You cannot click on other pages during the answering process.
(3) Review the test paper: After the test taker has completed the answer, he can view the test paper he has taken, mainly to check the test score and whether he has passed the test.
(4) Personal information: Candidates can query and modify personal information, and make reasonable adjustments to personal information, so as to avoid the occurrence of errors in candidate information, inability to take the exam or even errors in score statistics.
The administrator management functions are as follows:
(1) Login: The administrator fills in the user name, password and verification code to log in to the system.
(2) User management: Users with administrator rights can add, modify, and delete users.
(3) Subject management: Users with administrator rights can add, modify, and delete subjects.
(4) Candidate management: The administrator manages the candidates, and can add, delete, modify, and check candidate information. The administrator's management of students can reduce the occurrence of students' failure to use the system due to errors in modifying their own information and operating errors.
(5) Exam management: Administrators can add, modify, search and delete exam information. To add exam information, you need to fill in information such as exam name, course, exam start date, exam end date, etc., and the system will check the question bank In the mobile phone, select the questions to form the test paper.
(6) Test paper management: Users with administrator rights can modify, delete, and search test papers.
(7) Test question management: Users with administrator rights can modify, delete, and search test questions.
(8) Answer management: Users with administrator rights can judge the content of the user's answers and evaluate and scoring operations.
(9) Results statistics: Users with administrator rights can perform statistical analysis and query operations on all candidates' results.

3.3 System Requirements Use Case Description The
system requirements are shown in the use case diagram 3.1, which shows the functional requirements from the perspective of the examinee and the administrator.

Insert picture description here


Figure 3.1 System requirements use case Figure
3.3.1 The candidate requirements
module is mainly set up for candidates to facilitate the use of the system by candidates. It mainly realizes the registration and login of candidates in the system, as well as the later personal information modification, so that personal information can be updated in time and convenient for management. Member management. At the same time, candidates can choose the exam they need to take to answer the questions, and after the answer is over, they can check the test paper to check their own scores and answers.
3.3.2 Administrator requirements
This module is for administrators to use the system, mainly for user management, candidate information management, and subject management in the system. It can manage test papers, that is, search and modify test papers, and modify the status of test papers.
3.4 Summary of this chapter
Through the analysis of technical feasibility, economic feasibility, and operational feasibility, it has been confirmed that the development of this system has certain economic benefits, and has development capabilities and necessity. At the same time, a summary analysis of the system functions is carried out, and a brief introduction of the functions contained in the system and the expected goals, so that users can have a general understanding of the system.

Chapter 4 Detailed Design
4.1 Overall System Architecture
Through a more in-depth analysis of system requirements, the core business of the system is clarified. The online examination system architecture is shown in Figure 4.1.

Insert picture description here


In the process of software engineering project development, after completing the demand analysis, the overall design of the entire English course question bank system, that is, the outline design, is required for the overall description and overall design of the entire system from an objective perspective. The specific design principles are as follows:
(1) The principle of ease of use
In the design process, the needs of users must be fully understood to meet the needs of ordinary users. The essence of interface design is easy to understand and comfortable experience.
(2) Principle of Practicability
The fundamental purpose of the online examination system design is to improve the teacher's management of the examination and the efficiency of students taking the examination, so as to facilitate the use of students and teachers in all aspects, and to save human and material resources for the school. Therefore, the system needs to have good practicability and be able to ensure stable and reliable continuous operation.
(3) The principle of technology advancement and maturity
First of all, the design of online examination systems has become very common, mainly because some special functions need to be added to the needs of teachers and students of the school. These functions vary from person to person. Therefore, in the design process, you need to position yourself accurately, and you should also recognize your own shortcomings.
According to the project content structure and development requirements, the overall structure design diagram is as shown in the figure:

Insert picture description here


4.2 Database design
4.2.1 Overview of database design
In the development and construction of software projects, database design is not only an extremely important technology, but also the establishment of database tables and The most basic design of the corresponding platform. The design of the database is not completed overnight. The technology we want to achieve is to be continuously modified, top-down, and gradually improved to ensure that our program can run perfectly with the support of the underlying database.
In the design process of this system, the design of the technical database is a very special and important link. Therefore, we not only need the development of information management, but also the meticulous design of the database. In order to meet the needs of different users, we need to redistribute data. In this design process, we need to design the data model, define the actual application conditions of the logical model, and design the best structure of the database that matches the physical reflection storage structure. We must also pay attention to the actual effectiveness of access methods and data sources, and the information connection of global information to ensure that user requirements and information needs are met. This enables us to effectively achieve user requirements for entering the system, achieving demand analysis, and enabling us to write code Ability to effectively access the database.
The design of the database application system and the design of the corresponding database have been extremely related since its creation. If the database can have a good design, it will not only help us save the storage space in the initial construction of the system project and the process of construction, but also Ensure the data integrity of the execution function during the design process.
4.2.2 Conceptual structure design The
ER diagram of the core functions of the online examination system is shown in Figure 4.3.
Through the analysis of the requirements of the system, it can be concluded that there are two roles in the system: the administrator and the examinee. Each role has different operating rights in the system and can use the system to perform different functions. The ER diagram of each part of the function is implemented as follows:

Insert picture description here

Screenshot of part of the page:

Insert picture description here


Insert picture description here


Insert picture description here


Insert picture description here


Insert picture description here


thesis + program design source code + database file: click here for download