Database Design on Rotating Classroom Teaching Resources System based on DB2

Rotating classroom teaching mode is based on abundant teaching resources. This paper is based on the DB2 database management system design. It can provide technical support for the development of teaching resource management system, and to carry out the rotation of classroom teaching mode of service. First, the conceptual structure design was carried out, and the E-R diagram was used to describe the conceptual model composed of five entities and their links; Then, the logical structure design is completed, the E-R model is transformed into the data structure model supported by the DB2 database management system; Finally, the index design is carried out. Five unique indexes and four non-unique indexes are designed according to the index design principle. In the design process, the paper fully considered the characteristics of rotating classroom teaching resources and DB2 database management system. It has the advantages of less data redundancy, clear structure and good integrity.