News

SSST Subjects

Database Systems

Computer Science

|

Information Systems

 
 

Programme(s) where module is offered

  • BSc Computer Science with Electrical Engineering
  • BSc Computer Science with Economics
  • BSc Computer Science with Management
  • BSc Computer Science with International Relations
  • BSc Computer Science with Political Science
  • BSc Information Systems with Electrical Engineering
  • BSc Information Systems with Economics
  • BSc Information Systems with Management
  • BSc Information Systems with International Relations
  • BSc Information Systems with Political Science;
 

Status (core, option, free choice)

Core

 

FHEQ Level

4

 

Unit Value

8 ECTS

 

Semester taught

Fall

 

Pre-Requisite Modules or Qualifications

None

 

Module Code

CSIS240

 

Modul Coordinator

Amer Hadžikadić

 

Applicable From

2016

 

Educational Aims of the Module

  • The aim of this module is to introduce students to the fundamental concepts and principles of databases, particularly relational databases.
  • It leads students through the process and techniques of database modelling, design, implementation and management. It also provides students with hands-on practice and skills in developing a database system using a commercial DBMS software, specifically Oracle. 
  • This module also serves as a good foundation for the data warehousing and data miningmodule that follow.
 

Module Outline/Syllabus

  • Introductory knowledge of the underlying concepts associated with databases: data, file and database concepts; database management system (DBMS); types of databases; database life-cycle
  • Relational database: tables; keys; relationships; basic relational algebra
  • Data modelling: basic data abstraction; introductoryconceptual data models; entity; attribute; relationship; entityrelationship (E-R) modelling technique; E-R diagram
  • Database design: basic design problems; first, second and third normal forms; normalisation process
  • Database implementation: introduction to structured query language (SQL), data definition and manipulation commands; queries and reports
  • Database management: policies and strategies
  • Basic database trends: object-orientated databases, data warehouses, web databases, distributed databases.
 

Student Engagement Hours

Type Number per Term Duration Total Time
Lectures 30 2 hours 60 hours
Tutorials 15 2 hours 30 hours
Total Guided/Independent Learning Hours 110
Total Contact Hours 90
Total Engagement Hours 200
 

Assessment Method Summary

Type Number Required Duration / Length Weighting Timing / Submission Deadline
Final exam 1 180 minutes 50% End of semester
Mid-term exam 1 90 minutes 15% Week 10
Project (group) 1 2,500 words 15% Week 15
Test 2 90 minutes 20% Weeks 4 and 13
 

Module Outcomes

Teaching and Learning Strategy:

  • Lectures provide core information on specific topics 
  • Laboratory sessions use examples and solutions to illustrate the theory
  • Laboratory sessions provide a series of development exercises to apply thetheory 
  • Independent study is based on the recommended text
  • Group project enables students to develop communication skills and apply what they have learnt in the module to a practical problem 
  • Laboratory sessions 
  • Project 
  • Laboratorysessions with hands-on experience with Oracle 
  • Projects 

Assessment Strategy

  • Test 
  • Mid-term exam 
  • Final exam 
  • Project (group) 
 

Key Texts and/or other learning materials

Set text

  •  Morris, S., Coronel, C., (2014), Database Systems: Design, Implementation and Management, 11th Edition, Course technology Inc.

Supplementary Materials

  • Connolly, T., Begg, C., (2014), Database Systems: A Practical Approach to Design, Implementation and Management, Global Edition, Pearson Education
  • Garcia-Molina, H., et al., (2013), Database Systems: The Complete Book, Pearson
  • Further material to be advise

Please note

This specification provides a concise summary of the main features of the module and the learning outcomes that a typical studentmight reasonably be expected to achieve and demonstrate if he/she takes full advantage of the learning opportunities that are provided.  More detailed information on the learning outcomes, content and teaching, learning and assessment methods of each module and programme can be found in the departmental or programme handbook.  The accuracy of the information contained in this document is reviewed annually by the University of Buckingham and may be checked by the Quality Assurance Agency.

Date of Production : Autumn 2016

Date approved by School Learning and Teaching Committee: 28th September 2016

Date approved by School Board of Study : 12th October 2016

Date approved by University Learning and Teaching Committee: 2nd November 2016

Date of Annual Review: December 2017

       
Ptica

Visit us

Hrasnička cesta 3a, Sarajevo, 71 000

Bosnia and Herzegovina

Entrance Exams are held at SSST, from April to September, starting at 9:00 a.m.

Contact us

Tel: +387 33 975 002

Fax: +387 33 975 030

administration@ssst.edu.ba

admissions@ssst.edu.ba

Download brochure

Get the manual for freshman and prepare
for SSST Entrance Exam.

Download Download here

SSST © 2024 All rights reserved