Dansk - English
Short version - Full version
Databases (Spring 2004) |
|||
| Course code : | IDBS3A-U01 | ||
| ECTS Credits : | 10 | Status : | Compulsory |
| Revised : | 26/01 2004 | Written : | 11/06 2001 |
| Placement : | 3. semester | Hours per week : | 8 |
| Length : | 1 semester | Teaching Language : | Danish if no English students are present |
| Objective : | The students learn to design and implement relations databases, and perform Inquiry’s by means of SQL. Developments of client and server web applications with proper use of ASP (Active Server Pages). Basic knowledge of database security and data warehouse. | ||
| Principal Content : | 1. Introduction to database tools. 2. Introduction to databases with entity sets and relationship types together with ER-diagrams. 3. Database normalization algorithm dependencies, consistency preservation and the conception of primary/foreign keys. 4. Information analyses, database design, metadata and data modeling. 5. Queries and updating with SQL standard. 6. Place data together from several databases (data warehouse). 7. Overall database security. 8. ActiveX Data Objects (ADO) with Visual Basic. 9. Web applications & ASP. 10. Visit a company with a database department. | ||
| Teaching method : | The curriculum of the course unit will be introduced by the teacher and supplied with exercises and course assignments in groups. The final course assignment must be documented in a report that will be used for the oral examination. | ||
| Required prequisites : | Documented knowledge corresponding to OOP1 | ||
| Recommended prerequisites : | - | ||
| Relations : | - | ||
| Type of examination : | Look under remarks | ||
| External examiner : | Internal | ||
| Marking : | Scale of 13 | ||
| Remarks : | - | ||
| Teaching material : | Database design & Programming by John Carter. ISBN: 0-07-709974-5. Material Second Edition 2003 | ||
| Responsible teacher : | Jens Tovgaard
, jto@ihk.dk |
||