Credits: 5

Schedule: 14.04.2020 - 19.05.2020

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.

Assessment Methods and Criteria (valid 01.08.2018-31.07.2020): 

Final examination and programming assignments.

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.

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

0-5

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.

Description

Registration and further information