Please note: there may be some adjustments to the teaching arrangements published in the course catalogue for 2020-21. Given current circumstances related to the Covid-19 pandemic it is anticipated that some usual arrangements for teaching on campus will be modified to ensure the safety and wellbeing of students and staff on campus; further adjustments may also be necessary, or beneficial, during the course of the academic year as national requirements relating to management of the pandemic are revised.

Data Storage and Retrieval COMPSCI2029

  • Academic Session: 2020-21
  • School: School of Computing Science
  • Credits: 10
  • Level: Level 2 (SCQF level 8)
  • Typically Offered: Semester 1
  • Available to Visiting Students: No
  • Available to Erasmus Students: No

Short Description

At some point, students are likely to encounter databases. The purpose of this course is to prepare them for that eventuality and teach them the basics of database formulation and interaction. It will also introduce the idea that whatever database they may encounter will not be the only kind available, and many types of data stores exist for different purposes.

Timetable

None

Requirements of Entry

Entry to Level 2 is guaranteed to students who achieve a GPA of D3 or better in their level 1 courses at the first sitting.

Excluded Courses

None

Co-requisites

Computer Architecture and Network Systems

User Interaction

Assessment

Written examination 60%, mid semester class tests 10%, in-class quizzes 5% and course work 25%

Main Assessment In: December

Course Aims

The aim of this course is to introduce students to common database practices and interaction techniques, but also to expand their perception of databases beyond the relational model, and introduce different types of data stores and methods of persistence.

Intended Learning Outcomes of Course

By the end of this course, students will be able to: 

1. Describe the options for the persistence of data in a software program. 

2. Explain how databases contribute to the management of large amounts of data. 

3. Design, create and develop a relational database. 

4. Describe how programming languages interact with data stores.

Minimum Requirement for Award of Credits

Students must submit at least 75% by weight of the components (including examinations) of the course's summative assessment.