DATABASE DEVELOPMENT

SHE Level 2
SCQF Credit Points 20.00
ECTS Credit Points 10.00
Module Code M2I325091
Module Leader Martin Gallacher
School School of Computing, Engineering and Built Environment
Subject Computing
Trimesters
  • B (January start)
  • A (September 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. The percentage of Work Based Learning for this module, as represented by the proportion of the Activity Types which take place off campus, is 79%. The percentage of Work Based Assessment for this module is 10%.

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

Work based Education aims to maximise the direct and digitally mediated contact time with students by practicing teaching and learning strategies that use authentic work based scenarios and encourage action learning, enquiry based learning, problem based learning and peer learning. All these approaches aim to directly involve the students in the process of learning and to encourage sharing of learning between students. The module team will determine the level and accuracy of knowledge acquisition at key points in the delivery, inputting when necessary either directly or with the support of external experts who will add to the authenticity, the credibility and application of the education and learning in the workplace. The course material is introduced through lectures in the form of online presentations, which as well as covering the principles of database development will illustrate the relevance of the techniques presented to real-world applications and introduce a range of professional development processes and practices. Students will engage with practical database activities and online tutorial material which may include instructor and peer-created content, and there will be seminars on campus which will allow students to discuss key concepts and issues with peers and with instructors. Students will be expected to undertake a significant level of independent study within the workplace, including practical activities, and links will be provided to appropriate external material such as podcasts, MOOCs, videos and literature to supplement the module content. Students will also be encouraged to reflect upon the theoretical learning within the work place and the application of newly learned concepts to the work environment, and this will form part of the module assessment. Students will receive feedback on their performance throughout the module through undertaking the practical assignments and tutorial exercises and participating in the seminars

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

Specialist knowledge and application Critical thinking and problem solving Critical analysis Communication skills, written, oral and listening Numeracy Computer literacy Self confidence, self discipline & self reliance (independent working) Ability to prioritise tasks and time management Develop an understanding of the practical considerations that constrain the application of theory in the workplace.

Module Structure

Activity Total Hours
Seminars (FT) 24.00
Independent Learning (FT) 110.00
Practicals (FT) 24.00
Lectures (FT) 24.00
Assessment (FT) 18.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