Search course

Use the search function to find more information about the study programmes and courses available at Chalmers. When there is a course homepage, a house symbol is shown that leads to this page.

Graduate courses

Departments' graduate courses for PhD-students.

​​​​
​​

Syllabus for

Academic year
DAT335 - Data Management
Systematisk datahantering
 
Syllabus adopted 2020-02-20 by Head of Programme (or corresponding)
Owner: TKITE
7,5 Credits
Grading: TH - Pass with distinction (5), Pass with credit (4), Pass (3), Fail
Education cycle: First-cycle
Major subject: Computer Science and Engineering, Software Engineering
Department: 37 - COMPUTER SCIENCE AND ENGINEERING


Teaching language: English
Application code: 52127
Open for exchange students: No
Block schedule: B+
Maximum participants: 15
Only students with the course round in the programme plan

Module   Credit distribution   Examination dates
Sp1 Sp2 Sp3 Sp4 Summer course No Sp
0117 Examination 4,5 c Grading: TH   4,5 c   15 Mar 2021 am L,  09 Jun 2021 am L,  18 Aug 2021 pm L
0217 Written and oral assignments 3,0 c Grading: UG   3,0 c    

In programs

TKITE SOFTWARE ENGINEERING, Year 2 (elective)
TKITE SOFTWARE ENGINEERING, Year 3 (elective)

Examiner:

Philipp Leitner

  Go to Course Homepage


Eligibility

General entry requirements for bachelor's level (first cycle)
Applicants enrolled in a programme at Chalmers where the course is included in the study programme are exempted from fulfilling the requirements above.

Specific entry requirements

The same as for the programme that owns the course.
Applicants enrolled in a programme at Chalmers where the course is included in the study programme are exempted from fulfilling the requirements above.

Aim

The course introduces the students to the role of data, information, and knowledge in
software engineering. The course has two general themes: (1) fundamental concepts
related to data in software engineering; (2) basic principles of database systems as seen
by users, application programmers and database administrators.

Learning outcomes (after completion of the course the student should be able to)

Knowledge and understanding
  • explain the differences between data, information and knowledge,
  • explain basic concepts: relational data model, non-relational data model, entity-relationship model, relational database design, relational algebra and the database language SQL
  • explain the ideas of distributed and NoSQL databases, and contrast them to the relational model

Skills and abilities
  • construct an algorithm for querying and filtering data based on predefined criteria
  • manage the process of collecting and representing data in a database
  • build a data model (entity-relationship model)
  • create database tables, and formulate database queries in SQL
  • experiment with data technologies such as big data and open data
  • manage and query NoSQL database systems
Judgement and approach
  • assess the quality of data and correctness of data models
  • evaluate the applicability of data management techniques for a given purpose, especially with respect to comparing monolithic and distributed, and relational and NoSQL database management systems

Content

The course introduces the student to the role of data, information, and knowledge in software engineering. The course has two general themes: (1) fundamental concepts related to data in software engineering; (2) basic principles of database systems as seen by users, application programmers and database administrators.

The course introduces concepts and techniques related to working with data, information and knowledge, although the focus is mostly on data and information. Techniques related to extraction, representation, modeling, and access , and visualization of data are discussed.

The course then introduces the role of databases and database management systems, covering topics such as algebra and the relational database, logical and physical design of databases, and the use of SQL. This includes programming in SQL, from the perspective of a user querying or modifying an existing database, by a database designer, and by an application programmer invoking SQL from a host language. Further, the student learns to query NoSQL databases, and contrast them to the relational model. The course also covers different data models such as XML, RDF, and JSON.

Organisation

The teaching consists of lectures, group work, exercises, as well as supervision in
connection to the exercises.

Literature

Ramez Elmasri, Shamkant B. Navathe: Fundamentals of Database Systems (7th Edition)

Examination including compulsory elements

Written exam and assignments.


Page manager Published: Thu 04 Feb 2021.