Single-Course English 5 ECTS

Database Systems

DTU Compute

Overall Course Objectives

The course objective is to give an introduction to databases, fundamental database concepts, and the usage of databases. As a database is often the central component in an IT system, a basic knowledge of database concepts is most useful in order to understand the design and working of most IT systems used by private and public enterprises.

Students will become familiar with database theory and fundamental database concepts, be able to make data models, be able to convert these to simple databases, and be able to perform operations on databases. Students will also get a basic knowledge of the tasks normally performed by database designers and administrators.

Learning Objectives

  • design a conceptual data model
  • transform a conceptual data model into a logical data model for a relational database
  • optimize a logical data model using normalization
  • carry out a physical database design for relational databases: decide how the logical data model is to be implemented in a database management system
  • use a widespread database management system
  • explain and apply techniques for optimizing the physical access of data in databases
  • perform programming tasks to create, query, update, and administrate a database
  • formulate queries in formal relational query languages
  • understand tasks normally solved by database designers and administrators

Course Content

– An introduction to databases
– The relational model and query language SQL
– Relational algebra and calculus base calculations
– Entity-Relationship diagrams and relational schemas
– Features of good relational designs and normal forms
– Efficient database implementations
– External guests will, based on own working experiences, explain about selected aspects of databases

Recommended prerequisites

01017/01019/02105/02110, or equivalent knowledge about
(1) discrete mathematics: set theory and logical operators,
(2) programming, algorithms and data structures (at the level of 02105), and
(3) balanced trees (as taught in 02110).

Teaching Method

Lectures and exercises and a group project.

Faculty

Anne Elisabeth Haxthausen

Contact or read more about Anne Elisabeth
Anne Elisabeth Haxthausen

Limited number of seats

Minimum: 5.

Please be aware that this course will only be held if the required minimum number of participants is met. You will be informed 8 days before the start of the course, whether the course will be held.

See course in the course database.

Registration

Language

English
Duration

13 weeks
Institute

Compute
Place

DTU Lyngby Campus
Course code 02170
Course type Bachelor
Semester start Week 5
Semester end Week 19
Days Thurs 8-12
Price

7.500,00 DKK

Please note that this course has participants limitation. Read more

Related educations

Registration