[Gibberish code pitfall series] ZJUT database large-scale experiment, pitfall zjut

[Gibberish code pitfall series] ZJUT database large-scale experiment, pitfall zjut
Student Management System (2) Project Planning

Student Management System (1) project establishment

 

Well, this part should be placed first, but I forgot to escape. Actually, it's almost the same. I didn't say anything in the previous article. Haha.

First, let's talk about the project requirements.

The staff of a school Managing Student Achievement put forward the following data and business processing requirements based on actual work needs:

 

The project requires the establishment of a management system to add, delete, query, and modify local databases. If you want to directly use the. mdf file for modification, it will be played by the Teacher. Therefore, a graphical interface is required.

The graphic interface has several pages: logon, the main window, management of colleges, teachers, students, courses, and scores. You need to see the details and delete them in batches. In order to force installation, you can consider joining the connection with the Office. However, if this is the case, do the basic functions and try again.

The database requires tables such as schools, teachers, students, courses, and scores. Well, it's the same as above.

The first thing we need to do is to create a table. Before creating a table, we can draw a graph to confirm and create a new table, so that we do not forget anything at that time, okay, actually, I just want to use it while Visio is not expired.

This is the database diagram, and then a client activity diagram.

Ah, it's so troublesome to skip the painting first. Let's start with the ghost animal disco (Escape ghost animal disco.

Well painted

That's it. Just draw a memo. The next step is to create a database.