184.685 Data Modelling
This course is in all assigned curricula part of the STEOP.
This course is in at least 1 assigned curriculum part of the STEOP.
This course is in at least 1 assigned curriculum part of the STEOP.

2013W, VU, 2.0h, 3.0EC

Properties

  • Semester hours: 2.0
  • Credits: 3.0
  • Type: VU Lecture and Exercise

Aim of course

Introduction to Data Modelling

Please use this Mailadress: dm@dbai.tuwien.ac.at

Attention:
Effective for everybody who registered for Computer Science/Business Informatics for the first time in summer term 2011:
You have to complete the "Studieneingangsgespräche (STEG)" until March 11th 2010 to successfully complete this course.
For details see STEG.

 

 

Subject of course

  • Semantic Data Modelling (EER)
  • Relational Model, Query Languages (Relational Algebra, Tuple/Domain Relational Calculus, SQL)
  • Design Theory for Relational Databases (Functional Dependencies, Normalforms)
  • Data Integrity

Additional information

 ECTS Breakdown:
-----------------------------
18h lectures
20h exercises
33h preparation for the examination
2h evaluation of exercises
1h SQL examination
1h final examination
-----------------------------
75h (3 ECTS)
-----------------------------

Lecturers

Institute

Course dates

DayTimeDateLocationDescription
Tue13:00 - 14:3008.10.2013 - 28.01.2014GM 1 Audi. Max.- ARCH-INF Vorlesung
Data Modelling - Single appointments
DayDateTimeLocationDescription
Tue08.10.201313:00 - 14:30GM 1 Audi. Max.- ARCH-INF Vorlesung
Tue15.10.201313:00 - 14:30GM 1 Audi. Max.- ARCH-INF Vorlesung
Tue22.10.201313:00 - 14:30GM 1 Audi. Max.- ARCH-INF Vorlesung
Tue29.10.201313:00 - 14:30GM 1 Audi. Max.- ARCH-INF Vorlesung
Tue05.11.201313:00 - 14:30GM 1 Audi. Max.- ARCH-INF Vorlesung
Tue12.11.201313:00 - 14:30GM 1 Audi. Max.- ARCH-INF Vorlesung
Tue19.11.201313:00 - 14:30GM 1 Audi. Max.- ARCH-INF Vorlesung
Tue26.11.201313:00 - 14:30GM 1 Audi. Max.- ARCH-INF Vorlesung
Tue03.12.201313:00 - 14:30GM 1 Audi. Max.- ARCH-INF Vorlesung
Tue10.12.201313:00 - 14:30GM 1 Audi. Max.- ARCH-INF Vorlesung
Tue17.12.201313:00 - 14:30GM 1 Audi. Max.- ARCH-INF Vorlesung
Tue07.01.201413:00 - 14:30GM 1 Audi. Max.- ARCH-INF Vorlesung
Tue14.01.201413:00 - 14:30GM 1 Audi. Max.- ARCH-INF Vorlesung
Tue21.01.201413:00 - 14:30GM 1 Audi. Max.- ARCH-INF Vorlesung
Tue28.01.201413:00 - 14:30GM 1 Audi. Max.- ARCH-INF Vorlesung

Examination modalities

The two exercise sheets, the SQL exam and the final written examination are part of the evaluation.

Exams

DayTimeDateRoomMode of examinationApplication timeApplication modeExam
Fri08:00 - 20:0020.11.2020Inflab Frogger assessedunknownSQL--Test (Paralleltermin)
Fri08:00 - 20:0020.11.2020Inflab Pong assessedunknownSQL--Test (Paralleltermin)
Fri08:00 - 20:0020.11.2020Inflab Q*bert assessedunknownSQL--Test (Paralleltermin)
Fri16:00 - 18:0004.12.2020 assessed15.10.2020 09:00 - 02.12.2020 23:59TISSPrüfung 1
Mon09:00 - 18:0014.12.2020Inflab Q*bert assessedunknownSQL-Test Nachtermin (Paralleltermin)
Mon09:00 - 18:0014.12.2020Inflab Frogger assessedunknownSQL-Test Nachtermin (Paralleltermin)
Mon18:00 - 20:0011.01.2021GM 1 Audi. Max.- ARCH-INF assessed14.12.2020 09:00 - 09.01.2021 23:59TISSPrüfung 1 - Wiederholung

Course registration

Begin End Deregistration end
23.09.2013 00:00 10.10.2013 23:59 10.10.2013 23:59

Curricula

Study CodeSemesterPrecon.Info
033 201 Technical Mathematics
033 522 Computer Science Management STEG
Course requires the completion of the introductory interview STEG
true
Course belongs to the introductory and orientation phase ("Studieneingangs- und Orientierungsphase")
033 526 Business Informatics 1. SemesterSTEG
Course requires the completion of the introductory interview STEG
true
Course belongs to the introductory and orientation phase ("Studieneingangs- und Orientierungsphase")
033 532 Media Informatics and Visual Computing 1. SemesterSTEG
Course requires the completion of the introductory interview STEG
true
Course belongs to the introductory and orientation phase ("Studieneingangs- und Orientierungsphase")
033 533 Medical Informatics 1. SemesterSTEG
Course requires the completion of the introductory interview STEG
true
Course belongs to the introductory and orientation phase ("Studieneingangs- und Orientierungsphase")
033 534 Software & Information Engineering 1. SemesterSTEG
Course requires the completion of the introductory interview STEG
true
Course belongs to the introductory and orientation phase ("Studieneingangs- und Orientierungsphase")
033 535 Computer Engineering STEG
Course requires the completion of the introductory interview STEG
884 Subject: Informatics und Informatics Management 5. SemesterSTEG
Course requires the completion of the introductory interview STEG
true
Course belongs to the introductory and orientation phase ("Studieneingangs- und Orientierungsphase")

Literature

No lecture notes are available.

Continuative courses

Miscellaneous

Language

German