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 transversalesVariante 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