|
|
Database design for the anthropological department of the National Museum in Prague
Velemínský, Filip ; Palovská, Helena (advisor) ; Havelková, Petra (referee)
This bachelor thesis deals with the analysis, design and implementation of a database for the anthropological department of the National Museum in Prague. The aim was to propose a comprehensive database solution which includes an analysis of the needs of the department, the design of a conceptual and physical database model, then to create an application in MS Access and, finally, to verify the accuracy using test data. The database was designed on the basis of consultation with the employees, who helped to clarify the issue, so the database was adjusted according to their requirements. This comprehensive database solution will allow the employees of the anthropological department better control over their collections and, consequently, more effective work with them.
|
|
|
Evaluation of CASE tools for database design
Brotánek, Jan ; Chlapek, Dušan (advisor) ; Bruckner, Tomáš (referee)
The focus of this thesis is on designing a process which can be used to evaluate data modeling CASE tools and tools supporting database designing. It maps requirements which are currently imposed to these tools and based on them defines criteria for their evaluation. Process is tested on a set of commercial CASE tools as well as open-source tools. Tools are evaluated based on set criteria and a product which best meets these requirements is recommended. The process is evaluated, modified and published as a seperate attachment after a verification process which uses a set of tools.
|
|
|
Comparison of relational database schema and XML structures
Vodňanský, Daniel ; Palovská, Helena (advisor) ; Řepa, Václav (referee)
The work deals with the relationship of the relational model and XML schema document and its technological and pragmatic aspects. It defines the theoretical field of data modeling at conceptual level and the two mentioned possible implementation models at the physical level. The aim is to answer the question when in the design and development of application or system it is appropriate to proceed with one of these models. Furthermore, this work also provides a general procedure for mapping conceptual schema into XML schema structures and solutions to problems that can come across during the mapping process. The problem is solved by analyzing two real issues - timetables of public transportation and the information system of a swimming school, formalized through a mechanism of predicate logic. Unlike most works on a similar topic this one varies in a pragmatic view on the problem - the concept of data, their origin, their target user and structuring.
|
|
|
Complex database solution design for Gemini ophtalmology clinic
Kadlec, Jakub ; Palovská, Helena (advisor) ; Sramka, Martin (referee)
The aim of this bachelor thesis is to provide a complex analysis and database solution design for Gemini ophtalmology clinic in Zlín, Czech Republic. The clinic handles a large amount of data on a daily basis being used by doctors, administrative workers, but as an essential background dataset by robotic surgical machines as well. Currently, the data is being transmitted via physical data files, which inevitably goes with a big probability of subjective errors and data redundancy. The analysis has been based on multiple interviews with Gemini's IT personnel and the models are result of throughout research of clinic's business and information processes. At the beginning of the thesis, there is a theoretical introduction to database analysis and design, followed by a complex database solution design, including features from object-relational database systems which can be helpful considering that the database will be connected to the robotic surgical machines. Their programmatic interface is written in C#, which is an object oriented language, and the thesis describes ways how object features in otherwise fully relational database can result in easier and more straightforward data manipulation. As a result, this bachelor thesis could serve as an inspiration in modernizing technology infrastructure design in a field which is very conservative and is adapting modern approach very slowly.
|
|
|
Internet shop in Nette
Okosy, Michal ; Sklenák, Vilém (advisor) ; Vojíř, Stanislav (referee)
This thesis is covering the creation of the internet shop for the Caryawood s.r.o. company. Its main aim is to create functional internet shop for that company. This aim will be obtained by accomplishing three sub-goals - theoretical determination of technologies and methods usually used for the creation of internet shops; layout of the database for the particular shop; and the programming of the shop itself, with the use of Nette framework. The thesis is divided into three chapters. First two chapters are theoretical and there is the description of technologies and methods used for the making of websites and internet shops. Third chapter is practically focused and there is a description of the realisation of the particular shop - from the stipulation of client's demands to the layout of the database and structure and example of programmed solution. The output of this thesis is electronic shop on the website www.caryawood.cz.
|
|
|
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.
|
|
|
Budget Database
Maček, Lukáš ; Palovská, Helena (advisor) ; Bednář, Oldřich (referee)
This thesis deals with analysis, design and implementation of database in telecommunication company. The thesis consists of existing data structures analysis, functional requirements analysis, new data structures design, data consolidation and migration into new data structures and application implementation. Primary goal is monitoring of budget.
|
|
|
Complete data model of ITIL
Gažmerčík, Jakub ; Bruckner, Tomáš (advisor) ; Chlapek, Dušan (referee)
The objective of this thesis is to design a complete ITIL (IT Infrastructure Library) data model by using Entity-Relationship diagram and the argumentation of this model in relation to ITIL Configuration and Asset Management federative approach. The thesis is build of two major parts, where the first one focuses on the theory of recommendations and best practices in the IT Governance processes, its relationship to ITIL and a high-level overview of ITIL history. Theoretical part ends with the brief description of tools and methods used in data modeling. It is followed by practical part in which the content is based on analyzing of ITIL publications in the same order as IT Service Management life cycle phases and designing of the logical data model. Each chapter discusses at its end the abiliity of designed model to cover the data requirements for particular ITSM lifecycle phase. In the very last chapter, all partial models are joined into one complete data model and shown relations are argumented.
|
|
|
Selection of available CASE tools
Šmahel, Martin ; Chlapek, Dušan (advisor) ; Řepa, Václav (referee)
This bachelor's thesis is aimed at search, selection and comparison of CASE tools for data, object and process modeling and teamwork management. The contribution of this thesis is a recommendation of a suitable tool for computer science courses teaching at the University of Economics in Prague. Research of favorable academic pricing and licensing conditions that can be applied during acquisition of selected tools is also a part of this thesis. In the first part of the thesis requirements of courses in particular functional areas are defined. Criteria for tools comparison are drawn up from these requirements. The next part is focused on CASE tools market research and tools for the comparison selection. Selected tools are compared using defined criteria and their academic pricing deals are explored. The last part of the thesis contains recommendation of an affordable CASE tool to support teaching at the University of Economics.
|
|
| |
guest ::
