It's a bit later. However, this project needs to be completed during the summer vacation. About the database design, the method adopted is based on the just learning "database system introduction" E-R drawing knowledge to design.
After a holiday in Huizhou for a few days, I almost forgot my knowledge. I always feel that this E-R graph I designed is a bit problematic. See Figure first.
E-R Diagram
PS:
The blue text of a rectangle is an entity.
The diamond black character is the operation
The red letter in the circle is an attribute.
I have already introduced the detailed process of the website, so I will not talk about it here.
PS:
By default, the system only has one administrator account.
By default, a student needs to finish three topics (this is different from the original plan) to complete the task. (Of course, the premise is that you must pass each assessment .)
Administrators can manage the data of the entire website, such as adding topics, modifying topics, and deleting topics.
Problem
I don't know much about design. (Limited capability)
1. Whether the score item should be designed as attribute or entity is better. When the attribute is designed, some operations (such as student query scores) cannot be marked. Some operations (Assessment) cannot be marked when designed as entities. So I never thought of a better solution to this problem.
2. Whether the question should form an independent entity. After the question is independent, the entity of the question subject and the choice question cannot form an effective operation on the object of the question. It is only an attached function. However, if you design question and multiple-choice questions as attributes, how should you design the attributes of question and multiple-choice questions? What is the relationship between a question and a topic?