Creating the Conceptual and Logical Model of a Journal Database

This article describes the process of creating the conceptual and logical model of a journal database. To efficiently extract the information from the articles published in the journal so far, the idea of creating a database has emerged. To create a database, it is recommended to design a high-level conceptual model and convert that into a logical data model. The benefit of the thoughtful design is that it shows the structure of the database in an easily comprehensible form. The entity-relationship model is a fast and efficient way to create the conceptual model and it can be easily converted to a relational database model, which is a logical model. The initial version of the entity-relationship model of the journal database had one entity type, 25 attributes, and no relationship. The final version contained three entity types, 39 attributes, and three relationships. This final conceptual model was converted to a logical model, the relational model. The result was ten tables to store entity data with 22 different fields and another three tables to ensure the relationships between the tables. The developed model can be created in a relational database manager and is suitable for serving information needs related to the journal

Creating the conceptual and logical model of a journal database

This article describes the process of creating the conceptual and logical model of a journal database. To efficiently extract the information from the articles published in the journal so far, the idea of creating a database has emerged. To create a database, it is recommended to design a high-level conceptual model and convert that into a logical data model. The benefit of the thoughtful design is that it shows the structure of the database in an easily comprehensible form. The entity-relationship model is a fast and efficient way to create the conceptual model and it can be easily converted to a relational database model, which is a logical model. The initial version of the entity-relationship model of the journal database had one entity type, 25 attributes, and no relationship. The final version contained three entity types, 39 attributes, and three relationships. This final conceptual model was converted to a logical model, the relational model. The result was ten tables to store entity data with 22 different fields and another three tables to ensure the relationships between the tables. The developed model can be created in a relational database manager and is suitable for serving information needs related to the journal

Transportations Habits of Szeged City Residents

A smart (or liveable) city is a settlement which is able to utilize the available technological possibilities and particularly the infocommunication devices in an innovative way in order to develop a sustainable environment. A sustainable urban environment is increasingly necessary since the portion of urban population is constantly growing. This might require the rethinking of the development of traffic in the city as well. In 2015 a survey was conducted in Szeged related to the ongoing smart city project. The main goal of the survey was to get information about the transportation habits, opinions and expectations of the city residents. This paper summarizes some of the interesting results of the research in the field of public transport, bicycling, car transport, parking and walking. The research methods used were descriptive statistics, measuring relationship between variables and hypothesis testing. The results can also be the base of a later similar survey, where the possible financial consequences of the expectations are also communicated to the participants

Alkalmazás fejlesztése egymintás u-próba kiértékelésére VBA vezérlőkkel Excel környezetben

Az egymintás u-próba elvégzésére kifejlesztett alkalmazás a Microsoft Excel programozhatóságát nyújtó Visual Basic for Applications szolgáltatással készült el. Egyetlen párbeszédablak biztosítja a felhasználói felületet az adatok megadásához és az eredmények megjelenítéséhez. Eseményvezérelt programozási technika teszi lehetővé, hogy felhasználóbarát módon viselkedjen a program, reagálva a kezelőfelület vezérlőin bekövetkező eseményekre. Az alkalmazás egyszerű kezelhetőségével az Excel táblázatkezelő program használatának ismerete nélkül végezhető el az egymintás u-próba kiértékelése, melynek során a megjelenített eredmények értelmezése sem igényel matematikai statisztikai jártasságot. A számításokhoz szükséges adatok megadhatók a minta teljes adatsorával, de a minta elemszámával és átlagával is. Abstract: Developed to perform a one-sample z-test, the application is built with Visual Basic for Applications, which provides programmability for Microsoft Excel. A single dialog box provides a user interface for entering data and displaying results. Event-driven programming technology allows the program to behave in a user-friendly manner in response to events that occur on the interface controls. With the easy operation of the application, the evaluation of the one-sample z-test can be performed without knowledge of the use of the Excel spreadsheet program, during which the interpretation of the displayed results does not require mathematical statistical skills. The data required for the calculations can be given with the complete data set of the sample, but also with the number of elements and the average of the sample

Excel VBA űrlap kialakítása egymintás t-próba kiértékeléséhez

A Microsoft Excel program Visual Basic for Applications szolgáltatásával kialakítottunk egy felhasználóbarát felületet egymintás t-próba elvégzésére. Így akár az Excel táblázatkezelő használatának ismerete nélkül is lehetőség van az egyik leggyakrabban megjelenő hipotézisvizsgálat, a t-próba elvégzésére. A használathoz elegendő megnyitni az elkészített alkalmazást, s a megjelenő ablakban a szükséges adatok és opciók beállítása után megkapjuk az eredményeket. A program vezérlőkkel biztosítja a könnyű kezelhetőséget, míg a működést eseményvezérelt programozási technikával alakítottuk ki. Az eredményeket megkaphatjuk a betáplált minta adatsor alapján is, de a minta főbb jellemzői, az elemszám, az átlag és a szórás értékéből is. A vizsgálandó hipotézis megadásakor tetszőleges reláció alkalmazható, s ettől függően kétszélű vagy egyszélű eset egyikeként, automatikusan kapjuk meg az eredményeket. Az alkalmazás használatával matematikai statisztikai ismeretek és statisztikai programcsomag nélkül végezhetjük el az egymintás t-próbát. Abstract: Using Visual Basic for Applications in Microsoft Excel, we designed a user-friendly interface for performing a one-sample t-test. Thus, even without knowledge of the use of the Excel spreadsheet, it is possible to perform one of the most common hypothesis tests, the t-test. All you have to do is open the completed application and in the window that appears, you will get the results after setting the required data and options. The program provides easy operation with controls, while the operation is designed with event-driven programming techniques. The results can be obtained from the data set of the fed sample, but also from the main characteristics of the sample, the number of items, the mean and the standard deviation. When specifying the hypothesis to be examined, any relation can be used, and depending on this, we obtain the results automatically as one of the doubleedged or single-edged cases. Using the application, we can perform the one-sample t-test without mathematical statistical knowledge and statistical software package

Some thoughts about data and information

This paper focuses on some aspects of data and information and gives a short overview based on the professional literature: Why it is necessary to collect, process and store data and information? What is the difference between the two concepts? Can they be distinguished and how? What is the role of information in the different stages of decision-making? How many ways information can be grouped and what are the main sources of the data? How much and what type of information do enterprise executives need at each leadership levels? What is an information crisis and how can it be avoided? If information is a resource of the enterprise what is its value? Does it have value at all? What are the consequences of the information explosion and how can it be handled