Creation of Structured Formatted Database for Alumni Project

Abstract

An Alumni club, made up of former students, has been working at several prestigious Faculties of the University of Belgrade for a long time. Thanks to the contacts through this organization, as well as the help of former students of these Faculties, a large number of newly graduated students received useful advice first-hand, as well as the possibility of employment in successful companies in the country and abroad. The Academy of Applied Technical Studies Belgrade followed this example and formed Alumni Clubs in its departments and sections. In this way, the Alumni Club started working in the Computer-Mechanical Engineering Section. It took time for students who had graduated a long time ago to sign up for the club, but the response of students is getting bigger and bigger, so the need to create a database and appropriate applications emerged. A database in SQL server is created, after which advanced and automated queries for obtaining relevant data are developed in form of stored procedures. This paper presents two approaches to creating a formatted database in XML language, in order to enable better connection with the most popular programming languages such as Java, ASP.NET, C#, ColdFusion and others. In the first approach, selecting the appropriate button creates an XML document, and in the second approach filling in the text fields in the application, which is developed in the C# programming language, leads to its creation.