|
|
Design of a Football Association System for Administration Purposes
Vařacha, Jan ; Vyskočil,, Marek (referee) ; Luhan, Jan (advisor)
This master’s thesis aims to design a suitable system based on a relational database for the purposes of administrative activities of the District Football Association. The created relational database should be managed primarily by the association secretary, to a lesser extent by members of association specialist committees. The database should be able to contain all the information and records which have been dealing with the paper form so far (match fixtures, awarding fines, clubs’ fees, players’ punishments, etc.). Routine administrative work, such as reading, inserting, deleting and updating the data will be carried out through the web interface and should not place any special demands on the level of users computer skills.
|
|
|
Information system for management of cars monitored by satellites
Čech, Dominik ; Skořepa, Michal (referee) ; Cvrk, Lubomír (advisor)
To purpose of this master´s thesis is modernization of database system. This system is designed in Microsoft Office Access program. To create the new system will be used HTML and PHP languages, as a database server will be used MySQL. The first section contains information about data modeling. In the next part there is description of UML language and Use Case diagram for users of system. The main part of the thesis is description of the created system. There are views of screens which can be used by users. Multiuser operation is realized by users rights and definitions enter to the system. The whole database is created as a web application. Application will be uploaded to the company server. Users start the system through their web browser.
|
|
|
Application of system catalogue for database management
Nečas, Jaroslav ; Pfeifer, Václav (referee) ; Kacálek, Jan (advisor)
The purpose of this project is to create a design and subsequently the web application for a database management which uses the system catalogue of the Microsoft SQL database system. The introduction deals with the principle of the relational databases and includes the list of the most widespread database systems. The next chapter of the theoretical part describes the syntax of the SQL query language, and the next chapter deals with the properties of the system catalogue which were utilized. Finally, the last of the theoretical chapters is centred on the .NET platform and its technologies – particularly the ASP.NET and the ADO.NET technologies. The former is used for creating dynamical web pages, and the latter is an object library used for the data access. The practical part of this work comprises the web application scheme on which is the final web application based. The most emphasized issues in this part are the security and the supposed program design of the web application. The final part of the work contains a description of the finished web application, especially the configuration and the functions which the application provides to a user. And finally, the whole project is briefly evaluated in the conclusion.
|
|
|
Documentation possibilities of relational databases
Weis, Richard ; Palovská, Helena (advisor) ; Kučera, Jan (referee)
The intention of this bachelor thesis is firstly dealing with the matter of documentation of extensive relational databases, and secondly, the assessment of existing naming conventions and standards, that are used for easier orientation in non-document databases. I will acquaint the reader with a software for documenting databases and easier orientation of administrators, as well as programmers, during the database development. Finally, I will be offering my own program for relational database documenting management.
|
|
|
Object-Relational Mapping with Framework Hibernate
Berger, Jan ; Pavlíčková, Jarmila (advisor) ; Palovská, Helena (referee)
The bachelor's thesis Object-Relational Mapping with Framework Hibernate is primarily concerned with the description of problems of data persistence of programs written in Java programming language in relational databases. The tool for implementing persistence is object-relational mapping. In the first part of the thesis a concept of object-relational mapping is defined and some problems of its implementing are described. Then an example application is introduced, on which framework Hibernate is demonstrated, followed by the description of structure and architecture of framework Hibernate. The second part of the thesis describes the philosophy and conditions for creating mapping metadata for the individual object structures, using XML and annotation notations. At the end of this part both notations are compared.
|
|
|
Database Design for Bee Research Institute
Smetana, Jan ; Palovská, Helena (advisor) ; Titěra, Dalibor (referee)
The goal of the bachelor thesis is to design a database for the customer Bee Research Institute, Ltd. according to his requirements and specifications. The next step is to create a functional application in Microsoft Office Access 2007 using created design. The thesis is divided into two parts. The first part concerns the theory of database design and the second part deals with the procedure for designing a database for the Bee Research Institute according to the methodology MMDIS. The thesis includes creating a database application with a user interface in Microsoft Access.
|
|
|
Relational and object-relational database schema comparison on concrete aplication
Schuster, Martin ; Palovská, Helena (advisor) ; Svatoš, Oleg (referee)
The main goal of this thesis is to introduce the principles of relational and object-relational databases and demonstrate the advantages of object-relational structural elements. Firstly on theoretical and then on practical level. First part of thesis describes the foundations of databases in general. Then I'm focused specifically on relational databases and their problems related with todays object-oriented programming trends. After that I will mention object databases and principles of object-relational mapping and at the end of theoretical part I will describe structural elements of object-relational model. Practical part of thesis compares relational and object-relational models in context of fictional aplication of ehop. The end sums up the thesis and suggests use of particular model in case of nowadays informational systems.
|
|
|
Implementation of a test for comparison of database systems' performance
Matějka, Martin ; Chlapek, Dušan (advisor) ; Kaltoun, Jan (referee)
The aim of this thesis is to create a program, which will be able to perform a performance testing of relational database systems supporting query language SQL with an emphasis on open source systems. The test should simulate a real usage of tested database systems. In the introduction is shown the necessity of such program (which is supported by the analysis of existing theses and programs in the second chapter) and the fact, that it is convenient to base the test on the TPC-C as a standard for this type of testing in the proprietary sphere, so all the given requirements could be met. The third chapter gives insights into the history of transactional testing and what were the circumstances of the formation of Transaction Processing Performance Council, which authored the TPC-C specification. The main characteristics of TPC-C are decribed in the following chapter, while the fifth one addresses the implementation, i.e. the creation of the program, which can be used for testing of database systems. The sixth chapter deals with the usage of this program for the comparation of two well known open source database systems in their default configuration - MySQL and PostgreSQL. However, the goal of this testing is to find out whether the created program is fully functional, while the seventh chapter elaborates more on this. The most important outcome of this thesis is a program, which can be used for comparation of real-usage-like performance of (not only) open source relational database systems. This program is an open source, which increases its value since a user has a possibility to find out exactly what is tested and how it is done. Furthermore, it supports the future development of this program. Another outcome of the thesis is the comparation of two open source database systems.
|
|
| |
|
|
Data analysis and processing to draw up consolidated financial statements of holding company
Filka, Zdeněk ; Doucek, Petr (advisor) ; Klas, Jan (referee)
In my bachelor thesis I deal with the data analysis and processing to draw up consolidated financial statements of holding company. The object of the bachelor thesis is the utilization of the Structured Query Language (SQL) as a tool of extracting data from relational databases. The main aim is to create SQL scripts, which could process data and on the basis of these data create reports, which could subsequently serve as data bases to draw up consolidated financial statements of company XY. The whole thesis is divided into two parts. In the theoretical part, the purpose is to provide the summary of the SQL, particularly that part of it which helps to query data. This part is called the statement SELECT. On simple examples the procedure of extracting desired data outputs is explained using this statement. This description of the SQL can be used and applied on relational databases in business practice. This problem is dealt with in the practical part. Here I first describe business database and structure of its tables from which the desired data are extracted. Then I define the data requirements to consolidated financial statements, and in the end I create SQL scripts.
|
guest ::
