Data Storage and Retrieval COMPSCI2029

  • Academic Session: 2024-25
  • School: School of Computing Science
  • Credits: 10
  • Level: Level 2 (SCQF level 8)
  • Typically Offered: Semester 1
  • Available to Visiting Students: No
  • Collaborative Online International Learning: No

Short Description

This course is intended for Graduate Apprenticeship students only.

 

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

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.