Course - Information Structures and Database Systems - IDG2004
IDG2004 - Information Structures and Database Systems
About
Examination arrangement
Examination arrangement: School exam
Grade: Letter grades
| Evaluation | Weighting | Duration | Grade deviation | Examination aids |
|---|---|---|---|---|
| School exam | 100/100 | 4 hours | E |
Course content
- Basic concepts of database and database management systems.
- Conceptual data modeling with Entity Relationship Diagram.
- Introduction to relational model, constraints and relational algebra.
- Logical database design and normalization.
- SQL for defining, manipulating and querying database.
- XML data, XML Schema, XPath and XSLT.
Learning outcome
After completing the course successfully,
The student has knowledge of:
- Database management systems - characteristics and general structure.
- Data modeling with a focus on conceptual modeling.
- Relational model, its characteristics and integrity constraints.
- Query languages for relational model - relational algebra and SQL.
- Logical design and normalization for relational databases.
- Structuring and management of semi-structured data using XML.
The student acquires the skills to:
- Create and assess conceptual and associated logical data models.
- Construct relational database solutions based on conceptual and logical models.
- Employ normalization to evaluate and assess relational databases.
- Make use of SQL for defining, manipulating and querying relational databases.
- Utilize XML technologies for storing and processing semi-structured data.
The student acquires general competence in:
- Knowledge of database systems - their applications, benefits and limitations.
- Creating abstract models and solutions for practical problems.
- Assessing alternatives for storing and managing digital data.
- Using computer tools for developing software systems.
Learning methods and activities
Lectures, in-class exercises, laboratory work, assignments.
Compulsory assignments
- Mandatory Assignments
Further on evaluation
Mandatory assignment consisting of multiple parts.
Grade: Letters (A - F) based on:
- Written exam: 100/100
Resit examination - written exam in August. The resit examination may be oral if few students are enrolled.
Specific conditions
Compulsory activities from previous semester may be approved by the department.
Admission to a programme of study is required:
Business Administration (BØA)
Geomatics (BIGEOMAT)
Web Development (BWU)
Recommended previous knowledge
-IMT1031 Fundamental Programming or -IMT1241 Basic Java Programming or -IMT1441 Programming for the Web I -IMT1401 Information and publishing technology
Course materials
Announced at the start of the course.
No
Version: 1
Credits:
7.5 SP
Study level: Intermediate course, level II
Term no.: 1
Teaching semester: AUTUMN 2022
Language of instruction: English
Location: Gjøvik
- Database technology
Department with academic responsibility
Department of Computer Science
Examination
Examination arrangement: School exam
- Term Status code Evaluation Weighting Examination aids Date Time Examination system Room *
- Autumn ORD School exam 100/100 E 2022-12-07 09:00 INSPERA
-
Room Building Number of candidates M438 Eksamensrom 4.etg, Inngang D Mustad, Inngang D 35 - Summer UTS School exam 100/100 E INSPERA
-
Room Building Number of candidates
- * The location (room) for a written examination is published 3 days before examination date. If more than one room is listed, you will find your room at Studentweb.
For more information regarding registration for examination and examination procedures, see "Innsida - Exams"