Copenhagen School of Design and Technology

da

Databases for Developers

2023/2024
Danish title
Databaser for udviklere
Study programme
Software Development
Type of education
Full time education
Level of education
Bachelor (top-up)
Duration of the subject/module
1 semester
Ects
10
Programme elements
Compulsory
Language
English
Start time
Autumn
Location
Håndværkergården, København N
Subject number
9942152
Responsible for the subject(s)/modul(es)
Tomas Pesek
Constantin Alexandru Gheorghiasa
Arturo Mora Rioja
  • Purpose and learning objectives

    The aim of the subject element is to train the student to be able to select and apply various database types appropriately in relation to various fields of application. The student must also be able to analyse and develop in relation to large databases, including redesign and optimisation.

    Knowledge

    The student must have knowledge of:
    •Various database types and the underlying models
    •A specific database system’s storage organisation and query execution
    •A specific database system’s optimisation possibilities – including advantages and disadvantages
    •Database-specific security problems and their solutions
    •Concepts and issues in relation to data warehousing, including big data
    •The particular issues raised by having many simultaneous transactions, including in connection with distributed databases
    •Relational algebra (including its relationship to execution plans)

    Skills

    The student can:
    •Transform logical data models into physical models in various database types
    •Implement database optimisation
    •Use parts of the administration tool to assist in the optimisation and tuning of existing databases, including the incorporation of a specific DBMS’ execution plans
    •Use a specific database system’s tools for handling simultaneous transactions
    •Use the programming and other facilities provided by a modern DBMS
    •Use an object-relational mapping tool

    Competences

    The student can:
    •Analyse the application domain in order to select a database type
    •Divide responsibility for tasks between the application and DBMS during system development, to ensure the best possible implementation.

  • Type of instruction
    The teaching is organised as a variation between class teaching, guest lecturing, company visits, group project work and individual work. The learning is most often problem-based and cross-disciplinary and always practise-oriented. In addition to learning the subject, the student will gain the competences to work individually and in collaboration with others.

    The common aim of the activities is always to set clear intended learning objectives.
  • Subject/module requirement for participation

    Equipment needed to participate
    Windows PC, Mac or Linux
    - min 8 GB RAM (16 GB RAM preferably)
    - 200 GB available disk space
    - CPU with virtualisation hardware (usually available in most modern CPUs)
    - 15,6” screen or bigger is recommended

  • Exam

    The learning outcomes of the exam are identical with the learning outcomes of the subject(s)/modul(es)

    Prerequisites for access to the examination
    During the Database module, the student will be given two mandatory assignments and an exam report.

    To attend the exam, the student will have to write a report reflecting upon different topics related to the course and hand it in Wiseflow.

    The report is not graded. If fulfilled, the student will be allowed to enter the exam. If not, the student will get a 00 at the exam.

    During the exam the student may be asked to show the mandatory assignments. Failure to do so will mean that the student gets a 00.
    Exam in one or more subjects
    Subject/module is tested standalone
    Type of exam
    Oral examination
    Formal requirements
    Number of stud Number of pages
    2 Max 25
    3 Max 30
    4 Max 35
    Individual exam or group exam
    Individual
    Exam languages
    English
    Duration
    Presentation - max 10 min.
    Examination- max. 15 min.
    Grading - 5 min.
    Total - 30 min.
    Permitted exam aids
    Computer
    Available exam aids
    Projector
    Type of evaluation
    7-point grading scale
    Examiners
    External censure
  • Preliminary literature list
    This is a preliminary literature list. A final literature list will be provided in connection with study start.
    Course materials available to the students via Internet.
  • Additional information
    Some classes may take place online.
90
hours of teaching
184
hours of preparation
The figure shows the extent of workload related to the subject divided into different study activities.

In the subject Databases for Developers you will receive 90 hours of instruction, which corresponds to 120 lessons (1 lesson = 45 min.) and 33% of your total workload for the subject.

The teaching primarily consists of the following activities: classroom teaching, external lectures, group work, Online teaching.
The preparation primarily consists of the following activities: reading your own notes, reading the curriculum, group work, project work.

Read about KEAs Study Activity Model

*KEA can deviate from the number of hours if this is justified by special circumstances