155-0331/02 – Basics of Database Systems (ZD)

Gurantor departmentDepartment of Computer ScienceCredits6
Subject guarantorIng. Vítězslav Novák, Ph.D.Subject version guarantorIng. Vítězslav Novák, Ph.D.
Study levelundergraduate or graduateRequirementCompulsory
Year1Semestersummer
Study languageCzech
Year of introduction2013/2014Year of cancellation
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 3+2

Subject aims expressed by acquired skills and competences

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

Teaching methods

Lectures
Tutorials

Summary

The aim of the course is to obtain basic knowledge and skills in the design and implementation of the database applications. The course should introduce students to the SQL and Visual Basic for Applications languages and to the basic database objects such as table, view, stored procedure, or trigger. Students will practice their knowledge with help of the DBMS Microsoft Office Access and Microsoft SQL Server.

Compulsory literature:

GROH, Michael R. Access 2010 bible. 1st Ed. Indianapolis, IN: Wiley Publishing, 2010. ISBN 978-0470475348. ROCKOFF, Larry. The Language of SQL: How to Access Data in Relational Databases. Boston, MA: Cengage Learning, 2010. ISBN 978-1435457515.

Recommended literature:

HARRINGTON, Jan L. Relational database design and implementation: clearly explained. 3rd ed. Boston: Morgan Kaufmann/Elsevier, 2009. ISBN 978-0-12-374730-3. CONNOLLY, Thomas M a Carolyn E BEGG. Database systems: a practical approach to design, implementation, and management. 5th ed. London: Addison-Wesley, 2010. ISBN 978-0-321-52306-8.

Way of continuous check of knowledge in the course of semester

Hodnocení nabytých vědomostí a dovedností je ověřováno dvěma projekty v průběhu semestru. První projekt ověřuje pochopení látky po přednášce Microsoft Access Objects a Microsoft ActiveX Data Objects. Úkolem je implementace databázové aplikace v MS Accessu. Druhý projekt ověřuje pochopení látky celého předmětu. Úkolem je implementace databázové aplikace na MS SQL Serveru. Je odevzdáván v zápočtovém týdnu nebo později.

E-learning

Přednášky a cvičení jsou ve formátu PDF 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:

Lectures: 1) Data modeling and design of data structures. 2) Normalization of relations. 3) Microsoft Office Access. 4) SQL, Data Definition Language. 5) SQL, Data Manipulation Language, SELECT statement I. 6) SQL, Data Manipulation Language, SELECT statement II. 7) SQL, Data Manipulation Language, INSERT, UPDATE, DELETE statements. 8) Fundamentals of Visual Basic for Application I. 9) Fundamentals of Visual Basic for Application II. 10) Microsoft Access Objects, Microsoft ActiveX Data Objects. 11) Microsoft SQL Server. 12) Transaction. 13) Programmable database objects - views, stored procedures, triggers. 14) Database administration- security, backup, restore of the database. Tutorials: Practical training with DBMS.

Conditions for subject completion

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

Show history

Occurrence in study plans

Academic yearProgrammeField of studySpec.FormStudy language Tut. centreYearWSType of duty
2015/2016 (B6209) Systems Engineering and Informatics P Czech Ostrava 1 Compulsory study plan
2014/2015 (B6209) Systems Engineering and Informatics P Czech Ostrava 1 Compulsory study plan
2014/2015 (B6209) Systems Engineering and Informatics P Czech Uherské Hradiště 1 Compulsory study plan
2014/2015 (B6209) Systems Engineering and Informatics (6209R025) System Engineering and Informatics P Czech Ostrava 2 Compulsory study plan
2013/2014 (B6209) Systems Engineering and Informatics P Czech Ostrava 1 Compulsory study plan
2013/2014 (B6209) Systems Engineering and Informatics (6209R025) System Engineering and Informatics P Czech Ostrava 2 Compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner
Subject block without study plan - EKF - P 2014/2015 Full-time Czech Optional EKF - Faculty of Economics stu. block