Lecturer(s)
|
-
Zacpal Jiří, Mgr. Ph.D.
-
Večerka Arnošt, RNDr.
|
Course content
|
Students are introduced to basics of relational database systems and the SQL query language and also to the WWW internet service and basics of creating web pages. Students try to create their own database in MS Access environment and a simple web page in practices. 1. Basic concepts (database, DBMS, database system). Architecture of DS in relation to distribution of services. Location of data in DS. Distributed database. DBMS model. Relation model - basic concepts. 2. Data model. Relational algebra. Normalization in database model. 3. Database program languages. SQL language. 4. Working with MS Access. MS Visual Basic and database.
|
Learning activities and teaching methods
|
Lecture, Demonstration
|
Learning outcomes
|
The students become familiar with basic concepts of databases.
1. Knowledge Define and use relational data model and database systems.
|
Prerequisites
|
unspecified
KMI/ZSW
|
Assessment methods and criteria
|
Oral exam, Written exam
Active participation in class. Completion of assigned homeworks. Passing the oral (or written) exam.
|
Recommended literature
|
-
Connolly T., Begg C. (2002). Database Systems. A Practical Approach to Design, Implementation and Management, 3rd edition. Addison Wesley.
-
Groff J. R., Weinberg P. N. (2005). SQL. Computer Press.
-
Kosek J. (1998). HTML, tvorba dokonalých WWW stránek, podrobný průvodce. Grada Publishing.
-
Oppel A. (2006). Databáze bez předchozích znalostí. Computer Press.
-
Viescas J., Conrad J. (2008). Mistrovství v Microsoft Office Access. Computer Press.
|