Dansk - English

Short version - Full version


Database Design and Technology (Fall 2012)

Course code : IDDT-U1
ECTS Credits : 7,5 Status : Optional
Placement : 5. & 6. semester Hours per week : 4
Length : 1 semester Teaching Language : English

Principal Content : 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

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

Web applications and databases
o Basic HTML
- Server-side programming, using for example Java Server Pages (JSP)
Required prequisites : PROG2
Responsible teacher : Roger Munck-Fairwood , romu@dtu.dk