Module title: Database Systems

SCQF level: 11:
SCQF credit value: 20.00
ECTS credit value: 10

Module code: SET11801
Module leader: Peter Barclay
School School of Computing
Subject area group: Software Engineering
Prerequisites

N/A

2018/9, Trimester 3, ONLINE,
Occurrence: 001
Primary mode of delivery: ONLINE
Location of delivery: WORLDWIDE
Partner:
Member of staff responsible for delivering module: Peter Barclay
Module Organiser:


Learning, Teaching and Assessment (LTA) Approach:
You will be supported by the Global Online team who will provide general overall support, and by the module teams who will provide module-specific online material and discussion forums using a variety of communication technologies such as Moodle and Skype (LO 1-4). You will be encouraged to develop your learning through peer and tutor interaction through electronic communication.
Self-study readings, supported by online discussions forum hosted through the VLE, will develop skills as independent learners (LO 1-4). Formative feedback will be provided via online quizzes (LO 1-4). The material for the lab-based practical sessions will be made available online with a support forum.
In addition to this, online students are provided with online support in the form of:
• Dedicated online administrators who will keep track of student progress and will help you if you are having any problems.
• A dedicated interactive database of frequently asked questions specific to the online learning environment.
• A regular ‘virtual office hour’ will be held where module staff will be available for contact with you.




Formative Assessment:
There will be a series of end-of-section online quizzes that will provide formative assessment throughout the course. Formative feedback on practical work will also be provided through the online discussion forum and ‘virtual office hour’. Reflective Exercises will enable you to apply theory to practice – this is not assessed, but it will support your personal and professional development. Formative assessment is also provided in the form of automated feedback on SQL problems.

Summative Assessment:
Summative assessment will be in the form of a single component, which will consist of an ongoing database development task and associated written documentation worth 100% of the final mark (covering LOs 1 - 4). This component will be broken down into two elements, due week 7 and 13. The first element will be submitted in week 7 in order to give interim summative feedback (35%: L.Os 1, 2). The second element will be submitted in week 13 (65%: LOs 1 - 4), after which final summative assessment will be given.

Student Activity (Notional Equivalent Study Hours (NESH))
Mode of activityLearning & Teaching ActivityNESH (Study Hours)
Online Lecture 12
Online Practical classes and workshops 24
Independent Learning Guided independent study 164
Total Study Hours200
Expected Total Study Hours for Module200


Assessment
Type of Assessment Weighting % LOs covered Week due Length in Hours/Words
Practical Skills Assessment 35 1,2 7 HOURS= 12
Practical Skills Assessment 65 1,2,3,4 13 HOURS= 28
Component 1 subtotal: 100
Component 2 subtotal: 0
Module subtotal: 100

Description of module content:

This module covers core database techniques including relational including relational and NoSQL databases. The module will build on the School of Computing’s expertise in online database delivery (such as the SQA recommended SQL Zoo) to ensure the students understand how to store and retrieve data using several different tools. Database architectures, functionality, and entity-relationship modelling will be covered. The role of a Database Administration in the context of data science will be analysed. Finally, current trends in database technology will be explored. Topics include:
• Database theory.
• Database design.
• Database architecture and functionality.
• Date analysis and entity-relationship modelling.
• Normalisation for database design.
• SQL and relational algebra.
• NoSQL databases.
• Role of the database administrator.
• Current trends in database technology.
• Database security.

Learning Outcomes for module:

LO1: Critically analyse and evaluate database modelling and development approaches

LO2: Design, implement, and query a data model using a contemporary database management system

LO3: Critically compare and assess methods/technologies for managing large data sets

LO4: Critically review emerging database languages and technologies

Indicative References and Reading List - URL:

Please contact your Module Leader for details
Click here to view the LibrarySearch.