1. College data entity: college name, person in charge, office phone number and college number.
2. Student data entity: student number, password, name, gender, nationality, native place, date of birth, ID number, contact phone number, email address, remarks, student number, class, role name and thesis number.
3. Teacher data entity: teacher number, password, college number, department, published topic, education background, professional title, name, gender, political outlook, contact number, email address, role name and remarks.
4. Role data entity: role name and permission name. Permission data entity: permission name and role name. The above entities are all basic data entities.
Because the name of the operation module corresponds to the authority, these data should be added when the program is initialized, and the purpose of the teacher's thesis management system is to manage the thesis, so it also includes the following data entities:
1, paper data entity: paper number, college, author, publication name, paper title, collection, teacher number, student number, influence, influence factor, citation times and remarks.
2. Evaluation data entity: teacher number, student number, thesis number, thesis title, evaluation opinion and total score.
Transforming the conceptual structure design of data into the actual database model supported by SQLSERVER2005 database system is the logical structure of the database. Based on the relationship between entities, the relationship between tables in the database is formed.
Extended data:
Matters needing attention in database design:
1, title. The title should clearly, accurately and concisely summarize the main contents and achievements of research and practice. The main title generally does not exceed 20 words. If there is a subtitle, the subtitle generally does not exceed 28 words.
2. Executive summary. Briefly introduce the main contents, methods and conclusions of the paper in 200-500 words before the main contents.
3. Key words. According to the closeness to the content of the paper, 3-5 keywords are listed respectively.
4. English translation content. Chinese title, author's name, instructor's name, content summary and key words should be translated into English.
References:
Baidu encyclopedia-literature database