Course detail

Databases systems

FEKT-BDBSAcad. year: 2017/2018

Architecture of RDBMS. Types of data, operations with data. Introduction in data and system analysis. Fundamentals of data and system analysis. Relational database design. Normalization-based design of relational database. Languages of 4 ans 4.5 generations. Transaction processing. Client/server architecture. Databases and internet. XML techology. Data security, data sharing.

Language of instruction

Czech

Number of ECTS credits

6

Mode of study

Not applicable.

Guarantor

Ing. Radovan Holek, CSc.

Department

Department of Control and Instrumentation (UAMT)

Learning outcomes of the course unit

Students are able to developp conceptual models of an application for relational database in client/server and internet environment. Students have basic knowledge of database management system fundamentals.

Prerequisites

The subject knowledge on the secondary school level is required.

Co-requisites

Not applicable.

Planned learning activities and teaching methods

Techning methods include lectures, computer laboratories. Students have to write a single project of IS in any BDMS.

Assesment methods and criteria linked to learning outcomes

Finaly project with basic properties:
Data integrity,output forms with simple and cumulative items,Different roles forapplication users and administrators.
max30 points Project description, ERD, FD, ELH. Data distionary, List of events, minispec.
max 70 points Presentation of functioinal aplication

Course curriculum

1. Basic relational database terms. Basic Data types.
2. Relational model. Entity, attribute, cardinality, index, primary key, foreign key.
3. Database normalization, functional dependency, 1NF,2NF, 3NF, 4NF.
4. Logical and physical model. ERD, Data flow diagram, ELH.
5. Functional model, data flow diagram.
6. Design of forms.
7. Data integration.
8. SQL language for data manipulation and definition.
9. Database transaction.
10. Client server architecture, Thin client, Fat Client, differences.
11. Database security, Roles, Users.
12. Internet applications, xml technology.
13. web servicess, SOAP,WSDL.

Work placements

Not applicable.

Aims

Mastering fundamentals of design and development database applications.
Mastering fundamentals of relational database theory and skill in using database technology at a level required for database design.
Development of database applications for multiuser and internet access and database administration.

Specification of controlled education, way of implementation and compensation for absences

The content and forms of instruction in the evaluated course are specified by a regulation issued by the lecturer responsible for the course and updated for every academic year.

Recommended optional programme components

Not applicable.

Prerequisites and corequisites

Not applicable.

Basic literature

Korth H.F, Silberschatz,A.:Database System Concepts,McGRAW-HILL. 1996 (EN)
Král, J.: Informační systémy, Science Velenity 1998, 358 str.,ISBN 80-86083-00-4 (CS)
Ramakrishnan R'.:Database Management Systems,WCB/McGraw-Hill,1998 (EN)
Šimůnek, Milan SQL Kompletní kapesní průvodce Grada Publishing ISBN 80-7169-692-7 (CS)

Recommended reading

Hernandez, Michael J. Návrh databází. Přeložil Jan Bouda 1. vyd. Praha :GradaPublishing a.s.2006 (CS)
Kofler, Michael. Mistrovství v MySQL 5 : Kompletní průvodce webového vývojáře. Computer Press, 2007 ISBN 978-80-251-1502-2 (CS)
Ráček, J.: Strukturovaná analýza systémů, Masarykova univerzita, ISBN 80-210-4190-0

Classification of course in study plans

  • Programme EECC Bc. Bachelor's

    branch B-AMT , 3 year of study, summer semester, elective specialised

  • Programme EEKR-CZV lifelong learning

    branch EE-FLE , 1 year of study, summer semester, elective specialised

Type of course unit

 

Lecture

26 hod., optionally

Teacher / Lecturer

Ing. Radovan Holek, CSc.

Syllabus

Introduction, data abstraction, data models
Conceptual model, E-R diagrasms
Fundamentals of programing in Magic for windows system
Data types and operations
Batch tasks and interactive tasks
Mid-term exam passing Data integrity
Events and trigers
Transaction processing, concurrency developing
Security and data integrity
Fundamentals of database applications for Internet
HTML language and development of dynamic HTML formas, XML Technology
Data security of databases on Internet
Distributed systems, trends in database technology

Exercise in computer lab

39 hod., compulsory

Teacher / Lecturer

Ing. Radovan Holek, CSc.

Syllabus

Introduction to Magic development tools
Type repository, Table repository, Program repository
Helprepository, Rights repository, Context menu
Batch and interractive tasks
ER diagram prototype functionalmodel
Building of Database application. Program repository
Operations, procedures and functions, project developing
Individual project developing
Transaction and locking strategy
Forms outputs
Reports, Internet forms and reports
Autorisation, DBA rights and users rights
Project presentation,