|
|
Creation of Database Services for Travel Agencies
Kadlčík, Petr ; Vajdík, Robert (referee) ; Kříž, Jiří (advisor)
This thesis focuses on the design and creation SQL database. The resulting database design should find application in the field of tourism, which would simplify the problematic situation, relating to the verification of free accommodation capacity, transportation capacity and making reservation. Part of this work is to analyze the current situation, the problem specification, theoretical background and custom design solutions.
|
|
| |
|
|
Production information system of small firm
Drozd, Martin ; Neuwirth, Bernard (referee) ; Dydowicz, Petr (advisor)
This diploma thesis deals with the issues concerning the creation a part of information system for a company that has so far been usány this information subsystems in paper form, which has been ceasing to fulfill the company's requirements and needs. Based on a current situation analysis, deficiencies of the existing information system are discovered, which might be eliminated by several proposed solutions. These proposed solutions are examined through previously chosen criteria and based on this optimalization, the optimal solution will be chosen. Furthermore, this solution will be evaluated from the economic point of view and through other perspective benefits, which the solution might bring for the company.
|
|
| |
|
|
Database Design for a Selected Company
Bartoš, Jan ; Kříž, Jiří (referee) ; Luhan, Jan (advisor)
The aim of this thesis is to design a database for a selected company, which concerns the creation of production labels. Within this thesis I am going to concentrate on designing the structure of the database and its implementation. The database will be implemented on the Microsoft SQL Server platform using the tools of Microsoft Management Studio.
|
|
|
Administration of development documetation over WWW II
Gregárek, Ondřej ; Sysel, Petr (referee) ; Balík, Miroslav (advisor)
Document server is a web application controllable by way of web browser. It is meant to serve for the management of development documentation. The application is divided to the four basic parts: Requirements, Products, Tests and Test Run. The section Requirements serves for inserting requirements for products. Product is produced on the basis of these needs and registered in part Products. Test setting is created in the part Tests according to requirements from the part Requirements. Particular products are then tested. The part Test Run registers records of these tests. These are parts of the application: management of users, connecting supplements to records, printing and exportation of data to different formats, saving history of records, filtration and sorting of entries, etc. All the data is saved in the database MySQL. The application is written in scripting language PHP. Data is presented by template system Smarty. The output is in language XHTML. Cascading style CSS is used to formatting. This work describes development of the application. First it is dealing with the proposal of the database, connection and structure of particular tables. The function of the programme is explained in detail at the same time, which is essential for the correct proposal of the database. The application is based on the database. The selected structure of files and relations of scripts to library functions are shown. The template system and the interface for access of the programme to the database are explained. The most attention is paid to the description of solving important functions of the application, i.e. listing of records, their pagination, filtration, sorting and operation with them: saving, browsing, copying, confirmation and work with history, category and problems by upkeep of consistent tree and export of data to various formats. It is always outlined the problem, the idea of solving and the description of appropriate scripts. Samples of source code are also included for better understanding of complicated algorithms.
|
|
|
Database Design for Specific Company
Kúdela, Lukáš ; Neuwirth, Bernard (referee) ; Luhan, Jan (advisor)
The bachelor thesis deals with the design of a database for effective functioning of the specific company operating in the field of tourism. Based on an analysis of the business environment as well as internally established processes and needs, it presents a data model for an operational reservation system. The proposal provides a database solution functionally covering daily activities associated with securing client reservations, but also the support of hotel management decisions.
|
|
|
Methods of access to PostgreSQL databases in .NET Framework
Henzl, Václav ; Kouřil, Jiří (referee) ; Lattenberg, Ivo (advisor)
The results of this work are two major projects - NpgObjects and PagedDataGridView. NpgObjects is a simple ORM framework to enable the mapping database tables to objects in the common language runtime. It contains a specially designed generator which generates classes in C# from information obtained from the database. These classes are mapping on the database tables one to one. NpgObjects allows all the basic database operations - SELECT, INSERT, UPDATE and DELETE. PagedDataGridView is a component for displaying tabular data. In cooperation with NpgObjects can paginate database data and manage the flow of data into application. It provides a comfortable user interface, which can easily navigate between different pages of data.
|
|
| |
|
|
Relations and their applications
Čulíková, Markéta ; Novotná, Jarmila (advisor) ; Zamboj, Michal (referee)
The thesis deals with relations and their applications. The first chapter summarizes the introductory theoretical knowledge that is necessary for understanding the topic relations: an element, set, ordered pairs, Cartesian Product. The important definitions are introduced for all of these concepts and the related information is summarized within this chapter. The second chapter defines the concept of relations and operations on them. It includes various types of graphical representations of relations and their advantages and disadvantages. The concept of relation on a set and the properties of this relation alongside with some special types of relations derived from them are introduced in this chapter. The concepts of function are also defined in this part of the thesis. The third chapter indicates the relations that appear in real life - in relationships and games, in curriculum and puzzles. The properties of those relations are determined and the knowledge of relations and their properties is used to facilitate the solution of logical problems. It also supports gaining deeper understanding of those problems. The thesis includes two groups of tasks. The first one covers elementary tasks related to the topic of sets, ordered pairs, Cartesian Product and relations. The second part is concerned with...
|
guest ::
