Design and implementation of a database for an integrated system for daily management in an industrial and commercial organization

• Main Author: Trigui, Noureddine
• Other Authors: Shing, Man-Tak
• Format: Others
• Published: Monterey, California. Naval Postgraduate School 2012
• Subjects: Database design; Database management; Client/server computing
• Online Access: http://hdl.handle.net/10945/1338

Approved for public release; distribution is unlimited === The purpose of this research is to define a centralized database containing all necessary information related to the daily management in an industrial and commercial organization that is publicly owned and equipped with civil personality and financial autonomy. The system is composed of the following subsystems: o Subsystem "Human resource management" o Subsystem "Provisioning" o Subsystem "Financial, budgetary and accounting management" The three subsystems should be installed in a central site and at regional sites. Each site will have its own database. The central database will be supplied with the data, which come from the other sites at the end of the day or according to need via modems. It is necessary to develop a tool for remote database queries in order to accomplish this work. The platform on which the application must be executed is IBM-INFORMIX running on top of the WINDOWS operating system. The database will be a relational database. The framework used in the design and modeling consists of: o Object Oriented Analysis (OOA), which enables the development of high quality software by defining the problem structure. o The Delphi Language, which provides a robust development environment. The installation of the solution will be executed according to the following scenario: o Client/Server architecture with the object oriented development tool DELPHI. o The database will be installed on the central and regional servers. o The application will be installed on the end users' stations. o Data access will be through an open ODBC. This software will present an integrated solution that will provide centralized and accurate data, so that data will be used to derive the right decision at the best time. === Major, Tunisian Army