htw saar Piktogramm
Back to Main Page Choose Module Version:
XML-Code

flag

Databases

Module name (EN):
Name of module in study programme. It should be precise and clear.
Databases
Degree programme:
Study Programme with validity of corresponding study regulations containing this module.
Applied Informatics, Bachelor, ASPO 01.10.2011
Module code: PIB330
SAP-Submodule-No.:
The exam administration creates a SAP-Submodule-No for every exam type in every module. The SAP-Submodule-No is equal for the same module in different study programs.
P221-0018
Hours per semester week / Teaching method:
The count of hours per week is a combination of lecture (V for German Vorlesung), exercise (U for Übung), practice (P) oder project (PA). For example a course of the form 2V+2U has 2 hours of lecture and 2 hours of exercise per week.
3V+1P (4 hours per week)
ECTS credits:
European Credit Transfer System. Points for successful completion of a course. Each ECTS point represents a workload of 30 hours.
5
Semester: 3
Mandatory course: yes
Language of instruction:
German
Assessment:
Oral examination

[updated 08.05.2008]
Applicability / Curricular relevance:
All study programs (with year of the version of study regulations) containing the course.

PIB330 (P221-0018) Applied Informatics, Bachelor, ASPO 01.10.2011 , semester 3, mandatory course
Workload:
Workload of student for successfully completing the course. Each ECTS credit represents 30 working hours. These are the combined effort of face-to-face time, post-processing the subject of the lecture, exercises and preparation for the exam.

The total workload is distributed on the semester (01.04.-30.09. during the summer term, 01.10.-31.03. during the winter term).
60 class hours (= 45 clock hours) over a 15-week period.
The total student study time is 150 hours (equivalent to 5 ECTS credits).
There are therefore 105 hours available for class preparation and follow-up work and exam preparation.
Recommended prerequisites (modules):
PIB115 Fundamentals of Informatics
PIB120 Programming 1
PIB125 Mathematics 1
PIB210 Programming 2
PIB220 Graph Theory


[updated 14.10.2010]
Recommended as prerequisite for:
PIB440 Project Work
PIBWI19 Machine Learning
PIBWI21 Internet Development with Java 2
PIBWI24 Internet Development with Java 1
PIBWI45 Database Management
PIBWI48
PIBWI49 Enterprise Java Beans
PIBWI58 Portal Components in JAVA
PIBWI72 Ruby on Rails


[updated 26.04.2021]
Module coordinator:
Prof. Dr. Klaus Berberich
Lecturer:
Prof. Dr. Klaus Huckert
Dipl.-Math. Wolfgang Braun (practical training)


[updated 14.10.2010]
Learning outcomes:
- Understanding the structure of database systems
- Learning data modelling techniques
- Understanding, applying and working with SQLAppreciating how programming
  languages and SQL interact


[updated 08.05.2008]
Module content:
- Conventional data processing
- Database systems: architectures and properties
- Information modelling
- Relational data models
- Normalizing data sets
- Case study (design, development and implementation of a complete database)
- First steps with SQL
- Querying multiple tables
- Creating and modifying entries in databases and tables
- Indices and views in databases
- Authorization
- Programming and SQL
- Transactions and transaction locks
- ODBC / JDBC
- Data dictionary
- Microsoft SQL Server – System administration


[updated 08.05.2008]
Teaching methods/Media:
PowerPoint slides, lecture notes

[updated 08.05.2008]
Recommended or required reading:
BERKEL Th.:  Die relationale Datenbanksprache SQL, Addison Wesley, 1992
KLEINSCHMIDT P., RANK Ch.:  Relationale Datenbanksysteme, Springer, 2004
GEIGER K.:  Inside ODBC. - Der Entwicklerleitfaden, Microsoft Press, 1995
MARSCH J.:  FRITZE J.:  Erfolgreiche Datenbankanwendung mit SQL3, Vieweg, 2002
MEIER A.:  Relationale Datenbanken. Eine Einführung für die Praxis, Springer, 1999
MICROSOFT, Microsoft SQL Server Training, Microsoft Press, 2001
RIORDAN R.:  Microsoft SQL Server Programmierung, Microsoft Press, 2000


[updated 08.05.2008]
Module offered in:
WS 2017/18, WS 2016/17, WS 2015/16, WS 2014/15, WS 2013/14, ...
[Fri Feb  3 22:03:40 CET 2023, CKEY=pdb, BKEY=pi, CID=PIB330, LANGUAGE=en, DATE=03.02.2023]