COURSE SYLLABUS

Database Systems I 7.5 credits

Databaser I
First cycle, D0004N
Version
Course syllabus valid: Autumn 2019 Sp 1 - Present
The version indicates the term and period for which this course syllabus is valid. The most recent version of the course syllabus is shown first.

Syllabus established
by 28 Feb 2007

Last revised
by Jonny Johansson, HUL SRT 15 Feb 2019

Education level
First cycle
Grade scale
U G VG *
Subject
Systems Science
Subject group (SCB)
Informatics/Computer and Systems Sciences
Main field of study
Social Informatics, Information Systems Sciences

Entry requirements

In order to meet the general entry requirements for first cycle studies you must have successfully completed upper secondary education and documented skills in English language


More information about English language requirements


Selection

The selection is based on final school grades or Swedish Scholastic Aptitude Test.



Course Aim

After the course the student will be able to

  • create relational databases using data modelling
  • present and argue upon the model 
  • implement databases,
  • access the database using basic SQL

Contents
  • Data base theory
  • Data modelling
  • Relational databases
  • Basic SQL
  • How to access the database

Realization
The work of the student is problem based and surveying. Teaching takes the form of lessons, seminars, project works and individual tasks. A learning management system is used for delivering course material, information and submissions. Knowledge is shared and created within the course through virtual meetings with teachers and other students for discussions, supervision, teamwork and seminars. For student on campus there will be meetings on campus.

Examination

Individual assignments, presentation of the project work and written examination.

All students, both on distance and campus, write the individual exam online, webcam and microphone are required.



Remarks
Technical Requirements: Access to a PC with Windows XP, microphone, Web cam and permission to install software. Internet connection (minimum 0,5Mbps).

Transition terms
This course cannot be combined with IED006, IED007, IED008, IED009, IED300, IED403 or D0001N in any degree.

Examiner
Ingemar Andersson

Transition terms
The course D0004N is equal to IED403

Literature. Valid from Autumn 2018 Sp 1 (May change until 10 weeks before course start)
Database Systems, Thomas Connolly, Carolyn Begg, 4th to latest edition.

Course offered by
Department of Computer Science, Electrical and Space Engineering

Modules
CodeDescriptionGrade scaleHPStatusFrom periodTitle
0003Compulsory assignmentsU G#3.00MandatoryA18
0004ExaminationU G VG *4.50MandatoryA18

Study guidance
Study guidance for the course is to be found in our learning platform Canvas before the course starts. Students applying for single subject courses get more information in the Welcome letter. You will find the learning platform via My LTU.