Database Design on Classification Detailed Account for Educational Materials
Gexin Chang, Wenfeng Song · 2015
Educational Materials management is a complicated system engineering, detailed account management is an indispensable part.According to the deficiencies of the manual detailed account management, the database design of detailed account.First, using the E-R model study conceptual structure design; second, study logical structure design, clarify general principle of the concept model transforms the relation model, study table design of "material detailed ledger head" and "detail of material detailed ledger"; third, study physical structure design, including disk hardware selection, data storage on the disk, create index for improving access performance.This paper is about the fundamental work of educational materials informational construction, it is important reference value for other detailed accounts management too.