| Course Unit Code | 548-0018/03 |
|---|
| Number of ECTS Credits Allocated | 3 ECTS credits |
|---|
| Type of Course Unit * | Choice-compulsory |
|---|
| Level of Course Unit * | First Cycle |
|---|
| Year of Study * | Second Year |
|---|
| Semester when the Course Unit is delivered | Summer Semester |
|---|
| Mode of Delivery | Face-to-face |
|---|
| Language of Instruction | Czech |
|---|
| Prerequisites and Co-Requisites | Course succeeds to compulsory courses of previous semester |
|---|
| Name of Lecturer(s) | Personal ID | Name |
|---|
| HOR10 | prof. Ing. Jiří Horák, Dr. |
| Summary |
|---|
Data modelling. Functional dependency, relation scheme design, normalisation
process. CASE modelling. ODBC. Data import, data processing, data export.
Exploratory data analysis in DB environment. User definition and access rights. Forms development. reports development. Macros, programming modules. Case study in powerful RDBMS. |
| Learning Outcomes of the Course Unit |
|---|
The aim of the subject is to get acquainted students how to solve selected tasks of data analysis, to design some special data structures (OLAP, etc.), analyse given situation and to propose effective procedures of processing.
|
| Course Contents |
|---|
Data modelling. Functional dependency, relation scheme design, normalisation
process. CASE modelling. ODBC. Data import, data processing, data export.
Exploratory data analysis in DB environment. User definition and access rights.
Forms development. reports development. Macros, programming modules. Case study
in powerful RDBMS. |
| Recommended or Required Reading |
|---|
| Required Reading: |
|---|
| Teorey T., Lightstone S., Nadeau T: Database modelling and design: Logical design. Elsevier. ISBN 978-0-12-685352-0 |
Pokorný J., Halaška I.: Databázové systémy. ČVUT Praha 2004.
Pokorný J.: Konstrukce databázových systémů. ČVUT Praha 1998.
|
| Recommended Reading: |
|---|
| PONNIAH P.: Database design and development. Wiley, 2003. |
Pokorný, J.: Databázová abeceda. Science 1998, ISBN 8086083-02-0, 240 s.
SQL. Kompletní průvodce. CP Books Brno, 2005. 936 stran. ISBN 80-251-0369-2. |
| Planned learning activities and teaching methods |
|---|
| Individual consultations, Tutorials, Project work |
| Assesment methods and criteria |
|---|
| Task Title | Task Type | Maximum Number of Points
(Act. for Subtasks) | Minimum Number of Points for Task Passing |
|---|
| Exercises evaluation | Credit | 85 (85) | 85 |
| Project | Project | 70 | 0 |
| Other task type | Other task type | 15 | 0 |