Course - Information Structures and Database Systems - IDG2004
IDG2004 - Information Structures and Database Systems
About
Examination arrangement
Examination arrangement: Aggregate score
Grade: Letter grades
| Evaluation | Weighting | Duration | Grade deviation | Examination aids |
|---|---|---|---|---|
| Assignments | 20/100 | |||
| Written School exam | 80/100 | 4 hours |
Course content
The course includes, but is not limited to, the following topics:
- Basic concepts of database and database management systems.
- Conceptual data modeling.
- 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 language for relational model.
- 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.
Further on evaluation
Grade: Letters (A - F) based on:
- Assignments: 20/100
- Written exam: 80/100
Resit examination - for the written exam in August. The resit examination may be oral if few students are enrolled. No resit for the assignments.
Assignment score is valid for a year.
Retake can be carried out for some partial assessments without all partial assessments having to be taken up again.
Specific conditions
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 2023
Language of instruction: English
Location: Gjøvik
- Database technology
Department with academic responsibility
Department of Computer Science
Examination
Examination arrangement: Aggregate score
- Term Status code Evaluation Weighting Examination aids Date Time Examination system Room *
- Autumn ORD Written School exam 80/100 2023-12-18 09:00 INSPERA
-
Room Building Number of candidates M438 Eksamensrom 4.etg, Inngang D Mustad, Inngang D 19 - Autumn ORD Assignments 20/100 INSPERA
-
Room Building Number of candidates - Summer UTS Written School exam 80/100 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"