SoleOPS 3.13.0, ©2005-2018Solenovo Oy

Opintojakson toteutussuunnitelma

 Palaa
GroupT402D13S/Degree Programme in Business Information Technology (Tornio)
Study unitT402D32 Databases, 5.00 ECTS credits, 133 h
PROFESSIONAL STUDIES
ImplementationPerustoteutus/14001
UnitMinerva (Kauppakatu 58) Tornio
Time of implementationAutumn1/2014-2015, Autumn2/2014-2015
Responsible teacherVuokila Johanna
Other teachers
Status of implementationFinished

Description status Ready
  
Language of instruction English
Starting and ending dates02.09.2014 - 31.12.2014
Minimum number of participants  
Maximum number of participants  
Enrolment period01.09.2014 - 14.09.2014
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, exercisesand self studying 133h

Material

Moodle environment with lessons and exercises

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

DBA

DBMS

ER-MODEL (Entity Relationship)

INTERACTIVE SQL

DATA DEFINITION LANGUAGE (DDL, SQL)

  • Base tables
  • Indexes
  • Data types
  • Keys
  • Referential Integrity, Mto1, 1to1, MtoM relations
  • Normalization
  • Functional dependencies
  • First, Second, Third Normal form
  • Boyce/Codds NF
  • SQL language
    • CREATE code
    • DROP (delete)
    • ALTER (change)

DATA MANIPULATION LANGUAGE (DML, SQL)

  • Triggers
  • Procedures
  • Views
  • Query analyzer
  • SQL queries
  • SELECT
  • JOIN
  • WHERE
  • Functions
  • Aggregate functions
  • UNION

Assessment

Grades 1-5

20% assignments, 80% exam

 Palaa