Database and Information Systems - OEB1319301

• Title: Database and Information Systems
• Guaranteed by: Katedra informačních technologií a technické výchovy (41-KITTV)
• Faculty: Faculty of Education
• Actual: from 2021
• Semester: winter
• E-Credits: 4
• Examination process: winter s.:
• Hours per week, examination: winter s.:0/1, Ex [HT]
• Capacity: unknown / unknown (unknown)
• Min. number of students: unlimited
• 4EU+: no
• Virtual mobility / capacity: no
• State of the course: cancelled
• Language: English
• Teaching methods: full-time
• Teaching methods: full-time
• Note: priority enrollment if the course is part of the study plan
• Guarantor: PhDr. Josef Procházka, Ph.D.

Annotation

Last update: PROKYSEK/PEDF.CUNI.CZ (01.07.2016)

This course is focused on techniques of data manipulation and storing. The main focus is on relational databases and SQL. Students gain skills in entity relational modeling, database design and using of SQL. During the course several databases will be designed and implemented on most popular database servers.

Aim of the course

Last update: PROKYSEK/PEDF.CUNI.CZ (01.07.2016)

The focus of this subject is to introduce students to the problems of database systems, their theories and principles of database design. The course has several views on database technology, the main emphasis is on data modeling and data analysis. The course deals with various problems with access to data architecture, relational data model, ER model, normalization, data warehousing, distributed databases and knowledge bases. In the practical part, students practice their theoretical knowledge of designing and implementing database transformations of data models into relational database schema based on SQL standards. The course is also familiar with the basic operations manager database servers and their users access and other services, security and automatic data backup ..

Literature

Last update: PROKYSEK/PEDF.CUNI.CZ (01.07.2016)

• Michael J. Hernandez: Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design, Addison-Wesley Professional, 2013
• Codd, E. F. (1970). "A relational model of data for large shared data banks", Communications of the ACM 13 (6): 377. doi:10.1145/362384.362685

Requirements to the exam

Last update: PROKYSEK/PEDF.CUNI.CZ (01.07.2016)

An exam is a combination of practical and theoretical part:

Theoretical part is leaded as an oral exam. In the practical part student constructs a SQL data query.

Syllabus

Last update: PROKYSEK/PEDF.CUNI.CZ (01.07.2016)

• Database systems
• History of data storing and processing
• Database approach and database management systems
• Database system architecture
• Database models
• Conceptual modeling
• Entity Relationship Diagram
• Database design
• Relational databases, keys, indexes
• Datatypes and attributs
• Database normalization
• Normal forms and database schemas
• Decompozition and synthese
• SQL
• Sublanguages
• Procedural extensions
• Data queries
• Server administration
• Structure definition
• Data queries with advenced options
• Data access control