course-details-portlet

DIFT1002 - Introduction to information technology and databases

About

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
More on the course

No

Facts

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

Coursework

Term no.: 1
Teaching semester:  AUTUMN 2023

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 2023-12-12 15:00 INSPERA
Room Building Number of candidates
SL510 Sluppenvegen 14 34
SL238 Sluppenvegen 14 3
SL430 Sluppenvegen 14 50
SL520 Sluppenvegen 14 2
SL122 Sluppenvegen 14 1
Spring UTS School exam 100/100 B 2024-05-10 09:00 INSPERA
Room Building Number of candidates
SL110 hvit sone Sluppenvegen 14 1
  • * 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