Dansk - English
Short version - Full version
Database Design and Technology (Fall 2011) |
|||
| 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 Transactions o Security and user rights o Backup and restoration 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 |
||