545-0338/02 – Database management systems applications ()

Gurantor departmentDepartment of Economics and Control SystemsCredits2
Subject guarantorFiktivní UživatelSubject version guarantordoc. Ing. Jiří Horák, Dr.
Study levelundergraduate or graduateRequirementChoice-compulsory
Year2Semestersummer
Study languageCzech
Year of introduction1997/1998Year of cancellation2002/2003
Intended for the facultiesHGFIntended for study typesMaster
Extent of instruction for forms of study
Form of studyWay of compl.Extent
Full-time Credit 0+2

Subject aims expressed by acquired skills and competences

Teaching methods

Summary

Compulsory literature:

Recommended literature:

Way of continuous check of knowledge in the course of semester

E-learning

Další požadavky na studenta

Prerequisities

Subject has no prerequisities.

Co-requisities

Subject has no co-requisities.

Subject syllabus:

1. Koncepce tvorby datového modelu. 2. Funkční závislosti, návrh relačních tabulek a jejich normalizace. 3. Funkční závislosti, návrh relačních tabulek a jejich normalizace - pokračování. 4. Návrh databáze v prostředí MS Access. 5. Realizace datového modelu v Access - návrh tabulek a integritních omezení. 6. Realizace datového modelu v Access - návrh tabulek a integritních omezení. 7. Praktická realizace oddělení dat od aplikace v prostředí MS Access. 8. ODBC a jeho praktické využití. 9. Dotazy - tvorba pomocí QBE. 10. Dotazy - tvorba pomocí SQL. 11. Tvorba formulářů, jejich propojování. 12. Tvorba formulářů, jejich propojování - pokračování. 13. Využití maker. 14. Využití programových modulů. 15. Řešené příklady v MS Access.

Conditions for subject completion

Full-time form (validity from: 1960/1961 Summer semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of points
Exercises evaluation Credit 85  0
Mandatory attendence parzicipation:

Show history

Occurrence in study plans

Academic yearProgrammeField of studySpec.FormStudy language Tut. centreYearWSType of duty
2001/2002 (M2102) Mineral Raw Materials (3902T006) Automation and Computers in Raw Materials Treatment Industry P Czech Ostrava 2 Choice-compulsory study plan
2001/2002 (B3646) Geodesy and Cartography (3646R006) Geoinformatics P Czech Ostrava 3 Choice-compulsory study plan
2001/2002 (M3646) Geodézie a kartografie (3602T002) Geoinformatics P Czech Ostrava 2 Choice-compulsory study plan
2000/2001 (M2102) Mineral Raw Materials (3902T006) Automation and Computers in Raw Materials Treatment Industry P Czech Ostrava 2 Choice-compulsory study plan
2000/2001 (B3646) Geodesy and Cartography (3646R006) Geoinformatics P Czech Ostrava 3 Choice-compulsory study plan
2000/2001 (M3646) Geodézie a kartografie (3602T002) Geoinformatics P Czech Ostrava 2 Choice-compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner