352-0309/01 – Database and Internet (DaI)
| Gurantor department | Department of Control Systems and Instrumentation | Credits | 4 |
| Subject guarantor | Ing. Pavel Smutný, Ph.D. | Subject version guarantor | prof. Ing. Radim Farana, CSc. |
| Study level | undergraduate or graduate | Requirement | Compulsory |
| Year | 3 | Semester | winter |
| | Study language | Czech |
| Year of introduction | 2001/2002 | Year of cancellation | 2015/2016 |
| Intended for the faculties | FS | Intended for study types | Bachelor |
Subject aims expressed by acquired skills and competences
Subject Database and Internet is an important subject, which determines the profile of the graduates in branch Applied Informatics and Control. Its objective is to introduce students to the principles of creating data structures and the data processing or recording systems solving. Student will obtain a summary of available database systems useful for desktop computers and will cope with methods and procedures for database systems of small and middle range creating with emphasis to team work.
A part of the subject is also connection to database throught Internet, creating of simple web information insystems.
Teaching methods
Lectures
Individual consultations
Tutorials
Project work
Summary
Subject Database and Internet is an important subject, which determines the
profile of the graduates in branch 23-70-70 Applied Informatics and Control.
Its objective is to introduce students to the principles of creating data
structures and the data processing or recording systems solving. Student will obtain a summary of available database systems useful for desktop computers and will cope with methods and procedures for database systems of small and middle range creating with emphasis to team work. A part of the subject is also connection to database throught Internet, creating of simple web information insystems.
Compulsory literature:
Recommended literature:
W3C The World Wide Web Consortium (informační server). Dostupný z URL http://www.w3.org/.
Way of continuous check of knowledge in the course of semester
E-learning
Other requirements
Students have to prepare project.
Prerequisities
Subject has no prerequisities.
Co-requisities
Subject has no co-requisities.
Subject syllabus:
1. Introduction to the subject content, credit system claims. Object oriented database MS-Access. Object types, their use, data types, system possibilities and limits.
2. Data analysis, table schema, indexes and relationships. E-R model use for database desing.
3. Selection queries, query creating, virtual fields, data aggregation. SQL language use.
4. SQL language ANSI norm.
5. Creating of forms for data input. Control types, their use.
6. Creating of forms with subforms. Object manipulation methods.
7. Creating of reports, data grouping and aggregation.
8. System control (macros and modules, toolbars, menu bars)
9. VBA language, constants and values declaration, MS-Access object library.
10. Database security system, encrypting, workgroups, users and groups, permissions. Data replication, creating and synchronization.
11. Internet, web, hypertext design.
12. Server application, ASP technology and object model. ASP.NET technology.
13. Database connection, ODBC, ADO system.
14. Modern information systems design methods.
Conditions for subject completion
Occurrence in study plans
Occurrence in special blocks
Assessment of instruction