course-details-portlet

DIFT1002 - Introduction to information technology and databases

About

This course is no longer taught and is only available for examination.

Examination arrangement

Examination arrangement: School exam
Grade: Letter grades

Evaluation Weighting Duration Grade deviation Examination aids
School exam 100/100 3 hours B

Course content

IT introduction: Introduction to information technology, computer architecture, binary system, software and operating systems, local networks and the Internet, virtualization and cloud computing and data security.

Databases: Introduction to data modeling with EER. Design of relation database including use of keys and reference integrity. Database Definition (DDL) and Data Manipulation (DML) in SQL. Use of a selected database tool (MySQL or equivalent).

Learning outcome

Knowledge

The candidate:

  • can describe the computer's basic architecture
  • explain the operating system's basic functions and roles
  • explain the basic behavior of local networks and the internet
  • know the concepts of virtualization and known providers within cloud services
  • know important concepts within databases and explain these
  • can use SQL
  • understand (interpret) an (E) ER diagram and know how this can be translated into the relational data model

Skills

The candidate:

  • can secure their own computer and computer networks against attacks and accidents
  • can create a virtual machine or service with a cloud computing supplier
  • can draw their own (E) ER diagrams to achieve a good database structure
  • can create a separate database and retrieve and modify the data in this database, all through SQL

General competence

The candidate:

  • get a basic understanding of how information technology is used in different contexts of society
  • get an understanding of how database solutions can be used to solve different requirements for storing digital data.

Learning methods and activities

Teaching and practical compulsory exercises that are included in the work requirements, supervision with a teacher and / or teaching assistant.

Compulsory assignments

  • Exercises

Further on evaluation

Deferred exam is conducted in the next regular exam period (may/june).

Assessment report requires approved teaching message the same semester. Mandatory activity from previous semesters can be approved by the professor.

Specific conditions

Admission to a programme of study is required:
Digital Business Development (ITBAITBEDR)

Course materials

Given at the start of the study.

Credit reductions

Course code Reduction From To
INFT1001 7.5 AUTUMN 2019
IINI1001 3.7 AUTUMN 2019
IFUD1101 3.7 AUTUMN 2019
IINI1003 3.7 AUTUMN 2019
IFUD1103 3.7 AUTUMN 2019
IDRI1002 7.5 AUTUMN 2019
IDATT2103 3.0 AUTUMN 2020
IDATT2002 3.0 AUTUMN 2023
INFT1009 3.0 AUTUMN 2024
More on the course

No

Facts

Version: 1
Credits:  7.5 SP
Study level: Foundation courses, level I

Coursework

Language of instruction: Norwegian

Location: Trondheim

Subject area(s)
  • Computer and Information Science
Contact information
Course coordinator: Lecturer(s):

Department with academic responsibility
Department of Computer Science

Timetable

List view
Calendar view

Examination

Examination arrangement: School exam

Term Status code Evaluation Weighting Examination aids Date Time Examination system Room *
Autumn ORD School exam 100/100 B 2024-12-10 09:00 INSPERA
Room Building Number of candidates
SL110 lilla sone Sluppenvegen 14 8
  • * 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