Course detail

Database Systems

FAST-CU52Acad. year: 2014/2015

Database technology fundamentals, terminology, data modelling.
Relational data model, relation algebra, data integrity.
Conceptual modelling, Entition-Relationship diagrams.
RDBMS languages, SQL language.
RDBMS architecture.
ISAM and SQL systems (MS Access, MS SQL2000 Server).
Practices of analytical skills. As a project students develop a simple database system in chosen production branch.

Language of instruction

Czech

Number of ECTS credits

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

General overview of data manipulation on the database management system level without specific application interface.
Data analysis principles.
Using various tools for extracting information from stored data.
Knowledge useful for data structures design of custom application.

Prerequisites

Basic knowledge and using of operation system especially of filesystem.

Co-requisites

Knowledge gained simultaneously in other courses is not necessary.

Planned learning activities and teaching methods

The course is taught through lectures, practical classes and self-study assignments. Attendance at lectures is optional, but attendance at classes is compulsory.

Assesment methods and criteria linked to learning outcomes

Prerequisites for successful passing of the course are:
Preliminary - attendance at the seminars in the level specified by the lecturer, project (design and implement simple application in chosen database system).
Exam – knowledge of topics discussed on lectures, project presentation and defence.

Course curriculum

1. Data modelling, current approaches
2. Relational model for database management, relation and its representation
3. Relational algebra
4. Conceptual modelling
5-6. Tables, relationships, primary and foreign keys, E-R diagrams
7. Indexing
8. Reference integrity
9. SQL language, DDL and DML commands
10. Complex SELECT queries
11. Views, stored procedures in TSQL. Transactions and access management.
12. Overview of current database management systems: Oracle, MySQL, SQL Server, ISAM
13. Sample analysis of simple information system.

Work placements

Not applicable.

Aims

Basic principles of database technology explained on chosen database management system. Design and implementation of a simple database application.

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

Closer understanding of some information system is useful.

Prerequisites and corequisites

Not applicable.

Basic literature

Pokorný Jaroslav: Databázová abeceda. Science, Veletiny, 1998.
Rebecca M. Riordan: Vytváříme relační databázové aplikace. Computer Press, 2000.

Recommended reading

Henderson K: Mistrovství v Transact-SQL. Computer Press, 2000.
Pokorný Jaroslav: Dotazovací jazyky. Science, Veletiny, 1994.
Šimůnek M.: SQL kompletní kapesní průvodce. Grada Publishing, 1999.

Classification of course in study plans

  • Programme N-K-C-SI Master's

    branch K , 1 year of study, summer semester, elective

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

    branch K , 1 year of study, summer semester, elective

  • Programme N-P-E-SI Master's

    branch K , 1 year of study, summer semester, elective

Type of course unit

 

Lecture

26 hod., optionally

Teacher / Lecturer

Ing. Miluše Kutínová

Syllabus

1. Data modelling, current approaches
2. Relational model for database management, relation and its representation
3. Relational algebra
4. Conceptual modelling
5-6. Tables, relationships, primary and foreign keys, E-R diagrams
7. Indexing
8. Reference integrity
9. SQL language, DDL and DML commands
10. Complex SELECT queries
11. Views, stored procedures in TSQL. Transactions and access management.
12. Overview of current database management systems: Oracle, MySQL, SQL Server, ISAM
13. Sample analysis of simple information system.

Exercise

26 hod., compulsory

Teacher / Lecturer

Ing. Miluše Kutínová

Syllabus

1. Introduction to selected database system (Access), using simple tools for information extraction (sorting, filtering).
2. Table structure definition, data types, integrity constraints implementation.
3-4. Assigning of themes for projects, project consultations.
5. Presentation of data structures design for project in Power Point.
6-9. Creating queries for information extraction.
10. Relationships between tables, complex queries in database system environment.
11. Developing of application interface using Access forms.
12-13. Project consultations and submissions.