Credits: 5

Schedule: 04.06.2020 - 03.09.2020

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

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

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).

Teaching Period (valid 01.08.2018-31.07.2020): 

V (Spring 2020)
The course is not lectured in the Spring of 2020. If the course is compulsory for you, please contact planning officer Elsa Kivi-Koskinen for further advice.

Learning Outcomes (valid 01.08.2018-31.07.2020): 

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.

Content (valid 01.08.2018-31.07.2020): 

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.

Details on the course content (applies in this implementation): 

Assessment Methods and Criteria (valid 01.08.2018-31.07.2020): 

Final examination and programming assignments.

Elaboration of the evaluation criteria and methods, and acquainting students with the evaluation (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.2018-31.07.2020): 

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

Study Material (valid 01.08.2018-31.07.2020): 

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

Details on the course materials (applies in this implementation): 

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

Prerequisites (valid 01.08.2018-31.07.2020): 

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

Grading Scale (valid 01.08.2018-31.07.2020): 


Further Information (valid 01.08.2018-31.07.2020): 

The course is overlapping with CS-A1150 and only one of them can be included in a degree.

Additional information for the course (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


Registration and further information