Databases

  • Teaching

    Details

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

    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.

    Condition of access

    Registration to the cours AND exams is mandatory and does not automatically happen if you are registered to a class. Please observe the deadlines of the faculty of science and medicine.

    Comments

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

     

    Softskills
    Yes
    Off field
    Yes
    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

    As an exception, the lecture Database will take place on Wednesday, 24.11.2021 ONLINE from 9-11h. The practice lesson, however, takes place in room G230 from 12-13h in presence. 

     

    Date Hour Type of lesson Place
    22.09.2021 09:15 - 13:00 Cours PER 21, Room G140
    29.09.2021 09:15 - 13:00 Cours PER 21, Room G140
    06.10.2021 09:15 - 13:00 Cours PER 21, Room G140
    13.10.2021 09:15 - 13:00 Cours PER 21, Room G140
    20.10.2021 09:15 - 13:00 Cours PER 21, Room G140
    27.10.2021 09:15 - 13:00 Cours PER 21, Room G140
    03.11.2021 09:15 - 13:00 Cours PER 21, Room G140
    10.11.2021 09:15 - 13:00 Cours PER 21, Room G140
    17.11.2021 09:15 - 13:00 Cours PER 21, Room G140
    24.11.2021 12:15 - 13:00 Cours PER 21, Room G230
    01.12.2021 09:15 - 13:00 Cours PER 21, Room G140
    15.12.2021 09:15 - 13:00 Cours PER 21, Room G140
    22.12.2021 09:15 - 13:00 Cours PER 21, Room G140
  • Assessments methods

    Evaluation continue et examen écrit - SA-2021, Session d'hiver 2022

    Date 08.02.2022 10:00 - 11:30
    Assessments methods By rating
    Descriptions of Exams

    Written Exam (90 minutes)

    Comment

    Written ONLINE exam - COVID-19

     

    Evaluation continue et examen écrit - SP-2022, Autumn Session 2022

    Assessments methods By rating
    Descriptions of Exams

    Written Exam (90 minutes)

  • 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)

    Ba - Business Informatics - 180 ECTS
    Version: 2020/SA_V02
    2nd year 60 ECTS > Databases

    Ba - Economics - 180 ECTS
    Version: 2018/SA_V02
    3nd year 60 ECTS > 3rd year courses > Wahlkurse in der Wirtschaftsinformatik für Volkswirtschaftslehre 180 ECTS - HS 2018 - 3. Jahr > Databases

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

    Computer Science [POST-DOC]
    Version: 2015_1/V_01
    Continuing education > Advanced courses in Computer Science (Bachelor level)

    Education / Psychology 120
    Version: SA14_BA_fr_v02
    CTC / BP1.8-F

    Education / Psychology 120
    Version: SA20_BA_bil_v01
    BP1.7-B Bereichsübergreifende Kompetenzen / Compétences transversales

    Education / Psychology 120
    Version: SA20_BA_de_v01
    BP1.7-D Bereichsübergreifende Kompetenzen

    Educational Sciences 120
    Version: SA14_BA_fr_v02
    CTC / BS1.8-F

    Educational Sciences 120
    Version: SA20_BA_de_v01
    BE1.8-D Bereichsübergreifende Kompetenzen

    Educational Sciences 120
    Version: SA20_BA_bil_v01
    Variante A > BE1.8a-B Compétences transversales
    Variante B > BE1.7b-B Bereichsübergreifende Kompetenzen

    Ma - Accounting and Finance - 90 ECTS
    Version: 2021/SA_V01
    Course - 72 ECTS > Modules "Data Analytics" and "Audit et Fiscalité": min. 3 courses > DAT: Data Analytics > Databases

    Ma - Business Communication : Business Informatics - 90 ECTS
    Version: 2020/SA_V01
    Courses - 60 ECTS > Option Group > Information Management > Cours > Modules management > DAT: Data Analytics > Databases

    Ma - Business Communication : Management - 90 ECTS
    Version: 2021/SA_V01
    Courses - 60 ECTS > Chosen Option > Management > 30 ECTS parmi les modules : > DAT: Data Analytics > Databases

    Ma - Business Informatics - 90 ECTS
    Version: 2020/SA-v01
    Classes - min. 45 ECTS > Modules management - max. 15 ECTS > DAT: Data Analytics > Databases

    Ma - Data Analytics & Economics - 90 ECTS
    Version: 2020/SA-v01
    Courses min 63 ECTS > Mandatory Modules (45 to 63 ECTS) > Module I: Data Analytics (Data) > Databases

    Ma - International and European Business - 90 ECTS
    Version: 2021/SA_V01
    Courses > Modules > One complete module taken from the following list > Groupe d'élément de validation du Module DAT > DAT: Data Analytics > Databases

    Ma - Management - 90 ECTS
    Version: 2021/SA_V01
    Courses: min. 72 ECTS > Modules - min 54 ECTS > Groupe d'élément de validation du Module DAT > DAT: Data Analytics > Databases

    Ma - Marketing - 90 ECTS
    Version: 2021/SA_V02
    Courses > Groupe d'élément de validation du Module DAT > DAT: Data Analytics > Databases

    MiMa - Business Informatics - 30 ECTS
    Version: 2020/SA_V01
    Cours > Modules management > DAT: Data Analytics > Databases

    MiMa - Data Analytics - 30 ECTS
    Version: 2020/SA-v01
    À choix 18 crédits ECTS > Databases

    MiMa - Gestion d'entreprise - 30 ECTS
    Version: 2021/SA_V01
    Elective courses - 30 ECTS > DAT: Data Analytics > Databases

    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)

    Psychology 180
    Version: SA19_BA_fr_de_bil_v02
    Module 11 > M11 Soft skills