College and University Learning Management System

A learning management system is very important for decision makers and administrators, so it should provide users with sufficient information and fast query methods. But people have always used the traditional manual methods of managing files and archives. This management method has many disadvantages, such as low efficiency, poor privacy, and a large amount of files and data is generated over time, which is very useful for searching, updating, and maintaining. Everything brought a lot of difficulties.

The learning management system (LMS Meaning) basically provides a results query and update platform through which students can query information about their progress and student status in various subjects. Using this system, teachers can have a clear and comprehensive view of student learning environments and files, as well as set different permissions for different parts of the system. It can make full use of the various advantages of computers, and has advantages that cannot be compared with manual operation. For example: fast retrieval, convenient search, high reliability, large memory capacity, good privacy, long life, low cost, etc., and it can be used. The ability of a computer system to process data facilitates data analysis and adjustment.

1、Background of the project:Design course on database principles

2、Purpose of the letter:To master the principles of database design and the use of related software.

3、Software defined : University teaching management system

4、Development environment:Visual Studio 2017,SQL Server Management Studio2008。

Two, system design

(1) Functional system design

Teacher Module The teacher module is used to manage teacher information, which contains professor management information, which is useful for managing some teacher information, and is used to record and assign teachers. In the interactive information query, the teacher system has more functions, you can view some student information and adjust grades, manage students, and view some school information.

Student module The Student module is used to manage student information. It can be divided into two modules, one is the student status management module and the other is the course management module. This module can query student grades and courses. For unified management, you can confirm some information and accept some school information through this module on the Internet, and you can perform some necessary operations with this.

(2) Structure of the functional module of the system

Three, database design: LMS Meaning

(1) Demand analysis

Learning management is the most basic management function that all universities should have. The college learning management system can realize simple college and university learning management, including student human research registration, student selection, teacher registration test results, visa exam processing, student performance statistics, teacher workload statistics, and can also query departments, teachers and students at any time , Courses, course selection, assessments, etc.

(2) Conceptual structure design

(3) Logic structure design

(1) Convert each entity to a relational model:

College (number, department name, person in charge)

Teacher (work number, name, gender, department, position, age, date of birth, base salary)

Student (student number, name, gender, age, department)

Course (course code, name course, number of hours, course type, credits)

(2) Relationships between objects are handled as follows:

  1. 1:n relationship between college and student: merge with student relationship model and add college number to student relationship.

Student (student number, name, gender, age, faculty, college number)

  1. 1:n relationship between college and teacher: Merge with teacher relationship model and add college number to teacher-student relationship.

Teacher (position number, name, gender, department, position, age, date of birth, base salary, college number)

  1. 1:1 Responsible contact between course and teacher: merge with course relationship model and add teacher id to course relationship.

Course (course code, course name, number of hours, course type, credits, teacher position number)

  1. The m: n collaborative relationship between the curriculum and the teacher is transformed into a model of independent relationships:

The teacher participates in the course (course number, work number of the participating teacher)

(3) The ER diagram is transformed into the following relationship model:

College (number, department name, person in charge)

Student (student ID, name, gender, age, faculty, college number)

Teacher (position number, name, gender, faculty, position, age, date of birth, base salary, college number)

Course (Course Code, Course Name, Number of Hours, Course Type, Credits, Teacher Position Number)

Instructor Participates in Course (Course Code, Participating Teacher Position Number)

Four, database implementation

The database consists of the following tables:

Student: Student Information Form

Teacher: Faculty and Staff Information Form

Depart: Department Information Table

Grade: Course Information

Table Sc: Course Selection Information Table

Tc: Teacher Program

Leave a Reply

Your email address will not be published.