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: 04.06.2020 - 03.09.2020

Teacher in charge (valid 01.08.2020-31.07.2022): Nitin Sawhney

Teacher in charge (applies in this implementation):

Contact information for the course (valid 14.05.2020-21.12.2112):

For questions regarding the course you are welcome to contact lecturers Prof. Nitin Sawhney or Dr. Lukas Ahrenberg, via email: firstname.lastname@aalto.fi .

For questions and help regarding the exercises and assignments enrolled students should use the Piazza forum (link can be found on the MyCourses pages once the course starts).

CEFR level (applies in this implementation):

Language of instruction and studies (valid 01.08.2020-31.07.2022):

Teaching language: English

Languages of study attainment: English

CONTENT, ASSESSMENT AND WORKLOAD

Content
  • Valid 01.08.2020-31.07.2022:

    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.

  • Applies in this implementation:


Assessment Methods and Criteria
  • Valid 01.08.2020-31.07.2022:

    Final examination and programming assignments.

  • Applies in this implementation:

    • Two-part mandatory group project (Deadline for part 1: August 7, 2020; Deadline for part 2: August 28, 2020).
    • Mandatory Exam held on September 3, 2020, 09:00-12:00.
    • In
      addition there are five rounds of voluntary assignments (opening in
      stages June 4-June 18, with corresponding deadlines August 4-August 12),
      completion of which provides bonus points when doing the exam.



Workload
  • Valid 01.08.2020-31.07.2022:

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

DETAILS

Study Material
  • Valid 01.08.2020-31.07.2022:

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

  • Applies in this implementation:

    During the summer of 2020 the course will be offered online using video lectures.


Prerequisites
  • Valid 01.08.2020-31.07.2022:

    CS-A1110 Programming 1 or CS-A1111/CS-A1113 Basic Course in Programming Y1.

FURTHER INFORMATION

Further Information
  • Valid 01.08.2020-31.07.2022:

    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.

  • Applies in this implementation:

    Parts of this course is offered jointly with the summer course CS-A1150.

Details on the schedule
  • Applies in this implementation:

    The course will be paced at two lectures per week during June and August.

    • Deadline for Project Part 1 : 2020-08-07
    • Deadline for Project Part 2 : 2020-08-28
    • Deadlines for voluntary exercises: 2020-08-04 - 2020-08-12
    • Exam: 2020-09-03 09:00 - 12:00