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 |
| |