|
|
Safety submersion depth of small hydro-power plant Vydra 2 inlet
Jobánek, Stanislav ; Žoužela,, Michal (referee) ; Šulc, Jan (advisor)
The thesis deals the measurement results on a physical model of the inlet part of the small hydro-power plant Vydra 2. The influence of the shape and location of the intake into the pressure pipe of small hydro-power plant Vydra 2 with respect to the water surface state was analysed. The work also deals with possibilities of using devices to eliminate the generation of vortex of higher intensities.
|
|
|
Design of the database for retail
Bača, Marián ; Palovská, Helena (advisor) ; Kučera, Jan (referee)
This thesis deals with analysis and design of database for retail. The goal of this thesis is to create complex database solution covering all needs of the company. The thesis is divided into three parts. The first part explains crucial database terms and approach to create a database design. The second part deals with a requirements analysis and the final part deals with the design of the database. I proceeded from the analysis and requirements gath- ering to database modelling and subsequent testing on the school Oracle database server. The supposed contribution should be the creation of database, which will comply with all necessary requirements and at the same time will consolidate all company data at one place which will result in better data handling.
|
|
|
Design of a database for the administration system of projects of a design studio
Sládek, Daniel ; Palovská, Helena (advisor) ; Kučera, Jan (referee)
Objective of the bachelor thesis was to propose a database for the administration of projects of one design studio. In order to fulfil the main objective there were defined partial objectives, such as the analysis of requirements, design of database and the implementation of databases in MySQL. The thesis is divide into theoretical and practical part, while the theoretical part explains the methodology for the design of database in the thesis and the ER model. The practical part contains the analysis of requirements for a database and then the design of a database, when there is the result of model of databases at the end of each level. You will find a conceptual, logical and physical model of the proposed database in the thesis. Then such database is put into operation in MySQL and then the proposed database is verified according to the criterions of fulfilment in the end. Result of the thesis is the proposed database, which a company will use for the creation of system. Everyone, who wants to create its own system for the administration of projects, may be inspired by the proposed database.
|
|
|
Database design for a company which sells and provides service of machinery
Judová, Eva ; Palovská, Helena (advisor) ; Chalupa, Oldřich (referee)
This bachelor thesis deals with database design for a company which sells and provides service of machinery. The goal of this thesis is to make a complex database solution for the selected company. Component goals are analysis of the issue, development of design and its verification. The database desing follows the traditional methodology's principles. The main contribution is a significant streamlining of work with data which will appear after implementing the database into the company. Problems such as data inconsistency or redundancy will be suppressed.
|
|
|
Designing a database and an application as a parametric web page for hotel owners
Menzel, Aleš ; Palovská, Helena (advisor) ; Chudán, David (referee)
This thesis consists of analysing database requirements, designing and creating a database for the needs of a reservation system and its corresponding parts. The purpose of this thesis is the practical implementation of the database and subsequently creating an application in the form of an administration interface, which is implemented in MySQL database platform and web technologies. Objective of the application is to provide complex system, which connects the parametric administration system with web pages in such a way, that the administrator of the application can manage the application from within the administration section. Requirements for this application and database are based on analysing the competitor's products and my own experience with creating a web application for a small pension. The goal is achieved by designing a flawless database and implementing the application. Furthermore the application proves and validates the database implementation by using test data. Main contribution of the thesis is completed application based on a high quality database model that is ready for deployment in practice. Structure of the thesis consists of two parts. First part describes theoretical basics that are important to know before designing a database and a short introduction to history of database models. The second part is dedicated to designing the database itself.
|
|
|
Database design for communication of a particular company with investors
Kaushik, Ondřej ; Palovská, Helena (advisor) ; Smýkal, Marek (referee)
The goal of this thesis is the analysis and design of a database for a particular company, which operates in the brokerage of investments. Company needs to cover its need for a structured storage of informations about investors. The main focus of this thesis is therefore accurate analysis of the current requirements of the company, identification of users and use cases of database applications. On these bases are created three models using the methodics "The principle of the three architectures (P3A)". The model reflects the anticipated use of the service applications and these are adapted to it. The resulting database is thus defined with the relevant restrictions and the entire database is ready to create for target DBMS (Microsoft SQL Sever 2008 R2) by using a SQL script. The functionality of the entire database is tested using test data.
|
|
|
Design of the database for courier company
Kolman, Michal ; Palovská, Helena (advisor) ; Tomášková, Barbora (referee)
This bachelor thesis deals with the analysis of requirements and design of database for a courier company engaged in food delivery services. The aim of this thesis is to create a database design that would be used for an application enabling dealing with orders and registration of subjects that have access to them. The the-sis is divided into two parts. The first part is devoted to theoretical basis, explanation of important database concepts and how to design a database. The second part deals with the design of the database. I proceeded from the analysis of the courier company across con-ceptual and physical database design to verification of the database with simple commands on the school Oracle database server. The assumed contribution should be an option for employees to track the status of the or-der. The management of the company will have all the information about orders and finan-cial transactions registrated in one place and be able to analyse all the information. Customers should have an easy overview of their benefit program, possibly also of their credit system. Couriers and operators should have an easy overview of cash transactions and the current financial situation of the couriers. On that basis, they should be able to quickly allocate the orders.
|
|
|
Database design for online catalog of music groups
Šimeček, Petr ; Palovská, Helena (advisor) ; Kaltoun, Jan (referee)
The aim of this paper is to describe the various stages of the process of creating the design and subsequent development of a database for the website collects information about music groups, albums and songs. The main emphasis is on optimized connections between entities and database structures and functionality allowing the use of several languages on the site without disrupting the application of the website.
|
|
|
Nonlinear Lateral Pressures and Slip Surfaces of Granular Mass
Koudelka, Petr
In 1997 and 1998 an original experimental equiment was designed and developed including bi-component tensors, a large stand and others. The retaining wall of the stand is measured and can be arbitrarily moved. In 1998 and the first half 1999 was made the first medium-term experiment with a mass of very dry flowing sand which has brought some unexpected and new results.
|
|
|
Design of small laboratory quadruped robot
Švehlák, M. ; Grepl, Robert ; Věchet, S. ; Bezdíček, M. ; Chmelíček, J.
In the article is a sum dectripcion of the design of a small quadrupedal walking robot. The aim of the work is to make a physical model for authenticating computational simulation and other problems related with walking robots. The physical model should be noted for simple design, unpretentious production and relatively small financial coast. The physical model is qualified enough to make various experiments. The actuators are concepted in reference to the character of the loading moment.
|
guest ::
