Figure 13: Student Overall Information E-R Figure
3.1.1
Student status management module:
Figure 14: Student status management loan part e-r
Figure 15: Student status management registration section E-r
Figure 16: Student status management student status E-r
Figure 17: Students' Participation Management Military Training Section E-R
Figure 18: Students' Students Management Graduation Part E-R
Figure 18: Students' Participation Management Overall E-R Figure
3.1.1
Student grade management module:
Figure 19: Student grade management teacher part E-r
Figure 19: Student Achievement Management Course Some E-R Map
Figure 20: Student score management administrator part e-r
Figure 20: Student performance management overall E-R diagram
3.2 E-R
Model diagram conversion to relational table:
3.2.1
Student file management (entity transformation is a relational mode)
Student (student number, name, gender, date of birth, college, class, professional)
Resume (student number, format, storage address)
Reward project (student number, hospital level reward, school-level reward, provincial / municipal reward, national reward, reward time)
Placement (student number, warning, stay)
Physical examination (student number, physical examination time, medical record, medical physician)
3.2.2
Student file management (contact transformation is a relational mode)
Resume (student number, storage address)
Dispute conditions (student number, disposal time, warning punishment, staying school)
Reward case (student number, reward time, hospital level reward, school-level reward, provincial / municipal reward, national reward, bonus time)
Physical examination (student number, physical examination time, medical record, medical physician)
Family (student number, origin, nation, birthplace, home address, home phone)
3.2.3
Student's student status management (entity transformation is a relational model)
Loan (student number, loan amount, loan time)
Registration (registration number, registration password, registration time)
School status (student number, change time, original school address, presentation address)
Military training (student number, do you participate, start time, end time)
Graduation (student number, graduation, graduation time, graduation)
3.2.4
Students' Participation Management (Contact Transformation into Relationship Model)
Loan situation (student number, loan time)
Registration (registration number, registration password, registration time)
Study status (student number, change time, original school address, current learning address)
Military training situation (student number, whether to participate, start time, end time) graduation (student number, graduation, graduation time, graduation)
3.2.5
Student performance management (entity transformation is a relational mode)
Teacher (teacher number, name, password, gender, title, college, office)
Course (course number, course name, course credits)
3.2.6
Student performance management (contact transformation is a relational mode)
Elective course (student number, course number, grade)
Teaching situation (teacher number, course number)
3.3
Basic Table Relationship Information:
Database table name
1
: StudentInfo
Basic situation of students
)
Field name
type of data
Meaning description
Null
Prepare
Note
STU_ID
VARCHAR (10)
Student number
Can not be empty
Primary key
STU_NAME
VARCHAR (10)
student name
Can be empty
STU_SEX
VARCHAR (2)
Student gender
Can be empty
STU_BIRTHDAY
Datetime
Student date
Can be empty
STU_COLLEGE
VARCHAR (10)
Student Institute
Can be empty
STU_DEP
VARCHAR (10)
Student office
Can be empty
STU_CLASS
VARCHAR (10)
Student's class
Can be empty
STU_MAJOR
VARCHAR (10)
Student professional
Can be empty
Database table name
2
:
ResumeInfo
(Student Registration Information Table)
Field name
type of data
Meaning description
Null
Prepare
Note
Res_Format
VARCHAR (5)
Resume format
Can be empty
RES_ADDRESS
VARCHAR (20)
Establish an address
Can be empty
STU_ID
VARCHAR (10)
Student number
Can not be empty
Primary key
Database table name
3
:
AwardInfo
(Student Awards)
Field name
type of data
Meaning description
Null
Prepare
Note
Award_college
VARCHAR (30)
School-level reward
Can be empty
Award_school
VARCHAR (30)
School-level reward
Can be empty
Award_pro
VARCHAR (30)
Provincial municipal reward
Can be empty
Award_nation
VARCHAR (30)
National reward
Can be empty
Award_time
Datetime
Reward time
Can be empty
Primary key
STU_ID
VARCHAR (10)
Student number
Can not be empty
Primary key
Database table name
4
:
Punishinfo
(Student punctuation)
Field name
type of data
Meaning description
Null
Prepare
Note
Punish_first
VARCHAR (20)
Warning
Can be empty
Punish_second
VARCHAR (20)
Left school view
Can be empty
PUNISH_THIRD
VARCHAR (20)
Open student status
Can be empty
PUNISH_TIME
Datetime
Disposal time
Can be empty
Primary key
STU_ID
VARCHAR (10)
Student number
Can not be empty
Primary key
Database table name
5
:
FamilyInfo
(Student Family Table)
Field name
type of data
Meaning description
Null
Prepare
Note
Family_Place
VARCHAR (10)
Originate
Can be empty
Family_folk
VARCHAR (5)
Nation
Can be empty
Family_birdhvarchar (10)
place of birth
Can be empty
Family_address
VARCHAR (20)
family address
Can be empty
Family_Phone
VARCHAR (20)
home phone
Can be empty
STU_ID
VARCHAR (10)
Student number
Can not be empty
Primary key
Database table name
6
:
CheckInfo
(Student medical examination)
Field name
type of data
Meaning description
Null
Prepare
Note
Check_time
Datetime
Physical examination time
Can be empty
CHECK_CASE
VARCHAR (20)
Medical record
Can be empty
Check_doctor
VARCHAR (10)
Medical physician
Can be empty
STU_ID
VARCHAR (10)
Student number
Can not be empty
Primary key
Database table name
Seduce
:
LoanInfo
(Student Loan Situation)
Field name
type of data
Meaning description
Null
Prepare
Note
Loan_money
Money
loan amount
Can be empty
Loan_time
Datetime
Loan time
Can be empty
Primary key
STU_ID
VARCHAR (10)
Student number
Can not be empty
Primary key
Database table name
8
:
RegisterInfo
(Student Registration)
Field name
type of data
Meaning description
Null
Prepare
Note
REG_PASSWORD
VARCHAR (20)
sign up password
Can not be empty
REG_NAME
VARCHAR (20)
Registration Number
Can not be empty
Primary key
REG_TIME
Datetime
Registration time
Can not be empty
Database table name
9
:
StatusInfo
(Student's Change Status)
Field name
type of data
Meaning description
Null
Prepare
Note
STATUS_TIME
Datetime
Change time
Can be empty
Primary key
Status_Former
VARCHAR (20)
Original school address
Can be empty
Status_Laster
VARCHAR (20)
Current school address
Can be empty
STU_ID
VARCHAR (10)
Student number
Can not be empty
Primary key
Database table name
10: MilitaryInfo
(Student military training situation)
Field name
type of data
Meaning description
Null
Prepare
Note
MIL_RIGHT
VARCHAR (5)
Do you participate?
Can not be empty
Primary key
Mil_Start
Datetime
Starting time
Can be empty
Mil_end
Datetime
End Time
Can be empty
STU_ID
VARCHAR (10)
Student number
Can not be empty
Primary key
Database table name
11
:
GraduationInfo
(Student graduation)
Field name
type of data
Meaning description
Null
Prepare
Note
Gra_right
VARCHAR (5)
Graduation
Can be empty
GRA_TIME
Datetime
graduation time
Can be empty
Gra_Dest
VARCHAR (10)
Graduation
Can be empty
STU_ID
VARCHAR (10)
Student number
Can not be empty
Primary key
Database table name
12
:
TeacherInfo
(Teacher basic situation)
Field name
type of data
Meaning description
Null
Prepare
Note
Teacher_ID
VARCHAR (10)
Teacher number
Can not be empty
Primary key
TEACHER_NAME
VARCHAR (10)
Name
Can not be empty
Teacher_password
VARCHAR (20)
password
Can not be empty
Teacher_sex
VARCHAR (2)
gender
Can be empty
Teacher_Position
VARCHAR (20)
job title
Can be empty
Teacher_college
VARCHAR (10) College
Can be empty
Teacher_DEP
VARCHAR (10)
Department
Can be empty
Database table name
13
:
CourseInfo
(Course Information Table)
Field name
type of data
Meaning description
Null
Prepare
Note
Course_id
VARCHAR (10)
Course number
Can not be empty
Primary key
Course_name
VARCHAR (20)
Course Title
Can not be empty
Course_num
VARCHAR (5)
Course credits
Can not be empty
Database table name
14
:
Chooserinfo
(Student transcript)
Field name
type of data
Meaning description
Null
Prepare
Note
Course_id
VARCHAR (10)
Course number
Can not be empty
Primary key
Course_grade
VARCHAR (5)
Grade
Can not be empty
STU_ID
VARCHAR (10)
Student number
Can not be empty
Primary key
Database table name
15
:
TEACHINGINFO
(Teacher "
Field name
type of data
Meaning description
Null
Prepare
Note
Course_id
VARCHAR (10)
Course number
Can not be empty
Primary key
Teacher_ID
VARCHAR (10)
Teacher number
Can not be empty
Primary key
Database table name
16
:
AdminInfo
(Administrator Information Table)
Field name
type of data
Meaning description
Null
Prepare
Note
ADM_NAME
VARCHAR (10)
Administrator number
Can not be empty
Primary key
ADM_PASSWORD
VARCHAR (20)
Administrator password
Can not be empty
3.4
Data Dictionary:
Data dictionary table
Field name
type of data
Meaning description
Null
Prepare
STU_ID
VARCHAR (10)
Student number
Can not be empty
STU_NAME
VARCHAR (10)
student name
Can not be empty
STU_SEX
VARCHAR (2)
Student gender
Can not be empty
STU_BIRTHDAY
Datetime
Student date
Can not be empty
STU_COLLEGE
VARCHAR (10)
Student Institute
Can not be empty
STU_DEP
VARCHAR (10)
Student office
Can not be empty
STU_CLASS
VARCHAR (10)
Student's class
Can not be empty
STU_MAJOR
VARCHAR (10)
Student professional
Can not be empty
Res_Format
VARCHAR (5)
Resume format
Can be empty
RES_ADDRESS
VARCHAR (20)
Establish an address
Can be empty
Award_college
VARCHAR (30)
School-level reward
Can be empty
Award_school
VARCHAR (30)
School-level reward
Can be empty
Award_pro
VARCHAR (30)
Provincial municipal reward
Can be empty
Award_nation
VARCHAR (30)
National reward
Can be empty
Award_time
Datetime
Reward time
Can be empty
Punish_first
VARCHAR (20)
Warning
Can be empty
Punish_second
VARCHAR (20)
Left school view
Can be empty
PUNISH_THIRD
VARCHAR (20)
Open student status
Can be empty
PUNISH_TIME
Datetime
Disposal time
Can be empty
Family_Place
VARCHAR (10)
Originate
Can not be empty
Family_folk
VARCHAR (5)
Nation
Can not be empty
Family_birth
VARCHAR (10)
place of birth
Can not be empty
Family_address
VARCHAR (20)
family address
Can not be empty
Family_Phone
VARCHAR (20)
home phone
Can be empty
Check_time
Datetime
Physical examination time
Can be empty
CHECK_CASE
VARCHAR (20)
Medical record
Can be empty
Check_doctor
VARCHAR (10)
Medical physician
Can be empty
Loan_money
Money
loan amount
Can be empty
Loan_time
Datetime
Loan time
Can be empty
REG_PASSWORD
VARCHAR (20)
sign up password
Can not be empty
REG_NAME
VARCHAR (20)
Registration Number
Can not be empty
REG_TIME
Datetime
Registration time
Can not be empty
STATUS_TIME
Datetime
Change time
Can be empty
Status_Former
VARCHAR (20)
Original school address
Can be empty
Status_Laster
VARCHAR (20)
Current school address
Can be empty
MIL_RIGHT
VARCHAR (5)
Do you participate?
Can not be empty
Mil_Start
Datetime
Starting time
Can be empty
Mil_end
Datetime
End Time
Can be empty
Gra_right
VARCHAR (5)
Graduation
Can not be empty
GRA_TIME
Datetime
graduation time
Can not be empty
Gra_Dest
Datetime
Graduation
Can be empty
Teacher_ID
VARCHAR (10)
Teacher number
Can not be empty
TEACHER_NAME
VARCHAR (10)
Name
Can not be empty
Teacher_password
VARCHAR (20)
password
Can not be empty
Teacher_sex
VARCHAR (2)
gender
Can not be empty
Teacher_Position
VARCHAR (20)
job title
Can be empty
Teacher_college
VARCHAR (10)
College
Can not be empty
Teacher_DEP
VARCHAR (10)
Department
Can not be empty
Course_id
VARCHAR (10)
Course number
Can not be empty
Course_name
VARCHAR (20)
Course Title
Can not be empty
Course_num
VARCHAR (5)
Course credits
Can not be empty
Course_grade
VARCHAR (5)
Grade
Can not be empty
ADM_NAME
VARCHAR (10)
Administrator number
Can not be empty
ADM_PASSWORD
VARCHAR (20)
Administrator password
Can not be empty
