基于工资信息管理系统的数据规范化研究

Research on the Data Normalization in Salary Information Management System

在关系数据库的逻辑设计中,针对一个具体问题,应该如何构造一个适合它的数据模式,即构造几个关系模式,每个关系由哪些属性组成,对于减少数据冗余、提高数据操作效率和空间利用率等都是非常重要的。基于对贵州省高校工资信息管理系统数据库设计的研究,分析每级关系模式存在的问题,并依照数据规范化理论为指导,对存在数据冗余的关系模式进行分解,体现了该理论在实际应用中的优化指导作用。

It is very important to find a way to make a proPer data model to a real object when logically designing a relational database, that is to form a few relational models, to make sure the attributes of each rely avoid the data redundancy,improve the effect of using the data and can also advance the usage of space. The usage of data normalization in design was analyzed based on the logical data design of salary information management system.