Database Design on Rotating Classroom Teaching Resources System based on DB2

DOI

10.2991/msmee-17.2017.285How to use a DOI?

Keywords

DB2; rotating classroom; teaching resources; management system; database design

Abstract

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.

Copyright

© 2017, the Authors. Published by Atlantis Press.

Open Access

This is an open access article distributed under the CC BY-NC license (http://creativecommons.org/licenses/by-nc/4.0/).

Download article (PDF)

TY  - CONF
AU  - Zuoyou Yin
PY  - 2017/05
DA  - 2017/05
TI  - Database Design on Rotating Classroom Teaching Resources System based on DB2
BT  - Proceedings of the 2017 2nd International Conference on Materials Science, Machinery and Energy Engineering (MSMEE 2017)
PB  - Atlantis Press
SP  - 1584
EP  - 1588
SN  - 2352-5401
UR  - https://doi.org/10.2991/msmee-17.2017.285
DO  - 10.2991/msmee-17.2017.285
ID  - Yin2017/05
ER  -