摘要
在论述中国加入WTO后ERP系统应用现状的基础上,分析了关系数据库的建模方法,重点对用ERwin这一关系数据库应用开发的优秀CASE工具的应用进行了研究,提出了ERP系统的功能模块的组成,借助ERwin建立了ERP系统的信息模型,给出了其逻辑模式和物理模式的视图及其向具体数据库物理结构的转换方法。以SQLServer作为后台数据库支持,Delphi为前台界面开发工具,建立了一个ERP系统。为企业的ERP的研究和应用提供了一种方法和思路。
Based on the discoursing upon the applying status of ERP system after China joined in WTO, Analyzes the modeling method of relational Database, emphasizes on the research on ERwin that is the excellent CASE tool for developing relational Database application. Puts Forward the function modules that compose ERP system, builds up the information model of ERP system in virtue of ERwin, gives out its logical view and physical view and the generating method for concrete Database physical scheme, Finally, with SQL Server acting as background database and Delphi being the tool for developing front platform, a ERP system is set up. It provides the typical method and thinking way for the application and research of enterprise's ERP.
出处
《微计算机信息》
北大核心
2006年第05X期26-28,共3页
Control & Automation
基金
江苏省教育厅自然科学基金资助项目(05KJB510004)
国家科技成果重点推广项目(2005EC00157)