IT-Universitetet i København
 
  Tilbage Kursusoversigt
Kursusbeskrivelse
Kursusnavn (dansk):Database Use and Design 
Kursusnavn (engelsk):Database Use and Design 
Semester:Forår 2014 
Udbydes under:Bachelor i global virksomhedsinformatik (bgbi) 
Omfang i ECTS:7,50 
Kursussprog:Engelsk 
Kursushjemmeside:https://learnit.itu.dk 
Min. antal deltagere:12 
Forventet antal deltagere:50 
Maks. antal deltagere:75 
Formelle forudsætninger:Information about the course of study
This course is part of the second semester in the bachelor’s degree in Global Business Informatics. A description of the course of study can be found here:
Bachelor Global Business Informatics  
Læringsmål:After the course, students should be able to:
• Explain the basic aspects of a database system and its place in an IT infrastructure.
• Explain the importance of business rules and user requirements.
• Model data using ER diagrams.
• Discuss the principle of normalization.
• Use simple SQL statements to create, read, update, and delete data in a data base.
• Explain the construction of reports based on a data model.
• Evaluate security measures for protecting the integrity and consistency of databases.
• Explain the basic of no-sql databases, data warehouse, and Business Intelligence. 
Fagligt indhold:IT, Information Technology, is about handling data and turning it into information.

IT systems take data as input, process and store it, and provide output. The data is stored in databases, ranging from simple unstructured files for single users to sophisticated multi-tier architectures for large organizations, with advanced support for recovery, security, concurrency, etc.

This course will focus the general principles of database systems, data modeling, and mainstream database technologies and methods; for example relational databases and the entity-relationship model. The course also briefly introduces a broader perspective on data storage and use. The primary goal is to provide an orientation around the diverse and heterogeneous techniques used for various databases in our communication-intensive globalized world. 
Læringsaktiviteter:12 forelæsninger og 12 øvelsesgange

Lectures, homework assignments (e.g. design exercises). 

Obligatoriske aktivititer:Three written mandatory individual assignments (may be prepared in groups) during the semester. 
Eksamensform og -beskrivelse:X. experimental examination form (7-scale; external exam), 7-trins-skala, Ekstern prøve

.  

Litteratur udover forskningsartikler:Modern Database Management, 11th edition 
 
Afholdelse (tid og sted)
Kurset afholdes på følgende tid og sted:
UgedagTidspunktForelæsning/ØvelserStedLokale
Mandag 08.00-09.50 Forelæsning ITU Aud 3
Mandag 10.00-11.50 Øvelser ITU 2A14, 2A52

Eksamen afholdes på følgende tid og sted:
EksamensdatoTidspunktEksamenstypeStedLokale
2014-06-04 09:00-13:00 Skriftlig eksamen ITU Students first name from A to M - Room 3A12/14
2014-06-04 09:00-13:00 Skriftlig eksamen ITU Students first name from N to Y - Room 2A14
2014-08-19 RE-EXAM - 09:00-13:00 Skriftlig eksamen ITU 2A14