|
|
Physical axle model for dynamic tests
Bělunek, Matěj ; Dočkal, Aleš (referee) ; Mazůrek, Ivan (advisor)
The aim of this thesis is the design of a physical axle test station, along with a virtual dynamic model, with the purpose of vehicle suspension tests. The axle, or half-car, model is the answer to the inaccuracies of the most widely utilized suspension model, and the high cost of the full vehicle testing. The motivation for the new test station and its virtual model is the prospect of accurate, quick and effortless testing and optimization of the vehicle suspension characteristics. The existing solutions in most cases substitute actual suspension elements (axle) and wheels with auxiliary parts leading to a departure from reality. The design of the new test station is based on the analysis of current physical model solutions and in accordance with set requirements. The tester substitutes the vehicle Škoda Fabia I Hatchback and utilizes its actual rear axle including suspension elements. The assembled rig, or rather its functionality, is successfully experimentally verified. The created virtual dynamic model, using ADAMS software, is identified against the designed test station, while the obtained simulation results are compared with the experiment data. Meeting the experiment predictions and virtual model results validates the tester’s ability to sufficiently reflect real car suspension behaviour and it is ready for further vehicle spring and damping properties testing.
|
|
|
Physical axle model for dynamic tests
Bělunek, Matěj ; Dočkal, Aleš (referee) ; Mazůrek, Ivan (advisor)
The aim of this thesis is the design of a physical axle test station, along with a virtual dynamic model, with the purpose of vehicle suspension tests. The axle, or half-car, model is the answer to the inaccuracies of the most widely utilized suspension model, and the high cost of the full vehicle testing. The motivation for the new test station and its virtual model is the prospect of accurate, quick and effortless testing and optimization of the vehicle suspension characteristics. The existing solutions in most cases substitute actual suspension elements (axle) and wheels with auxiliary parts leading to a departure from reality. The design of the new test station is based on the analysis of current physical model solutions and in accordance with set requirements. The tester substitutes the vehicle Škoda Fabia I Hatchback and utilizes its actual rear axle including suspension elements. The assembled rig, or rather its functionality, is successfully experimentally verified. The created virtual dynamic model, using ADAMS software, is identified against the designed test station, while the obtained simulation results are compared with the experiment data. Meeting the experiment predictions and virtual model results validates the tester’s ability to sufficiently reflect real car suspension behaviour and it is ready for further vehicle spring and damping properties testing.
|
|
|
Database design for company Ceskoslovensky autoslalom
Rocheva, Arina ; Palovská, Helena (advisor) ; Tomášková, Barbora (referee)
This bachelor thesis deals with the design of a database model for Ceskoslovensky autoslalom z. s., which organizes automobile races. The main goal of this thesis is to make a complex database model, corresponding to the current situation of the company. The theoretical part describes the methodology used in this thesis. The practical part contains the database creation process. First, there are identified requirements for the new database system. Then conceptual and physical database designs are following. Database created in the MySQL database system and tested in Microsoft Access. The contribution of the thesis is to ease and optimize data management in the organization after the database implementation.
|
|
|
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.
|
guest ::
