Development of a client-server information system for the registration of car passes using information from an outdated database

Abstract

Development of a client-server information system for the registration of car passes using information from an outdated database

Vereshchagina E.A., Rudnichenko A.K.

Incoming article date: 18.11.2018

This article describes an existing university database of automobile passes in Microsoft Excel. The university has two databases: permanent and temporary car passes. The negative sides of databases in Microsoft Excel are described in this article. Also, the authors analyzed the possibility of using 1C company software to account for car passes. A new database is described in the Microsoft SQL Server database management system. This article defines methods for unification an outdated database for later migration to Microsoft SQL Server. The main components of the future application software for working with the new database have been designed. By creating additional software, the likelihood of errors in the databases is minimized.

Keywords: database, Microsoft SQL Server, Microsoft Excel, university, car pass, registry, unification, migration, C#, software