Data Management Systems 1Laajuus (5 op)

Osaamistavoitteet

- you know concepts and principles of data management
- you know the different data models used in database design
- you know principles of database management systems (DBMSs), base functions and purposes
- you are able to use of database as a part of information system
- you know how to implement a database based on a relational model.

Sisältö

- Data management: Knowledge, information, and database management
- Data models
- Entity-relationship (ER) model
- Database normalization
- SQL-language (data manipulation and definition languages (DML and DDL)
- Database Management Systems.

a small database application is done as an exercise.