252-0063-00L  Data Modelling and Databases

SemesterSpring Semester 2015
LecturersG. Alonso
Periodicityyearly recurring course
Language of instructionEnglish



Courses

NumberTitleHoursLecturers
252-0063-00 VData Modelling and Databases4 hrs
Mon10:15-12:00CAB G 61 »
Wed08:15-10:00CAB G 61 »
G. Alonso
252-0063-00 UData Modelling and Databases2 hrs
Tue08:15-10:00CHN E 46 »
08:15-10:00HG D 5.1 »
08:15-10:00ML F 34 »
Fri08:15-10:00CAB G 52 »
08:15-10:00CAB G 56 »
08:15-10:00CAB G 57 »
G. Alonso

Catalogue data

AbstractData modelling (ER and UML class diagrams), relational data model, relational design theory (normal forms), SQL, database integrity, security, transactions and data warehousing (OLAP).
ObjectiveIntroduction to relational databases and data management. Basics of SQL programming and transaction management.
ContentThe course covers the basic aspects of the design and implementation of databases and information systems. The courses focuses on relational databases as a starting point but will also cover data management issues beyond databases such as: transactional consistency, replication, data warehousing, other data models, as well as SQL.
LiteratureKemper, Eickler: Datenbanksysteme: Eine Einführung, Oldenbourg Verlag, 5. Auflage, 2004.

Performance assessment

Performance assessment information (valid until the course unit is held again)
Performance assessment as a semester course
ECTS credits7 credits
ExaminersG. Alonso
Typesession examination
Language of examinationEnglish
RepetitionThe performance assessment is only offered in the session after the course unit. Repetition only possible after re-enrolling.
Mode of examinationwritten 120 minutes
Written aidsIn sämtlichen Prüfungen sind keine Hilfsmittel erlaubt. In the exam, no supporting material is allowed
This information can be updated until the beginning of the semester; information on the examination timetable is binding.

Learning materials

 
Main linkInformation
Only public learning materials are listed.

Groups

No information on groups available.

Restrictions

There are no additional restrictions for the registration.

Offered in

ProgrammeSectionType
Computational Biology and Bioinformatics MasterAdvanced CoursesWInformation
Computer Science BachelorCompulsory Courses (4. Sem.)OInformation
Computer Science TCPart 1OInformation
Computer Science Teaching DiplomaPart 1OInformation