Skip to content


COURSE SYLLABUS

Database Systems II 7.5 credits

Databaser II
First cycle, D0005N
Version
Course syllabus valid: Spring 2022 Sp 3 - 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.


Education level
First cycle
Grade scale
U G VG *
Subject
Systems Science
Subject group (SCB)
Informatics/Computer and Systems Sciences
Main field of study
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 and Basic knowlege of programming, SQL and relational databases.


More information about English language requirements


Selection

The selection is based on 1-165 credits.



Course Aim

This course will provide you with an overview of a selected set of the advanced topics in database systems. The goal is to expose you to the current active areas in databases of interest to both academia and industry.

After this course the student will be able to:

    • Describe the basic concepts of relational database design;
    • Explain Database implementation and tools;
    • Describe the design of parallel and distributed databases;
    • Analyze case scenarios, design and implement databases;
    • Describe the basic concept of data warehousing and data mining;
    • Gain knowledge in basic ETL, OLAP, and data marts design and queries.

      Contents

      This is an advanced database course; we assume knowledge of the fundamental concepts of relational databases. The course will cover a number of advanced data management topics, including issues in relational database management systems, and data-centric applications. The specific topics include optimization strategies for relational database systems, parallel and distributed database systems, data warehousing, and business intelligence. The course materials will be drawn from textbooks as well as recent research literature.


      Realization
      Each course occasion´s language and form is stated and appear on the course page on Luleå University of Technology's website.
      In the course, lectures are interspersed with practical applications in the form of assignments. The lessons will make it easier for the student to understand structures, contexts, methods and models for the development of database models and implementation in database managers. In addition to database knowledge, the assignments also train cooperation, written presentation, the ability to search, collect, evaluate and critically interpret relevant information, as well as the ability to identify, formulate and solve problems.

      The teaching is completely web-based with the possibility of physical gatherings. Between the meetings, the students who read the course at a distance communicate with classmates and teachers via e-mail and a web-based learning platform. Students who read the course on campus in Luleå have regular meetings with other students and teachers during lectures, supervision and group work.

      Examination
      If there is a decision on special educational support, in accordance with the Guideline Student's rights and obligations at Luleå University of Technology, an adapted or alternative form of examination can be provided.
      Written assignments (2.5hp UG) examine the objectives Analyze scenarios, design and implement databases, describe the design of parallel and distributed databases, describe data warehousing and data mining, apply basic knowledge of ETL, OLAP and "data march", design and "queries" . In addition to this subject-specific knowledge, understanding of orientation on current research issues, written presentation, the ability to search, collect, evaluate and critically interpret relevant information, and the ability to identify, formulate and solve problems are also examined.

      Written examination (5 credits, U G VG) examines all course-specific learning objectives, but not the general skills. All, both distance and campus students, write the individual exam online at a specific time (exam occasion). Webcam and microphone are a requirement.

      All included examination parts must be completed for the final grade on the course.

      Remarks
      Technical Requirements: Access to a computer, microphone, web cam and permission to install software. Internet connection (minimum 0,5 Mbps).

      Transition terms
      This course cannot be combined with IED303, IED409, IED445 or A7008N in any degree.

      Examiner
      Jörgen Nilsson

      Transition terms
      The course D0005N is equal to IED409

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

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

      Modules
      CodeDescriptionGrade scaleCrStatusFrom periodTitle
      0003AssignmentU G#2.50MandatoryS16
      0004Written examU G VG *5.00MandatoryS22

      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.

      Syllabus established
      by 28 Feb 2007

      Last revised
      by Jonny Johansson, HUL SRT 16 Jun 2021