Course detail

Information Systems II

FAST-0U5Acad. year: 2010/2011

Database technology fundamentals, terminology, data modelling.
Relational data model, relation algebra, data integrity.
Conceptual modelling, Entition-Relationship diagrams, RDBMS languages, SQL language.
RDBMS architecture.
Microsoft Access, Microsoft SQL Server.
The goal of the course is practice of analytical skills. As a project students develop a simple database system in chosen production branch.

Language of instruction

Czech

Number of ECTS credits

2

Mode of study

Not applicable.

Guarantor

Ing. Miluše Kutínová

Department

Institute of Computer Aided Engineering and Computer Science (AIU)

Learning outcomes of the course unit

Not applicable.

Prerequisites

Basics of Informatics, common office software like MS Office

Co-requisites

Not applicable.

Planned learning activities and teaching methods

Not applicable.

Assesment methods and criteria linked to learning outcomes

Requirements for successful completion of the subject are specified by guarantor’s regulation updated for every academic year.

Course curriculum

1. Fundamental comcepts of database technology, relational data model.
2. Specific relational database management system, database objects, data import and export, dataview and data manipulation.
3. Defintion of table structure.
4. Information obtaining from data store - queries.
5. SQL language, elementary command SELECT.
6.-7. Advanced command SELECT.
8. Data manipulation commands.
9.-10. Tables relations, primary and foreign keys. Queries to table sets.
11. Printer report definition.
12. Design of user forms.
13. Example of simple database oriented system.

Work placements

Not applicable.

Aims

Subject is focused on Business information systems analysis and design (IS). In the context of using Internet technologies students are led through understanding of current Internet trends (typical services, users, Internet market, information society issues).
In the practical part students learn to work in Microsoft Access environment.

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

Extent and forms are specified by guarantor’s regulation updated for every academic year.

Recommended optional programme components

Not applicable.

Prerequisites and corequisites

Not applicable.

Basic literature

Not applicable.

Recommended reading

Not applicable.

Classification of course in study plans

  • Programme M-P-C-SI Master's

    branch E , 4 year of study, summer semester, compulsory

Type of course unit

 

Exercise

26 hod., optionally

Teacher / Lecturer

Ing. Miluše Kutínová