***DEGREE APPRENTICESHIP STUDENTS ONLY***

This module provides you with an introduction to the core concepts in data and information management. It is centred on the core skills of identifying organisational information requirements, modelling using conceptual data modelling techniques and converting the conceptual data models into relational data models, and then implementing and utilising a relational database using an industry standard database management system.

The module will also include coverage of basic database administration tasks and key concepts of data quality and data security. In addition to developing database applications, you will learn how large-scale packaged systems are highly dependent on the use of database management systems.

The aim of this module is to ensure that you have a good understanding of data, information and systems used to manage data and information. In particular, you should be able to demonstrate the following competences:

• Identify organisational information requirements and can model data solutions using conceptual data modelling techniques.
• Be able to implement a database solution using an industry standard database management system (DBMS).
• Be able to perform database administration tasks and be cognisant of the key concepts of data quality and data security.
• Be able to manage data effectively and undertake data analysis.

On successful completion of this module you should be able to:

Module Specific Skills and Knowledge

Discipline Specific Skills and Knowledge

Personal and Key Transferable / Employment Skills and Knowledge

Introduction to data and information management (3 weeks)

•          File organisation and data structures

•          Structured and unstructured data

           o          HTML, CSV, XML, JSON

•          Data quality; audit and compliance

•          Databases and database management systems

           o          Historical development

           o          Role of DBMS in managing organisation data and enterprise systems

           o          Conceptual, logical and physical data models

           o          Relational and NoSQL databases; big data

•          Data integration

•          Data warehousing; data mining; business intelligence; data analytics

•          Evaluating potential data solutions to meet requirements

•          Introduction to data security principles

•          Identifying data security risks and violations in data management system design

Conceptual data modelling (3 weeks)

•          Capturing information requirements for an enterprise domain

•          Entity-relationship diagrams

•          Object modelling with UML class diagrams

•          Data normalisation

Database design and implementation (2 weeks)

•          Logical and physical data models

•          Translating object and data models into database schemas

•          Database implementation using Oracle or SQL Server

•          Cloud data storage

•          Indexing and performance

SQL (3 weeks)

•          Data definition language

•          Data manipulation language

•          Database transactions

•          Accessing databases from application development environments

•          Simple database administration

           o          Data control language

Deferral – if you miss an assessment for certificated reasons judged acceptable by the Mitigation Committee, you will normally be deferred in the assessment. The mark given for a re-assessment taken as a result of deferral will not be capped and will be treated as it would be if it were your first attempt at the assessment.

Referral – if you have failed the module overall (i.e. a final overall module mark of less than 40%) you may be required to sit a referral. The mark given for a re-assessment taken as a result of referral will be capped at 40%.

ELE: http://vle.exeter.ac.uk/

Reading list for this module: