155-0374/02 – Database Aplications (DBAPL)

Gurantor departmentDepartment of Computer ScienceCredits4
Subject guarantorIng. Vítězslav Novák, Ph.D.Subject version guarantorIng. Vítězslav Novák, Ph.D.
Study levelundergraduate or graduate
Study languageCzech
Year of introduction2006/2007Year of cancellation2013/2014
Intended for the facultiesEKFIntended for study typesBachelor
Instruction secured by
LoginNameTuitorTeacher giving lectures
NOV21 Ing. Vítězslav Novák, Ph.D.
Extent of instruction for forms of study
Form of studyWay of compl.Extent
Full-time Credit 2+2

Subject aims expressed by acquired skills and competences

Understand the fundamental principles of the relational databases. Use commands SELECT, INSERT, UPDATE and DELETE of language SQL. Create database applications in Microsoft Office Access. Use the programming language Visual Basic for Application on a simple level.

Teaching methods

Lectures
Tutorials
Project work

Summary

The aim of the subject is to introduce the students to the foundations of the design and creation relational databases and with foundations of SQL language as a basic language for data manipulation. Students also teach to create graphical user interface above database. Everything will present on database system Microsoft Access current version.

Compulsory literature:

LAMBERT, Joan and Joyce COX. Microsoft Access 2010 Step by Step. Microsoft Press 2010. 448 p. ISBN 978-0735626928. SHEPHERD, Richard. Microsoft Access 2010 VBA Macro Programming. McGraw-Hill Osborne Media, 2010. 400 p. ISBN 978-0071738576. GROFF, James R. a Paul N. WEINBERG. SQL: The Complete Reference. McGraw-Hill Osborne Media. 912 p. ISBN 978-0071592550.

Recommended literature:

... and anything else about Microsoft Access, VBA and SQL

Way of continuous check of knowledge in the course of semester

Student průběžně vytváří databázovou aplikaci v MS Accessu.

E-learning

Všechny prezentace z přednášek a cvičení jsou v LMS Moodle.

Další požadavky na studenta

No other requirements.

Prerequisities

Subject has no prerequisities.

Co-requisities

Subject has no co-requisities.

Subject syllabus:

1) Fundamental principles of the relational databases. 2) Creating and editing tables in Microsoft Office Access. 3) Data Definition Language of the SQL. 4) Creating queries in Microsoft Office Access. 5) Command SELECT of the SQL. 6) Forms in Microsoft Office Access. 7) Reportsin Microsoft Office Access. 8) Basics of the Visual Basic for Application. 9) Microsoft Access Objects. 10) Commands INSERT, UPDATE and DELETE of the SQL. 11) Microsoft ActiveX Data Objects. 12) Finishing of a database application.

Conditions for subject completion

Conditions for completion are defined only for particular subject version and form of study

Occurrence in study plans

Academic yearProgrammeField of studySpec.FormStudy language Tut. centreYearWSType of duty
2012/2013 (B6209) Systems Engineering and Informatics (6209R025) System Engineering and Informatics P Czech Ostrava 2 Compulsory study plan
2012/2013 (B6209) Systems Engineering and Informatics (6209R001) Applied Informatics (00) Applied Informatics P Czech Ostrava 2 Compulsory study plan
2011/2012 (B6209) Systems Engineering and Informatics (6209R025) System Engineering and Informatics P Czech Ostrava 2 Compulsory study plan
2011/2012 (B6209) Systems Engineering and Informatics (6209R001) Applied Informatics (00) Applied Informatics P Czech Ostrava 2 Compulsory study plan
2011/2012 (B6209) Systems Engineering and Informatics (6209R001) Applied Informatics (01) Applied Infomatics P Czech Valašské Meziříčí 2 Compulsory study plan
2010/2011 (B6209) Systems Engineering and Informatics (6209R001) Applied Informatics (00) Applied Informatics P Czech Ostrava 2 Compulsory study plan
2010/2011 (B6209) Systems Engineering and Informatics (6209R001) Applied Informatics P Czech Valašské Meziříčí 2 Compulsory study plan
2010/2011 (B6209) Systems Engineering and Informatics (6209R001) Applied Informatics (01) Applied Infomatics P Czech Valašské Meziříčí 2 Compulsory study plan
2009/2010 (B6209) Systems Engineering and Informatics (6209R001) Applied Informatics (00) Applied Informatics P Czech Ostrava 2 Compulsory study plan
2009/2010 (B6209) Systems Engineering and Informatics (6209R001) Applied Informatics (01) Applied Infomatics P Czech Valašské Meziříčí 2 Compulsory study plan
2008/2009 (B6209) Systems Engineering and Informatics (6209R001) Applied Informatics (00) Applied Informatics P Czech Ostrava 2 Compulsory study plan
2008/2009 (B6209) Systems Engineering and Informatics (6209R001) Applied Informatics (01) Applied Infomatics P Czech Valašské Meziříčí 2 Compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner