Course - Introduction to information technology and databases - DIFT1002
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, collaboration tools, social media 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
- knowing useful collaboration tools and key social media
- 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 choose appropriate collaborative tools to solve tasks in collaboration with others
- 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)
Recommended previous knowledge
Basic use of web-browser and text editor.
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 |
No
Version: 1
Credits:
7.5 SP
Study level: Foundation courses, level I
Term no.: 1
Teaching semester: AUTUMN 2022
Language of instruction: Norwegian
Location: Trondheim
- Computer and Information Science
Department with academic responsibility
Department of Computer Science
Examination
Examination arrangement: School exam
- Term Status code Evaluation Weighting Examination aids Date Time Examination system Room *
- Autumn NY School exam 100/100 B 2023-01-11 09:00 INSPERA
-
Room Building Number of candidates SL310 blå sone Sluppenvegen 14 42 SL274 Sluppenvegen 14 2 - Autumn ORD School exam 100/100 B 2022-12-13 15:00 INSPERA
-
Room Building Number of candidates SL311 orange sone Sluppenvegen 14 46 SL430 Sluppenvegen 14 2 SL317 Sluppenvegen 14 1 - Spring UTS2 School exam 100/100 B 2023-06-08 09:00 INSPERA
-
Room Building Number of candidates SL311 lyseblå sone Sluppenvegen 14 1 SL215 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.
For more information regarding registration for examination and examination procedures, see "Innsida - Exams"