252-0063-00L  Data Modelling and Databases

SemesterSpring Semester 2019
LecturersG. Alonso, C. Zhang
Periodicityyearly recurring course
Language of instructionEnglish



Courses

NumberTitleHoursLecturers
252-0063-00 VData Modelling and Databases4 hrs
Wed13:15-15:00ML D 28 »
Fri08:15-10:00HG F 3 »
G. Alonso, C. Zhang
252-0063-00 UData Modelling and Databases2 hrs
Thu15:15-17:00CAB G 11 »
Fri13:15-15:00CHN C 14 »
G. Alonso, C. Zhang

Catalogue data

AbstractData modelling (Entity Relationship), relational data model, relational design theory (normal forms), SQL, database integrity, transactions and advanced database engines
Learning 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, 7. Auflage, 2009.

Garcia-Molina, Ullman, Widom: Database Systems: The Complete Book. Pearson, 2. Auflage, 2008.

Performance assessment

Performance assessment information (valid until the course unit is held again)
Performance assessment as a semester course
ECTS credits7 credits
ExaminersG. Alonso, C. Zhang
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
Additional information on mode of examinationDie Prüfung kann am Computer stattfinden. The examination may take place on the computer.
Written aidsIn sämtlichen Prüfungen sind keine Hilfsmittel erlaubt. In the exam, no supporting material is allowed
Digital examThe exam takes place on devices provided by ETH Zurich.
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
Computational Biology and Bioinformatics MasterTheoryWInformation
Computer Science BachelorBasic CoursesOInformation
Computer Science BachelorCompulsory CoursesOInformation
Computer Science Teaching DiplomaPart 1OInformation