Module title: Database Systems

SCQF level: 11:
SCQF credit value: 10.00
ECTS credit value: 5

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

N/A

2019/0, Trimester 1, FACE-TO-FACE, Edinburgh Napier University
Occurrence: 001
Primary mode of delivery: FACE-TO-FACE
Location of delivery: MERCHISTON
Partner: Edinburgh Napier University
Member of staff responsible for delivering module: Peter Barclay
Module Organiser:


Learning, Teaching and Assessment (LTA) Approach:
The main topics in the module will be described in lectures supplemented by extensive online notes. During practical laboratory
sessions, students will develop their familiarity and skills with current database technology and tools. Together, the presentation
material, online notes and practical work cover all learning outcomes.



Formative Assessment:
Formative assessment is provided in the form of automated feedback on SQL problems, and during face-to-face interactions in practical sessions. Students are also encouraged to raise questions during lecture sessions and can thus guide the development of the discussion.


Summative Assessment:
Practical coursework with two elements, including design, theory, and implementation tasks. Feedback on the first element will inform the second element. The first element covers LO1 and LO2 and the second element covers LO1, LO2 and LO3.

Student Activity (Notional Equivalent Study Hours (NESH))
Mode of activityLearning & Teaching ActivityNESH (Study Hours)
Face To Face Lecture 12
Face To Face Practical classes and workshops 12
Independent Learning Guided independent study 75
Face To Face Tutorial 1
Total Study Hours100
Expected Total Study Hours for Module100


Assessment
Type of Assessment Weighting % LOs covered Week due Length in Hours/Words
Practical Skills Assessment 40 1,2 7 HOURS= 5, WORDS= 0
Practical Skills Assessment 60 1,2, 3 13 HOURS= 18, WORDS= 0
Component 1 subtotal: 100
Component 2 subtotal: 0
Module subtotal: 100

Description of module content:

Database architecture and functionality
Data analysis and entity-relationship modelling
Normalisation (to third normal form)
SQL – theory and practical skills
The role of a Database Administrator (DBA)
Practical exposure to current software tools
Current trends in database technology

Learning Outcomes for module:

Upon completion of this module you will be able to

LO1: Analyse and implement a relational database schema

LO2: Apply current techniques, languages and tools for database development

LO3: Critically appraise the role of a database and the functions which should be provided by a database management system and the database administrator

Indicative References and Reading List - URL:
Contact your module leader