Database training experience

After one month of database training, I participated in the software engineering development process. The most profound experience is the most of our practical training network:

I.The largest project: The project is large because of the large number of users involved in the website at the starting point of our career-universities, enterprises, students, teachers, and experts. The second reason is the many functions of the website-user management and online internships, online competition, graduation practice design, project management, talent pool management, Talent recommendation, search... A large project can easily cause a flood of systems. In the early stages of our development, due to unclear requirements, there was no focus on function implementation, resulting in an extended scope of requirements, this causes a serious lag in the project development progress. Then we held a meeting to discuss this issue. We agreed that we should first implement the basic functions of the project and build the basic architecture of the website, at last, we will continue to add other functions of our website. Therefore, in this process, I deeply realized the importance of demand analysis and outline design in the initial stage of software engineering. These two documents are the most important basis for our later development.

 

II.Database tables are the most: such a large system requires a large database to support, so the direct consequence of a large project is that we have a large number of database tables, in addition, the dependency between tables is complex, and there are many relationships between entity classes, which makes it difficult to design. Another problem with the database is the data table attributes. The design of the data table attributes depends entirely on the requirement analysis document we just started. If the requirement analysis is incomplete, this will lead to the absence of database table attributes. From the user's perspective, you will feel that the data provided by your system is incomplete and the amount of information is small.

 

III.The largest development team: Our team has a total of 14 members. This is a serious problem for our project manager. After all, the team of 14 members is equivalent to the total number of other groups, management is quite difficult. For our Group members, too many communication channels have caused problems in our project and we do not know which group members to communicate. To solve this problem, we selected three other team leaders in the team. When the team members encountered problems, they first consulted the team leader and then provided feedback.

 

4.High coupling between modules of the project: the functional modules of the website are closely linked. The interface design between modules is the most important factor for the project's final integration success. User Management provides interfaces for each module, including user numbers and user types. Links between pages are also important module interfaces. This problem is caused by the fact that we have fully communicated in the early stage and designed our own modules according to the interface instructions in the outline design. Therefore, we have not encountered any major incompatibility issues in the later module integration.

 

Next, let's talk about my work this month:

Demand analysis stage: In the demand analysis stage, I have completed the demand analysis of the online competition module. The main problem I encountered was my Online internship and online competition after I read the materials, the functions of these modules are similar in graduation project guidance. The requirements analysis is not clear enough. After several conversations with instructor Tang, the specific differences between these modules are determined, the basic requirements of the online competition module are also roughly determined. The basic function of the online competition module is that students register for the competition through the website. After the enterprise passes the review, experts grade and rank the competition.

 

Summary design stage: Based on demand analysis, the online competition module is designed in a more specific summary,StreamProcess Diagram (IPO diagram and use case diagram); the main difficulty at this stage is the description of the online competition business process, how to implement the step-by-step operations of student registration, enterprise release, and expert review, and other modules.

 

Database Design Phase: I am responsible for integrating the preliminary database design specification, assigning members to design the data tables required by their modules according to their specific requirements of the functional modules, and then integrating these data tables. The problem encountered in this process is that the database is too large. There are more than 30 tables in the end. The relationship between the table and the table is complex and highly correlated. You need to set more foreign keys, it is difficult to extract all attribute fields, and attribute type setting is also a problem. It is especially important to use the numeric type or the string type in the database design, because in the background search, the numeric type is quick, and in terms of data display, the string type has the advantage of Directly Reading data without conversion. The primary keys of each table are marked with Entity numbers, because the association between entities is easier. The key to database design is to grasp the entire project and refine the specific attribute requirements for each entity class.

 

Detailed design stage: I think it is the most important aspect. A complete detailed design description should helpProgramThe programmer completes the specific implementation. The programmer does not need to consider the coupling problem between modules, but only needs to write a single function in a logical order. After the overall website architecture is set up, we can fill in our functions in it. However, because the time is too hasty, We will shrink at this stage, and the problem that comes after is the later stage.CodeThe compilation process is confusing, the function interfaces are difficult to unify, and the interface style is diversified. At this stage, I worked with my teammates to design an online competition module for students, enterprises, administrators, universities, and experts.

 

Encoding phase: We developed it using Asp.net. The main task is to select the control you want from the tool, and then fill in the code in the control response function to complete the corresponding event response. The biggest problem encountered here is the page layout problem, because I was the first to develop a website, resulting in monotonous and not very beautiful UI style designed by myself. Now I try my best to make the page neat. At this stage, the main task is to write code.→Compile→Debugging→Write code.

 

I learned a lot this month, and I learned to use it technically.ASP. NETThe most important thing to write a website is to let me go through all stages of software engineering and give me a perceptual understanding of the entire software engineering,In addition, the University's three-year knowledge is systematically linked. More importantlyIt is a valuable practical experience to learn how to communicate with members of the project team.