Please note! Course description is confirmed for two academic years, which means that in general, e.g. Learning outcomes, assessment methods and key content stays unchanged. However, via course syllabus, it is possible to specify or change the course execution in each realization of the course, such as how the contact sessions are organized, assessment methods weighted or materials used.

LEARNING OUTCOMES

After the course you understand the role of conceptual modeling in managing data, and know the commonly used database modeling and querying languages. You can design simple databases and write queries.

Credits: 5

Schedule: 19.04.2022 - 27.05.2022

Teacher in charge (valid for whole curriculum period):

Teacher in charge (applies in this implementation): Nitin Sawhney

Contact information for the course (applies in this implementation):

CEFR level (valid for whole curriculum period):

Language of instruction and studies (applies in this implementation):

Teaching language: English. Languages of study attainment: English

CONTENT, ASSESSMENT AND WORKLOAD

Content
  • valid for whole curriculum period:

    Basic concepts and methods in database systems. Relational databases: relational algebra, UML-design, Basic concepts and methods in database systems. Relational databases: relational algebra, UML-design, normalization and SQL.

Assessment Methods and Criteria
  • valid for whole curriculum period:

    Final examination and programming assignments.

Workload
  • valid for whole curriculum period:

    Lectures 24h, teaching in small groups 12h, project work 45h, independent work 47h.

DETAILS

Study Material
  • valid for whole curriculum period:

    Ullman, Widom: A First Course in Database Systems, Third Edition. Pearson.

Substitutes for Courses
Prerequisites

FURTHER INFORMATION

Further Information
  • valid for whole curriculum period:

    This course is designed for Data Science BSc students; for other students we recommend taking the course CS-A1150 Tietokannat. The course is overlapping with CS-A1150 and only one of them can be included in a degree.

    Teaching Period:

    2020-2021 Spring V

    2021-2022 Spring V

    Course Homepage:

    https://mycourses.aalto.fi/course/search.php?search=CS-A1153

    Registration for Courses: Kurssille ilmoittaudutaan WebOodissa. Katso ilmoittautumisaika WebOodista. Ilmoittautumiseen