The course is included in these curricula and study modules

Level/category

Professional studies

Teaching language

Swedish

Type of course

Compulsory

Cycle/level of course

First

Recommended year of study

2

Total number of ECTS

5 cr

Competency aims

This subject will give the students the expertise needed to model, design, implement and manage a relational database. The student will also establish a general understanding of the theory behind relational databases. The course will give students fundamental knowledge of SQL language and multi-user database management systems. Students are also introduced to real database development environment in PC-lab.

Learning outcomes

In this course the student will learn: - the basic theory behind relational databases - how to write correct and executable SQL code, the main language for querying relational databases - and also have some basic understanding of query optimization - how to analyze, design and implement a simple relational database in a real client-server environment - the benefits of a design methodology

Course contents

Database theory: - definitions, concepts and terminology - relational database model, relational algebra - data base management systems and query language - data integrity Working with databases in a client-server environment using SQL: - select queries, data manipulation (DML) - creation of tables and other database objects (DDL)

Prerequisites and co-requisites

None

Previous course names

2004-2005 Databases and SQL

Additional information

None

Recommended or required reading

Study material Thomas Connolly etc.: Database Systems, Fifth Edition (2010) Connolly, Begg, Holowczak: Business Database Systems (2008)

Study activities

  • Lectures - 20 hours
  • Individual- and group instruction - 32 hours
  • Small-group work - 10 hours
  • Project- and production work/artistic activities - 41 hours
  • Individual studies - 30 hours

Workload

  • Total workload of the course: 133 hours
  • Of which autonomous studies: 133 hours
  • Of which scheduled studies: 0 hours

Mode of Delivery

Participation in tuition

Assessment methods

  • Exams (written-, oral-, home-)

Assessment requirements

1. SQL exercise (individual home exam) 2. Database project divided in three parts. A team can have max 2 members.

Teacher

Forss Thomas

Examiner

Forss Thomas

Home page of the course

https://arcada.itslearning.com/

Group size

No limit

Assignments valid until

12 months after course has ended

The timetable of the course

Hösten 2013

Assessment methods

  • Date of examination will be announced later - Exams
  • Date will be announced later - Other assignments

Course and curricula search