352-0309/01 – Database and Internet (DaI)

Gurantor departmentDepartment of Control Systems and InstrumentationCredits4
Subject guarantorIng. Pavel Smutný, Ph.D.Subject version guarantorprof. Ing. Radim Farana, CSc.
Study levelundergraduate or graduateRequirementCompulsory
Year3Semesterwinter
Study languageCzech
Year of introduction2001/2002Year of cancellation2015/2016
Intended for the facultiesFSIntended for study typesBachelor
Instruction secured by
LoginNameTuitorTeacher giving lectures
FAR10 prof. Ing. Radim Farana, CSc.
Extent of instruction for forms of study
Form of studyWay of compl.Extent
Full-time Credit and Examination 2+2
Combined Credit and Examination 8+4

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:

BILLINGS, S, RHEMANN, J et al. Access 97 Programming. Indianapolis: SAMS publishing, 1997, 874 pp. ISBN 0-672-31049-X. NETSCAPE JavaScript Guide. Available from URL http://home.netscape. com/eng/mozilla/3.0/handbook/javascript/index.html. W3C The World Wide Web Consortium. Available from URL http://www.w3.org/. Smith, R & Sussman, D. Beginning Access 2000 VBA. Chicago, USA: Wrox Press, 1999, 865 pp. ISBN 1-861001-76-2. Mack, D. & Seven D. Programming Data-Driven Web Applications with ASP.NET. Indianapolis, USA: Sams Publishing, 2002, 704 pp. ISBN 0-672-32106-8.

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

Další požadavky na studenta

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

Full-time form (validity from: 2008/2009 Summer semester, validity until: 2015/2016 Summer semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of points
Exercises evaluation and Examination Credit and Examination 100 (35) 51
        Exercises evaluation Credit 35 (35) 20
                Project Project 35  20
        Examination Examination  (65)
                Písemná zkouška Written examination 45  0
                Ústní zkouška Oral examination 20  0
Mandatory attendence parzicipation:

Show history

Occurrence in study plans

Academic yearProgrammeField of studySpec.FormStudy language Tut. centreYearWSType of duty
2011/2012 (B2341) Engineering (3902R001) Applied Informatics and Control (70) Applied Informatics and Control P Czech Ostrava 3 Compulsory study plan
2011/2012 (B2341) Engineering (3902R001) Applied Informatics and Control (70) Applied Informatics and Control K Czech Ostrava 3 Compulsory study plan
2010/2011 (B2341) Engineering (3902R001) Applied Informatics and Control (70) Applied Informatics and Control P Czech Ostrava 3 Compulsory study plan
2010/2011 (B2341) Engineering (3902R001) Applied Informatics and Control (70) Applied Informatics and Control K Czech Ostrava 3 Compulsory study plan
2009/2010 (B2341) Engineering (3902R001) Applied Informatics and Control (70) Applied Informatics and Control P Czech Ostrava 3 Compulsory study plan
2009/2010 (B2341) Engineering (3902R001) Applied Informatics and Control (70) Applied Informatics and Control K Czech Ostrava 3 Compulsory study plan
2008/2009 (B2341) Engineering (3902R001) Applied Informatics and Control (70) Applied Informatics and Control P Czech Ostrava 3 Compulsory study plan
2008/2009 (B2341) Engineering (3902R001) Applied Informatics and Control (70) Applied Informatics and Control K Czech Ostrava 3 Compulsory study plan
2007/2008 (B2341) Engineering (3902R001) Applied Informatics and Control (70) Applied Informatics and Control P Czech Ostrava 3 Compulsory study plan
2007/2008 (B2341) Engineering (3902R001) Applied Informatics and Control (70) Applied Informatics and Control K Czech Ostrava 3 Compulsory study plan
2006/2007 (B2341) Engineering (3902R001) Applied Informatics and Control (70) Applied Informatics and Control P Czech Ostrava 3 Compulsory study plan
2006/2007 (B2341) Engineering (3902R001) Applied Informatics and Control (70) Applied Informatics and Control K Czech Ostrava 3 Compulsory study plan
2005/2006 (B2341) Engineering (3902R001) Applied Informatics and Control (70) Applied Informatics and Control P Czech Ostrava 3 Compulsory study plan
2005/2006 (B2341) Engineering (3902R001) Applied Informatics and Control (70) Applied Informatics and Control K Czech Ostrava 3 Compulsory study plan
2004/2005 (B2341) Engineering (3902R001) Applied Informatics and Control (70) Applied Informatics and Control P Czech Ostrava 3 Compulsory study plan
2004/2005 (B2341) Engineering (3902R001) Applied Informatics and Control (70) Applied Informatics and Control K Czech Ostrava 3 Compulsory study plan
2003/2004 (B2341) Engineering (3902R001) Applied Informatics and Control (70) Applied Informatics and Control P Czech Ostrava 3 Compulsory study plan
2003/2004 (B2341) Engineering (3902R001) Applied Informatics and Control (70) Applied Informatics and Control K Czech Ostrava 3 Compulsory study plan
2002/2003 (B2341) Engineering (3902R001) Applied Informatics and Control (70) Applied Informatics and Control P Czech Ostrava 3 Compulsory study plan
2002/2003 (B2341) Engineering (3902R001) Applied Informatics and Control (70) Applied Informatics and Control K Czech Ostrava 3 Compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner