Databases

  • Teaching

    Details

    Faculty Faculty of Science and Medicine
    Domain Computer Science
    Code UE-SIN.03021
    Languages English
    Type of lesson Lecture
    Level Bachelor
    Semester SA-2020

    Title

    French Bases de données
    German Datenbanken
    English Databases

    Schedules and rooms

    Summary schedule Wednesday 09:15 - 13:00, Hebdomadaire
    Struct. of the schedule 2+2h par semaine durant 14 semaines
    Contact's hours 56

    Teaching

    Responsibles
    Teachers
    Assistants
    Description

    Databases

    Information Systems and Database Systems, Motivation for Using Databases, Level Architecture

    Data Modeling

    Entity-Relationship Model, Entities, Relationships, Attributes, Dependencies, Generalization, Recursive Relations, Tool-based Modeling Using Bee-Up

    Relational Model

    Structure and Formal Description, Candidate Keys and Keys, Transformation of the Entity-Relationship Model into the Relational Model

    Relational Algebra

    Projection, Selection, Set Operations, Cartesian Product, Inner and Outer Joins, Integrity Constraints

    Structured Query Language (SQL)

    Requirements for Query Languages, Classification of Query Languages, Data Definition, Data Types, Implementation of Integrity Constraints, Min-Max Notation for ER Models for Deriving Integrity Constraints, Data Manipulation, Data Querying, Grouping and Set Operations, View Concept and View-Update Problems

    Relational Design Theory

    Redundancy and Anomalies, Functional Dependencies, Transitive Closure, Armstrong Axioms, Canonical Cover, Decomposition of Relations, Lossless and Dependency Preserving Decompositions, Derivation of Candidate Keys, Normal Forms

    Transactions

    Transactions and Transaction Management in Multi-User Environments, Serializability, Precedence Graphs, Preventive and Verifying Synchronization Approaches, Lock Protocols

    Security

    Permisssion Control and Data Control Language, Data Security and Data Protection

    Access to Databases from Programming Languages

    Outlook

    NoSQL Databases, Blockchains

    All course material will be made available via Moodle.

    Training objectives

    You know when to use database systems and what are their benefits.

    You are capable of eliciting requirements for database systems using entity relationship models and constraints in the form of the min,max notation and can transform the models into the relational model.

    You dispose of extended knowledge about the relational model including relational design theory, the decomposition of relations and the use of normal forms for optimizations.

    You are capable of using the language Structured Query Language (SQL) for data definition and data manipulation including constraints.

    You are capable of using methods and techniques for multi-user environments including transaction management.

    Comments

    Lectures and Exercises will be given in English. The course will comprise lectures and exercise units.

     

    Softskills
    No
    Off field
    No
    BeNeFri
    Yes
    Mobility
    Yes
    UniPop
    No

    Documents

    Bibliography

    Garcia-Molina, H., Ullman, J.D., Widom, J.: Database Systems - The Complete Book, Pearson, 2nd edition, 2013

    Kemper, A., Eickler, A.: Datenbanksysteme: Eine Einführung (German), De Gruyter,10th ediition, 2015

    Unland, R., Pernul, G.: Datenbanken im Einsatz: Analyse, Modellbildung und Umsetzung (German), DeGruyter, 2014

    Elmasri, R., Navathe, S.: Conception et architectures des bases de données, 4th edition, Pearson, 2004

  • Dates and rooms

    Online Course

    Date Hour Type of lesson Place
    16.09.2020 09:15 - 13:00 Cours PER 21, Room C230
    23.09.2020 09:15 - 13:00 Cours PER 21, Room C230
    30.09.2020 09:15 - 13:00 Cours PER 21, Room C230
    07.10.2020 09:15 - 13:00 Cours PER 21, Room C230
    14.10.2020 09:15 - 13:00 Cours PER 21, Room C230
    21.10.2020 09:15 - 13:00 Cours PER 21, Room C230
    28.10.2020 09:15 - 13:00 Cours PER 21, Room C230
    04.11.2020 09:15 - 13:00 Cours PER 21, Room C230
    11.11.2020 09:15 - 13:00 Cours PER 21, Room C230
    18.11.2020 09:15 - 13:00 Cours PER 21, Room C230
    25.11.2020 09:15 - 13:00 Cours PER 21, Room C230
    02.12.2020 09:15 - 13:00 Cours PER 21, Room C230
    09.12.2020 09:15 - 13:00 Cours PER 21, Room C230
    16.12.2020 09:15 - 13:00 Cours PER 21, Room C230
  • Assessments methods

    Examen écrit - SA-2020, Session d'hiver 2021

    Date 10.02.2021 14:00 - 15:00
    Assessments methods By rating
    Descriptions of Exams

    Selon modalité A de l'annexe du plan d'études en informatique

    Written exam (90 minutes)

    Comment

    Moodle ONLINE Exam / 60 Min.

     

    Examen écrit - SP-2021, Autumn Session 2021

    Assessments methods By rating
    Descriptions of Exams

    Selon modalité A de l'annexe du plan d'études en informatique

    Written exam (90 minutes)

    Comment

    written exam in presence

     

  • Assignment
    Valid for the following curricula:
    Additional Courses in Sciences
    Version: ens_compl_sciences
    Paquet indépendant des branches > Advanced courses in Computer Science (Bachelor level)

    Additional Programme Requirements to the MSc in Bioinformatics and Computational Biology [MA]
    Version: 2020_1/V_01
    Additional Programme Requirements to the MSc Bioinformatics and Computational Biology > Advanced courses in Computer Science (Bachelor level)

    Additional Programme Requirements to the MSc in Computer Science [MA]
    Version: 2018_1/V_01
    Supplement to the MSc in Computer science > Advanced courses in Computer Science (Bachelor level)

    Additional Programme Requirements to the MSc in Computer Science [MA]
    Version: 2020_1/V_01
    Supplement to the MSc in Computer science > Advanced courses in Computer Science (Bachelor level)

    Additional TDHSE programme in Computer Science
    Version: 2020_1/V_01
    Additional TDHSE Programme Requirements for Computer Science 60 or +30 > Programmes 60 or +30 > Additional Programme Requirements to Computer Science 60 > Additional TDHSE programme for Computer Science 60 (from AS2020 on)

    Computer Science 30
    Version: 2020_1/V_01
    Minor in Computer science 30 > Computer Science, Minor 30 or 60 ECTS elective (from AS2019 on)

    Computer Science 60
    Version: 2020_1/V_01
    Minor in Computer Science 60 > Computer Science, Minor 30 or 60 ECTS elective (from AS2019 on)

    Computer Science 50 [BSc/BA SI]
    Version: 2020_1/V_01
    BSc_SI/BA_SI, Computer science 50 ECTS, 1st-3rd years > BSc_SI/BA_SI, Computer Science, 2nd-3rd years, elective courses for 50 ECTS (from AS2020 on)

    Computer Science [3e cycle]
    Version: 2015_1/V_01
    Continuing education > Advanced courses in Computer Science (Bachelor level)

    Pre-Master-Programme to the MSc in Bioinformatics and Computational Biology [PRE-MA]
    Version: 2020_1/V_01
    Prerequisite to the MSc in Bioinformtics and Computational Biology > Advanced courses in Computer Science (Bachelor level)