course-details-portlet

IDG2004 - Information Structures and Database Systems

About

Examination arrangement

Examination arrangement: Aggregate score
Grade: Letters

Evaluation Weighting Duration Grade deviation Examination aids
Assignment 20/100
School exam 80/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.

Further on evaluation

Grade: Letters (A - F) based on: 

  • Written exam: 80/100 
  • Other work (5 practice assessments): 20/100 

Resit examination - written exam in August. The resit examination may be oral if few students are enrolled.

Specific conditions

Admission to a programme of study is required:
Geomatics (BIGEOMAT)
Web Development (BWU)

Course materials

Announced at the start of the course.

More on the course

No

Facts

Version: 1
Credits:  7.5 SP
Study level: Intermediate course, level II

Coursework

Term no.: 1
Teaching semester:  AUTUMN 2021

Language of instruction: English

Location: Gjøvik

Subject area(s)
  • Database technology
Contact information
Course coordinator:

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 School exam 80/100 E 2021-12-01 09:00 INSPERA
Room Building Number of candidates
M433-Eksamensrom 4.etg Mustad, Inngang A 33
Autumn ORD Assignment 20/100

Submission
2021-11-20


23:59

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

For more information regarding registration for examination and examination procedures, see "Innsida - Exams"

More on examinations at NTNU