Application for management of the computer equipment inventory

The goal of this project was to design an online application through which one will be able to store, browse and work with data about computer and information equipment in a company and also its users, in a way where data tables can also be dynamically connected to each other. The field of this project includes the design and programming of an online application and creation of a database, based on given basic requirements and the prior examination of similar applications, considering the nature of information that will be stored and used. For this the WampServer web development environment is used together with Apache server. The main programming languages for the web application are HTML and PHP, where for the database management SQL language is used. After the basic requirements are clearly defined, application functions are developed based on the basic required data tables. Afterwards the functionality of these functions is expanded and adjusted to work with any table in the database that may be created in a later time according to the emerged needs. In development of this online application a method of agile software development is used where functions are designed in steps and as modules. In this way the programming is simplified and made more flexible. In development of the database the entity-relationship model is used as defined by Crow’s foot notation for description of the relationships between the data tables. The result of this project is a basic finished online application that includes all the goal functions defined in the beginning, such as user management and tools for working with data tables, which includes entering data, editing, searching, sorting, printing of report, noting change history, exporting of data, adding of new tables and creating dynamic table connections, where the rights for the use of functions can be set according to the category of users. The application represents a simple to use tool for online database access and data table management with possible user access restrictions. In conclusion all the set goals of the project were achieved and also some new ideas were already created during and after the development for possible improvements and upgrades that could be simply implemented in the future, considering the modular design of the application