Study information

Data Systems - 2024 entry

MODULE TITLEData Systems CREDIT VALUE15
MODULE CODECOMM108 MODULE CONVENERUnknown
DURATION: TERM 1 2 3
DURATION: WEEKS 11
Number of Students Taking Module (anticipated)
DESCRIPTION - summary of the module content

This module will introduce you to the ways in which data is stored within a computer system. You will learn about a variety of types of database, including those based on the structured query language (SQL) and those designed to structure data differently (so-called NoSQL databases). You will develop a theoretical understanding about how data should be organised, and will learn how to access and modify the data in a database from an application .

AIMS - intentions of the module

The aim of this module is to instil students with an appreciation of the different ways that data can be stored. By introducing multiple approaches (e.g. SQL-based and NoSQL) students will learn how to select the most appropriate storage for a given application, taking into account the complexities around accessing and writing data. Students will also learn how to construct software to connect an application to a database securely.

The module will also cover concurrency control, backup and recovery, user management, and web development with databases, The module will also introduce modern concepts concerning data systems, which might include big data, the cloud, data warehousing, blockchain, and decentralised systems, and governance.

INTENDED LEARNING OUTCOMES (ILOs) (see assessment section below for how ILOs will be assessed)

On successful completion of this module you should be able to:

Module Specific Skills and Knowledge

1. Understand how to construct a database in which to store data for a given application.
2. Understand how to design applications that uses an API to access and modify data stored in a database

Discipline Specific Skills and Knowledge

3. Document and defend the design of a database for a given application.
4. Contrast between different types of database tools.

Personal and Key Transferable / Employment Skills and Knowledge

5. Design an appropriate data storage scheme for a project within a chosen problem domain..

 

SYLLABUS PLAN - summary of the structure and academic content of the module
  • The relational model and its implementation in SQL.
  • Information modelling.
  • Database design theory.
  • Transactions and their use in integrity and recovery management.
  • NoSQL databases (potential examples including document databases and graph databases).
  • database APIs and their construction.
LEARNING AND TEACHING
LEARNING ACTIVITIES AND TEACHING METHODS (given in hours of study time)
Scheduled Learning & Teaching Activities 42 Guided Independent Study 108 Placement / Study Abroad 0
DETAILS OF LEARNING ACTIVITIES AND TEACHING METHODS
Category Hours of study time Description
Scheduled learning and teaching activities 22 Lectures
Scheduled learning and teaching activities 20 Workshops/tutorials
Guided independent study 70 Individual assessed work
Guided independent study 38 Lecture and assessment preparation

 

ASSESSMENT
FORMATIVE ASSESSMENT - for feedback and development purposes; does not count towards module grade
Form of Assessment Size of Assessment (e.g. duration/length) ILOs Assessed Feedback Method
Workshop exercises 2 hours per week 1-5 Model answers and verbal feedback

 

SUMMATIVE ASSESSMENT (% of credit)
Coursework 60 Written Exams 40 Practical Exams 0
DETAILS OF SUMMATIVE ASSESSMENT
Form of Assessment % of Credit Size of Assessment (e.g. duration/length) ILOs Assessed Feedback Method
Exam 80 1 hours 1-5 Written
Continuous assessment 20 48 hours 1-5 Written
         
         
         

 

DETAILS OF RE-ASSESSMENT (where required by referral or deferral)
Original Form of Assessment Form of Re-assessment ILOs Re-assessed Time Scale for Re-assessment
Continous assessment  Coursework 1-5 Completed over the Summer with a deadline in Auguts
Exam Exam 1-5 Referral/deferral period
       

 

RE-ASSESSMENT NOTES

Reassessment will be by coursework in the failed or deferred element only.

Deferral – if you have been deferred for any assessment you will be expected to submit the relevant assessment. The mark given for a re-assessment taken as a result of deferral will not be capped and will be treated as it would be if it were your first attempt at the assessment.

Referral – if you have failed the module overall (i.e. a final overall module mark of less than 50%) you will be expected to submit the relevant assessment. The mark given for a re-assessment taken as a result of referral will be capped at 50%.

RESOURCES
INDICATIVE LEARNING RESOURCES - The following list is offered as an indication of the type & level of
information that you are expected to consult. Further guidance will be provided by the Module Convener

Basic reading:

  • Connolly, Thomas and Begg, Carolyn, “Database Systems: A Practical Approach to Design, Implementation and Management”, Pearson, 2015. ISBN: 1292061189.

Reading list for this module:

There are currently no reading list entries found for this module.

CREDIT VALUE 15 ECTS VALUE 7.5
PRE-REQUISITE MODULES None
CO-REQUISITE MODULES None
NQF LEVEL (FHEQ) 7 AVAILABLE AS DISTANCE LEARNING No
ORIGIN DATE Wednesday 20th December 2023 LAST REVISION DATE Thursday 16th May 2024
KEY WORDS SEARCH Database; design; modelling

Please note that all modules are subject to change, please get in touch if you have any questions about this module.