DATABASE DEVELOPMENT

SHE Level 2
SCQF Credit Points 20.00
ECTS Credit Points 10.00
Module Code M2I324174
Module Leader Richard Holden
School School of Computing, Engineering and Built Environment
Subject Computing
Trimesters
  • B (January start)
  • A (September start)
  • C (May start)

Summary of Content

This module will provide students with an understanding of the techniques used in the design and implementation of modern Relational Database Systems. It will cover the principles of Relational Data Modelling, data definition and querying using SQL, database applications using forms, reports and stored procedures. The module will also expose students to non-relational database technologies such as NoSQL and object oriented databases.

Syllabus

Database Design -360 - The Entity Relationship Model -360 - Entities and Attributes - Relationships, Degree of a Relationship, Cardinalities in Relationships Modelling - Multi-valued Attributes - Modelling Time-Dependent Data - Business Rules. Logical Design and the Relational Model -360 - Logical Database Design -360 - The Relational Data Model - Tables, Candidate Keys, Primary Keys, Foreign Keys - Concepts of Normalisation - The Basic Normal Forms - Transforming ER Diagrams to Relations - Merging Relations Physical Design -360 - Data types and constraints -360 - Sequences and identity columns - Indexing Structured Query Language -360 - Relational Data Definition in SQL -360 - Data Retrieval and Manipulation in SQL - Multiple Table Operations in SQL - Data Maintenance in SQL Developing applications that use a database -360 - Design and production of queries, forms and reports for a specified application -360 - Stored Procedures Non-relational database technologies -360 - Object oriented databases -360 - NoSQL databases

Learning Outcomes

On successful completion of this module, students should be able to:1. Apply the process of Relational Data Modelling2. Use SQL to define database tables and queries3. Develop applications that use queries, forms, reports and stored procedures to manipulate information held in a database4. Understand the principles of non-relational database technologies

Teaching / Learning Strategy

The University 'Strategy for Learning' documentation has informed the learning and teaching strategy for this module. The module material will be introduced through lectures, while practical exercises, based on the lecture material, will be given to students for their laboratory sessions. Tutorials will be used to help explain and elaborate on both the lecture material and the laboratory exercises. Full use will be made of GCU Learn to provide Lecture-based and related study materials, along with sample solutions of Tutorial and Laboratory exercises, thus encouraging the development of independent learning and allowing self-reflective feedback on student performance. Staff-based feedback on student performance for submitted work will be provided in line with the University feedback policy, with summative feedback and grades on the coursework assessment utilising GCU Learn. The additional interactive discussion features of GCU Learn will be utilised, as appropriate to the module, to stimulate independent and flexible student learning outwith scheduled class time.

Indicative Reading

Ritchie, C (2008) Database Principles and Design, 3 rd Edition, Thomson Learning, ISBN: 978-1844805402 Connolly, T and Begg, C (2014) Database Systems: A Practical Approach to Design, Implementation and Management, 6th Edition, Addison Wesley, ISBN: 978-0132943260 Redmond, E (2012) Seven Databases in Seven Weeks: A Guide to Modern Databases and the NoSQL Movement, Pragmatic Bookshelf, ISBN: 978-1934356920 Paterson, J et al. (2006) The Definitive Guide To db4o, Apress Academic, ISBN: 978-1590596562

Transferrable Skills

D1 Specialist knowledge and application D2 Critical thinking and problem solving D3 Critical analysis D4 Communication skills, written, oral and listening D5 Numeracy D7 Computer literacy D8 Self confidence, self discipline & self reliance (independent working) D15 Ability to prioritise tasks and time management

Module Structure

Activity Total Hours
Tutorials (FT) 12.00
Lectures (FT) 24.00
Practicals (FT) 24.00
Assessment (FT) 18.00
Independent Learning (FT) 122.00

Assessment Methods

Component Duration Weighting Threshold Description
Course Work 01 n/a 50.00 35% Practical Lab Based Assignment
Course Work 02 n/a 50.00 35% Written Report (2000 words)