Dansk - English
Short version - Full version
Database Design and Technology (Fall 2011) |
|||
Course code : | IDDT-U1 | ||
ECTS Credits : | 7,5 | Status : | Optional |
Revised : | 12/04 2011 | Written : | 02/06 2010 |
Placement : | 5. & 6. semester | Hours per week : | 4 |
Length : | 1 semester | Teaching Language : | English |
Objective : | This course aims to give the student the necessary theoretical and practical background for the design and manipulation of large database systems. The student will also learn how to construct a basic web application that accesses a database. 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 and use methods and tools for basic web applications that access a database. Learning outcomes (technical) - Apply technical terms correctly - Develop an entity/relationship diagram (ER-diagram) - Explain and carry out transformation of ER to table structure - Normalise tables to third normal form - Draw and explain a referential integrity diagram - Describe property tables - 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 - Implement a simple web application that accesses a database Learning outcomes (non-technical) - Write a report as documentation for the course assignment |
||
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 | ||
Recommended prerequisites : | Good experience of programming. | ||
Relations : | - | ||
Type of examination : | Oral examination based on a project | ||
External examiner : | Internal | ||
Marking : | 7 step scale | ||
Remarks : | Exam: The course is examined on the basis of an assignment where a small problem domain is identified and modelled, and a database implemented. |
||
Teaching material : | Ramakrishnan, Raghu & Gehrke, Johannes: Database Management Systems, McGraw-Hill | ||
Responsible teacher : | Roger Munck-Fairwood
, romu@dtu.dk |