Course detail

Information Processing

FSI-BZIAcad. year: 2007/2008

The course provides an introduction to information processing. It deals with the following topics: Data organisation. Data processing. Redundancy, inconsistency, integrity, security, data sharing. DBS architecture, data models. Entity-relationship model, relational algebra. Information system design. Fundamentals of SQL (Structured Query Language). Practice in Microsoft Access 2003.

Language of instruction

Czech

Number of ECTS credits

5

Mode of study

Not applicable.

Guarantor

Ing. Radek Poliščuk, Ph.D.

Department

Institute of Automation and Computer Science (ÚAI)

Learning outcomes of the course unit

The course familiarises students with theoretical and practical aspects of data processing. It will provide them with tools necessary for efficient designing of data structures and development of database applications.

Prerequisites

Successful completion of the course "Information Processing" is conditional on basic knowledge of algorithmization and Pascal (or Delphi) language.

Co-requisites

Not applicable.

Planned learning activities and teaching methods

Teaching methods depend on the type of course unit as specified in the article 7 of BUT Rules for Studies and Examinations.

Assesment methods and criteria linked to learning outcomes

The course-unit credit is awarded on condition of having implemented a simple database application in MS Access using basics of Visual Basic and SQL.

Course curriculum

Not applicable.

Work placements

Not applicable.

Aims

The course aims to acquaint the students with basic methods of data processing and their implementation in solving practical problems.

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

Since the attendance at seminars is required, it will be checked systematically by the teacher supervising the seminar. If a student misses a seminar, an excused absence can be compensated for via make-up topics of exercises.

Recommended optional programme components

Not applicable.

Prerequisites and corequisites

Not applicable.

Basic literature

Date, C.J.: An Introduction to Database Systems. Addison Wesley, New York, 2003 (8th edition).
Fortier, P.J.: Database Systems Handbook. McGraw-Hill, 1997.
Lacko, L.: SQL. Hotová řešení pro SQL Server, Oracle a MySQL. Computer Press, Brno, 2003.
Pokorný, J.: Konstrukce databázových systémů. Skriptum ČVUT FEL, Praha, 1999.
Pokorný, J.: Visual Basic pro aplikace Accessu 2000. Kopp, České Budějovice, 2000.
Viescas, J.: Mistrovství v Microsoft Access 2000. Computer Press, Praha, 2000.

Recommended reading

Pokorný, J., Halaška, I.: Databázové systémy.
Pokorný, J.: Visual Basic pro aplikace Accessu 2000.

Classification of course in study plans

  • Programme B3901-3 Bachelor's

    branch B2379-99 , 1. year of study, summer semester, compulsory
    branch B3942-99 , 1. year of study, summer semester, compulsory

  • Programme B2341-3 Bachelor's

    branch B2381-00 , 1. year of study, summer semester, compulsory

Type of course unit

 

Lecture

26 hours, optionally

Teacher / Lecturer

Ing. Radek Poliščuk, Ph.D.

Syllabus

1. Introduction to information systems. Data sorting. Drawbacks of the classical file processing.
2. Database systems, data definition language (DDL) and data manipulation language (DML).
3.-4. Relational algebra, basic operations. Relational algebra as a query language.
5. Design of data structures. Normal forms of relations.
6.-9. Structured Query Language (SQL). SQL SELECT, sorting, grouping, aggregation, subqueries. Update (action) queries. Crosstab query. Definition queries.
10.-13. Visual Basic for Applications (VBA). Definition of constants, declaration of variables, data types. Control structures. Subroutines. Basic objects in VBA and their methods. Event procedures of controls in forms. Calling SQL from VBA.

Computer-assisted exercise

26 hours, compulsory

Teacher / Lecturer

Ing. Pavel Houška, Ph.D.
Ing. Jiří Liška
Ing. Tomáš Marada, Ph.D.
prof. Ing. Radomil Matoušek, Ph.D.
Ing. Oto Ondráček
Ing. Radek Poliščuk, Ph.D.
doc. Ing. Stanislav Věchet, Ph.D.
Ing. Miroslav Zbořil

Syllabus

MS Access 2003.
Basic statements (creation and modification of database structures, input and modification of data, deletion, view).
Creation of Relationships among data files.
Information searching.
Structured Query Language (SQL) in MS Access.
Programming in MS Access, macros.
Forms, event procedures of form controls.
Creation of reports.
Linking and embedding of objects, OLE objects.
Data transfer between MS Office applications.