Design of course selection system

Database design

Give the relational pattern:

User ( number , password)

Students ( School number , grade, major, other information)

Teacher ( teacher work number , department, other information)

(Students, teachers are children of the user)

Course ( Course number , course name, starting class, teacher, time, class teacher, number of students, prerequisites)

Courses ( course number, student number ) Course number Reference course number, student number reference. School Number

Classes ( course number, teacher's number ) Course number reference course number, teacher work number reference teacher. Teacher work Number

Student achievement ( course number, school number, score) course number, study number reference elective course. Class number, elective course. Student number

Class diagram Design

Interface design

No, the book's example is not read ...

Design of course selection system