SoleOPS 3.13.0, ©2005-2018Solenovo Oy

Opintojakson toteutussuunnitelma

GroupT402D14S/Business Information Technology (Tornio)
Study unitT402D32 Databases, 5.00 ECTS credits, 133 h
PROFESSIONAL STUDIES
ImplementationPerustoteutus/15001
Unit
Time of implementationAutumn2/2015-2016
Responsible teacherVuokila Johanna
Other teachers
Status of implementationFinished

Description status Ready
  
Language of instruction English
Starting and ending dates25.10.2015 - 31.12.2015
Minimum number of participants  
Maximum number of participants  
Enrolment period31.08.2015 - 13.09.2015
Implementation method
Virtuality 0 ECTS credits
R&D integration 0 ECTS credits
Resit dates of the exam
Koulutuksen aikataulu (www-linkki)
Description language English 
Objectives

The Students can design, define and implement databases. They know the tools for database administration.   

 
Assessment criteria

To pass the course students has to full fill following assessment criteria:

The student can define a database according to given requirements.

 
Pedagogical arrangements

Lectures, exersices, assignments.

Material

www.w3school.com (sql)

Material provided during lectures.

Content

DATABASE THEORY

What is a database
Operational Data
Data independence
Relational system and others


THREE LEVELS OF THE ARCHITECTURE

External level
Conceptual level
Internal level


ER-MODEL (Entity Relationship)

DATA DEFINITION LANGUAGE (SQL)

Base tables
Indexes
Data types
Keys
Referential Integrity
Normalization
Functional dependencies
First, Second, Third Normal form

SQL language
CREATE code
DROP (delete)
ALTER (change)

SQL queries

SELECT
JOIN
WHERE
Functions
Aggregate functions
UNION

Assessment

Grades 0-5

20% assignments, 80% exam