62474 Database Design and Technology

2019/2020

El-teknologi og IT(100)
Sundhedsteknologi: Valgfag
Kursusinformation
Database Design and Technology
Engelsk
5
Diplomingeniør
Kurset udbydes som enkeltfag
F1A (man 8-12)
Campus Ballerup
Lectures and exercises/discussion in class
13-uger
F1A, Ved store hold udvides med ekstra eksamensdage
Mundtlig eksamen og bedømmelse af rapport(er)
Mundtlig eksamen baseret på en afleveret opgave hvor en problemstilling er identificeret og modelleret - og en database implementeret.
Alle hjælpemidler er tilladt
7-trins skala , intern bedømmelse
IDDT-U1
62T21.62233.62551
62450 , Programmeringserfaring
Roger Munck-Fairwood , Ballerup Campus, Bygning Ballerup, Tlf. (+45) 3588 5188 , romu@dtu.dk
62 DTU Diplom
I studieplanlæggeren
Overordnede kursusmål
This course aims to give the student the necessary theoretical and practical background for the design and manipulation of large databases.
Læringsmål
En studerende, der fuldt ud har opfyldt kursets mål, vil kunne:
  • Apply technical terms correctly
  • Develop an entity/relationship diagram (ER-diagram) that reflects a chosen problem domain, for example a small business
  • Explain and carry out transformation of ER to table structure; draw and explain a referential integrity diagram
  • Normalise tables to third normal form
  • Understand the purpose of transaction control and how to apply it
  • Understand relational algebra as the basis for database queries
  • Use SQL to define tables and constraints
  • Use SQL to define views (including complex queries)
  • Describe the use of indexes
  • Describe the concepts of users and rights
  • Describe possible implications for a programmer developing a (web) application that access a database (e.g. domain-specific constraints or queries, error handling, or access rights)
  • Write a report as documentation for the course assignment
Kursusindhold
SQL - the standard language for relational databases
o Data Definition Language (DDL)
o Data Manipulation Language (DML)
o Data Control Language (DCL)

Logical database design
o Entity/relationship diagrams (ER)
o Transformation of ER to table structure
o Functional dependency and normalisation
o Relational integrity
o Documentation, including property tables
o Relational algebra

Database management systems (DBMS)
o Physical database design and configuration
o Indexing
o System catalogue
o Security and user rights
o Transaction control

Web applications and databases
Implications for a programmer developing a (web) application that access a database
Litteraturhenvisninger
Elmasri, Ramez & Navathe, Shamkant: Fundamentals of Database Systems, 7/E, Global Edition, Pearson 2017, ISBN 1-292-09761-2
Bemærkninger
Exam:
The course is examined on the basis of an assignment where a small problem domain is identified and modelled, and a database implemented.
Sidst opdateret
05. april, 2019