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

2018/9, 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:
Assessment (formative or summative)
The final class test assesses all LOs. 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:
The University is currently undertaking work to improve the quality of information provided on methods of assessment and feedback. Please refer to the section on Learning and Teaching Approaches above for further information about this module’s learning, teaching and assessment practices, including formative and summative approaches.

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 20 1,2 6 HOURS= 5, WORDS= 0
Practical Skills Assessment 30 1,2 10 HOURS= 15, WORDS= 0
Class Test 50 1,2,3 13 HOURS= 1, WORDS= 0
Component 1 subtotal: 50
Component 2 subtotal: 50
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:

Recommended - ELMASRI & NAVATHE (2006) FUNDAMENTAL OF DATABASE SYSTEMS: ADDISON-WESLEY, 2006th ed.
Recommended - NILESH SHAH (2004) DATABASE SYSTEMS USING ORACLE: PRENTICE HALL, 2004th ed.
Recommended - KORTH AND SILBERSHATZ (2005) DATABASE SYSTEMS CONCEPTS: MCGRAW-HILL HIGHER ED, 2005th ed.
Click here to view the LibrarySearch.