course-details-portlet

IT6104 - Database Technology for Health Personnel

About

Examination arrangement

Examination arrangement: Home examination
Grade: Letter grades

Evaluation Weighting Duration Grade deviation Examination aids
Home examination 100/100 A

Course content

How can actual conditions and events be represented in the form of structured data that can be shared and be of information and benefit to many? Database systems are software systems for making available, maintaining and managing access to collections of data. A collection of data managed by one database system is a database. The databases are basic elements in all IT solutions. Without data, there is no information to use - share, interpret, explore or learn from.

Database technology is a prerequisite for utilizing data as a resource. The course deals with data modeling and design theory for relational databases and programming against relational databases.

Learning outcome

After completing the course, the participant must have knowledge of:

  • Database systems, general properties and system structure.
  • Data modeling with emphasis on the entity-relationship model (ER model).
  • The relational database model, transition from ER model to database in tabular form, the relational model.
  • Query language: Relational algebra and SQL- Structured Query Language.
  • Data storage, organization of data for fast retrieval and compilation
  • Methods that provide correct execution and safe storage
  • Methods for securing against unauthorized access to and use of data

After completing the course, the participant must have skills in:

  • Data modeling with the entity-relationship model.
  • Realization of relational databases.

After completing the course, the participant must have:

  • Knowledge of applications of database systems and understanding of the benefits and limitations of such systems.
  • Modeling and analytical approach to computer problems.
  • Strategic knowledge about the importance of information infrastructure and data sharing from structured data collections

Learning methods and activities

Gatherings and web based interactions.

The teaching is given in the form of an alternation between theoretical lectures and practical exercises - individually and in groups. After each session, homework assignments are given that give participants quick and immediate experience in using theoretical insight to solve concrete, realistic example problems. Most of the teaching takes place in English.

Attendance at gatherings is mandatory.

Subject to a sufficient number of applicants for the course to be completed.

Compulsory assignments

  • Participation
  • Semester assignment

Further on evaluation

Individual home exam (4 hours). Exam requirements: Approved semester assignment and participation in gatherings. Students with approved mandatory activity will not need to complete this again in case of a re-sit exam.

Specific conditions

Admission to a programme of study is required:
Healthcare Informatics (MHI)

More on the course

No

Facts

Version: 1
Credits:  7.5 SP
Study level: Further education, higher degree level

Coursework

Term no.: 1
Teaching semester:  SPRING 2025

Language of instruction: Norwegian

Location: Trondheim

Subject area(s)
  • Technological subjects
Contact information
Course coordinator:

Department with academic responsibility
Department of Computer Science

Department with administrative responsibility
Section for quality in education and learning environment

Examination

Examination arrangement: Home examination

Term Status code Evaluation Weighting Examination aids Date Time Examination system Room *
Spring ORD Home examination 100/100 A 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.
Examination

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

More on examinations at NTNU