62474 Database Design and Technology

2016/2017

Informatik(100)
Sundhedsteknologi: Valgfag
Kursusinformation
Database Design and Technology
Engelsk
5
Diplomingeniør
Kurset udbydes under tompladsordningen
F5A (ons 8-12)
Campus Ballerup
Lectures and exercises/discussion in class
13-uger
Aftales med underviser, Aftales med underviser
Mundtlig eksamen og bedømmelse af rapport(er)
Alle hjælpemidler er tilladt
7-trins skala , intern bedømmelse
IDDT-U1
62T21.62233.62551
62450.62480
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 database systems.

To enable the student to:
- design a database structure that reflects the problem domain, for example a small business
- understand and use methods and tools for constructing and maintaining databases
- understand implications for a programmer developing a web application that access a database
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)
  • 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: Database Systems, 6/E, Pearson 2011, ISBN 0-13-214498-0
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
01. november, 2016