SubjectsSubjects(version: 962)
Course, academic year 2011/2012
   Login via CAS
Database and information systems - OKB2319412
Title: Databázové a informační systémy
Guaranteed by: Katedra informačních technologií a technické výchovy (41-KITTV)
Faculty: Faculty of Education
Actual: from 2011 to 2012
Semester: summer
E-Credits: 4
Examination process: summer s.:
Hours per week, examination: summer s.:0/0, MC [HT]
Capacity: unknown / unknown (unknown)
Min. number of students: unlimited
4EU+: no
Virtual mobility / capacity: no
State of the course: taught
Language: Czech
Teaching methods: combined
Teaching methods: combined
Guarantor: PhDr. Josef Procházka, Ph.D.
Teacher(s): PhDr. Miloš Prokýšek, Ph.D.
Pre-requisite : OKB2319311
Is pre-requisite for: OKB2319517, OKB2319516
Annotation -
The aims of the course is for students to clarify the philosophy, principles and techniques of design and development of database systems and information systems based on computer-managed database. The course is broad issues of database and information systems. Students will gets to know the necessary theory and by way of practical exercises will practice chosen method of analysis and design. At the same time gain competence in operating, recovery and development of relational database systems. Content covers basic concepts including in information and database systems, data processing architectures and approaches to them, data modeling with a focus on ER and DFD models, relational database model and the concept and principles of SQL. An integral part of the subject is also the acquisition of basic skills for administration of the database server in selected platform. The subject builds on knowledge gained in previous courses Feature and principles of operating systems and Local computer network and, in terms of skills, builds foundation for further courses, especially for teaching in the learning course Development and administration of database applications.
Last update: PROCHJ/PEDF.CUNI.CZ (22.09.2011)
Literature - Czech

Publikace

  • CODD, E. F. A Relational Model for Large Shared Data Banks. In CACM, 13, 6, June 1970.
  • CONNOLY,T., BERG, C.,STRACHAN, A. Database Systems. New York: Addison-Wesley Publisher, 1996.
  • DATE, C. J. Relational Databases: Selected Writings. Boston: Addison Wesley Publ. Comp., 1986.
  • POKORNÝ, J., VALENTA, M. Databázové systémy. Praha: ČVUT, 2013.
  • ŠEDA, M.  Databázové systémy. Brno: VUT, 2002,
    Dostupný z URL: <http://www.uai.fme.vutbr.cz/~mseda/DBS02_BS.pdf>.
  • ROMAN, S. Návrh a programování databází. Praha: Computer Press, 2000.
  • MASLAKOWSKI, M. Naučte se MySQL za 21 dní. Praha ComputerPress, 2001.

 Další zdroje

Last update: PROCHJ/PEDF.CUNI.CZ (03.12.2014)
Syllabus -

Principles of Database Systems

  • History of data processing, manual approach, mass data processing, database
  • Database technology, database management systems
  • Characteristics of data in databases
  • Architectures DB systems, data protection, user access

Database models

  1. Conceptual modeling,
  2. Entity-relational conceptual model
  3. Relationships between entities 1:1, 1: N, M: N

Database design

  • ER diagrams, entities, relationships, identifying of keys
  • Data flow diagrams (DFD)
  • Data types and attributes properties

Database Normalization

  • Normal forms database schemas and relationships
  • Criteria for the design of a relational database schema
  • Decomposition and Synthesis
  • Discussion on the standardization and its importance

SQL for data manipulation

  • Commands for creating databases and entities, and their elimination
  • Change the name and entity type attributes
  • Commands for record a change of values and eliminate
  • Queries for the structure and opening a recordset
  • Advanced SQL queries

Managing database server

  • Important parameters of the server and their configuration
  • User management database, configuration of access rights
  • System functions for server management
Last update: PROCHJ/PEDF.CUNI.CZ (03.12.2014)
Course completion requirements - Czech

Požadavky ke klasifikovanému zápočtu

  • Aktivní práce v seminářích, průběžné plnění úkolů
  • Obhájení kvalitní původní zápočtové práce z oblasti zaměření předmětu vytvořené samostatně ve struktuře a formě dle zadání
  • Prokázání příslušné úrovně vědomostí z oblasti zaměření předmětu formou testu
  • Prokázání způsobilosti v návrhu a tvorbě databázového systému a aplikace příslušných dotazů podle zadání.

Zápočet bude realizována v aplikačním prostředí korespondujícím s výukou

Last update: PROCHJ/PEDF.CUNI.CZ (03.12.2014)
 
Charles University | Information system of Charles University | http://www.cuni.cz/UKEN-329.html