There is a need of storing and keeping track of things. As the amount of information increases, so does the demand for suitable applications that can manage the data. This thesis has had its focus on developing a web administration interface for relational databases, where the focus has been on managing and visualizing the data, where relationships between data within the database could be predicted through an algorithm. During the thesis, it was revealed that administrators can utilize naming conventions for databases, a property which can be used to predict its relationships. Furthermore, existing applications for managing databases has been compared with the thesis' implementation. Notable differences are that existing solutions are focused towards the structure of the data, rather than the data itself. To accomplish all this, an agile method was chosen for fast results within the deadline, together with standardized web development tools and JavaScript frameworks. The resulting implementation consists of a front- and backend. The frontend was developed using the Ember.JS framework for making web applications and the backend was implemented using Node.JS, together with a component for handling different database dialects called Sequelize. It has been concluded that the prototype this thesis has resulted in works as a proof of concept, complete with a prediction algorithm that can suggest relationships within databases that utilizes convenient and consistent naming conventions. In the future, further research and tests could be conducted to evaluate the security, reliability and usability of the application, to ensure its production quality.

SCA transports timber via rail from railway terminals in western Sweden to saw and/or pulp mills located on the east coast. Sometimes timber wagons are lost due to damages inflicted when loading the wagon. Wagons can also be decommissioned for maintenance conducted by the Swedish Transport Administration. Both situations are unpredictable and causes many types of problems. If the wagons could be automatically traced these problems could be predicted and pre-emptive actions could be taken. All wagons used by SCA are equipped with RFID tags and RFID readers are installed at the railway terminals. The purpose of this thesis is to equip the RFID readers with Internet access, collect the data read by the RFID readers and present this data in a single page web application. The actual data collection is done by an already existing system which pushes the train data to the back-end part of the application. The front-end part is made with a JavaScript framework named Ember.js and the back-end part is made with ASP .NET Web API and SQL Server. The application is finished and verified with various tests but is not put in production due to a negotiation delay between SCA with a third-party consultant.