PE7044 - Data Modelling and Analytics

What will I learn on this module?

This module is design to develop your understanding of the conceptual basis for current database technology of which you will subsequently be able to apply such knowledge in implementing database applications.

Specifically you will be able to understand how to analyse, model, design, develop and manipulate databases. Furthermore, you will appreciate limitations of existing data models and the need for database programming to achieve complete solutions, write transactions and procedures for data manipulation, specify security for operations, and apply business rules.

You will also gain knowledge of alternative data models, their rationale, advantages and disadvantages, construct alternative data representations for contemporary data processing application. Moreover, you will get an appreciation of non-traditional data types, systems and applications (e.g., NoSQL Databases). You will learn how to use data for business reporting, exploratory data analysis and advanced data analytics. In addition, you will realise the responsibilities of database designers with respect to professional, legal, security and ethical issues.

How will I learn on this module?

Each module session follows a similar structure of Learn, Explore Further and Apply. All learning materials and resources are accessible via our virtual learning environment. Indeed, through the e-learning portal you will be provided with resources in the form of scanned articles, links of books/articles/journals, PowerPoint lectures, word document, video lectures etc. relevant to your module. You will be given a reading list, but will also be required to create your individual reading resource as well. You will be using a discussion board to share your work and create a knowledge base for your peers. You will be also using Wiki (a learning tool on e-learning portal) to form focus groups on module submission and assessment criteria.

Learning will occur using a range of approaches. Recorded lectures will be available each week. These recorded lectures will provide key concepts and ideas. You will then engage in on-line hands-on lab sessions whereby you will develop key skills in data analysis, design and implementation using a range of contemporary systems and a range of useful tools and methods.

You will access virtual lab classrooms (available on the e-learning portal) for live discussions and virtual taught sessions, which will be recorded and stored on the e-learning portal. These online sessions are timetabled and will deliver relevant knowledge, information and direction for you to fulfil the learning outcomes

You will also conduct independent study, as it forms an important element of the module. Independent learning will centre upon identification and pursuit of areas of interest, by providing deeper/broader knowledge and understanding of the subject through a range of learning activities that might include extended reading, reflection, research etc.

How will I be supported academically on this module?

A range of approaches are adopted to accelerate your learning in this module.

During the first week of this module, you will receive information about the module and Teaching & Learning Plan. The teaching and learning plan (TLP) sets out
• Learning outcomes and overall module and programme aims
• Teaching, learning and assessment strategy
• Teaching schedule
• Directed reading references (text and journals) and core texts for the module

During this module your module tutor will provide academic support including:
• Delivering on—line materials
• Providing guidance in relation to assignments
• Development of key resources, made available through the VLE
• Assessing assignments and assess or review any other agreed summative or formative outputs as appropriate

You will be supported by a team of academic experts and will have the opportunity to discuss your ideas and methods. You will engage in a rich dialogue with tutors (and fellow students) and receive feedback on on-going work giving you the opportunity to respond directly and as part of your process.

Where appropriate, students may also be directed to engage with Study Skills +, or other resources offered through the University Student Support Services such as Dyslexia Support.

The Library is open 24 hours a day and E-Learning Portal houses all your module documents including your timetable. These services can be accessed on a range of devices

The module will also have an e-reading list which directs learners to specific reading for each session. This includes direct access to repositories, journal articles and other academic sources. You will also be provided with access to a significant set academic research sources via the Northumbria University library portal.

You will also have opportunities to receive formative feedback from your tutor in response to opinions you express and issues you raise during workshop sessions and face-to-face or online tutorials. These formative feedback sessions are formally scheduled at key points throughout the module.

What will I be expected to read on this module?

All modules at Northumbria include a range of reading materials that students are expected to engage with. The reading list for this module can be found at: http://readinglists.northumbria.ac.uk
(Reading List service online guide for academic staff this containing contact details for the Reading List team – http://library.northumbria.ac.uk/readinglists)

What will I be expected to achieve?

1. Critical understanding of key data modelling concepts, application of database theory, principles for supporting contemporary data processing applications and information systems.

2. Deep knowledge of key concepts of data analytics.

Intellectual / Professional skills & abilities:

3. Critically analyse, select, apply and evaluate contemporary database tools and methods for conceptual data modelling, database design and implementation.

4. Appraise, analyse, design, develop and evaluate data analytics solutions.

Personal Values Attributes (Global / Cultural awareness, Ethics, Curiosity) (PVA):

5. Develop critical awareness of the responsibilities of database designers with respect to professional, legal, security and ethical issues.

How will I be assessed?

Formative assessment: exercises provided and carried out within on-line workshops will build up to form a basis of the summative assessment. Feedback will be given during these practical workshops and/or through discussions via email/eLP.

Summative assessment is via one written coursework assessment comprising analysis, design and implementation of a database and analytics using a range of contemporary tools and methods and will test all MLOs (max 4000 words).

You will be given detailed feedback on the assignment clearly identifying both the weaknesses and strong points of the work.

Pre-requisite(s)

None

Co-requisite(s)

None

Module abstract

This module will provide you with knowledge, understanding and skills of classical as well as new ways of modelling and manipulating data (e.g., relational / NoSQL databases). Furthermore, it equips you with practical data analytics skills and an understanding of responsibilities of a professional database designer. You will also acquire an appreciation of contemporary research literature in the field of data management and analytics.

The module is taught using weekly recorded lectures and subsequent on-line lab based practical workshops using contemporary tools, methods and approaches (e.g., eLearning Portal providing extensive supporting material and reading lists). Constructive feedback is provided to you orally as well as in writing on weekly formative assessments as well on written summative assessment.

What will I learn on this module?

This module is design to develop your understanding of the conceptual basis for current database technology of which you will subsequently be able to apply such knowledge in implementing database applications.

Specifically you will be able to understand how to analyse, model, design, develop and manipulate databases. Furthermore, you will appreciate limitations of existing data models and the need for database programming to achieve complete solutions, write transactions and procedures for data manipulation, specify security for operations, and apply business rules.

You will also gain knowledge of alternative data models, their rationale, advantages and disadvantages, construct alternative data representations for contemporary data processing application. Moreover, you will get an appreciation of non-traditional data types, systems and applications (e.g., NoSQL Databases). You will learn how to use data for business reporting, exploratory data analysis and advanced data analytics. In addition, you will realise the responsibilities of database designers with respect to professional, legal, security and ethical issues.

Course info

Credits 20

Level of Study Postgraduate

Mode of Study 2 years Distance Learning

Department Computer and Information Sciences

Location City Campus, Northumbria University

City Newcastle

Start Upcoming Intakes - Academic Year 2020/21: April 21, July 21. Academic Year 2021/22: Oct 21, Jan 22

Fee Information

Module Information

All information on this course page is accurate at the time of viewing.

Courses starting in 2021 are offered as a mix of online and face to face teaching due to the ongoing Covid-19 pandemic.

We continue to monitor government and local authority guidance in relation to Covid-19 and we are ready and able to flex accordingly to ensure the health and safety of our students and staff.

Students will be required to attend campus as far as restrictions allow. Contact time will increase as restrictions ease, or decrease, potentially to a full online offer, should restrictions increase.

Our online activity will be delivered through Blackboard Ultra, enabling collaboration, connection and engagement with materials and people.

 

Current, Relevant and Inspiring

We continuously review and improve course content in consultation with our students and employers. To make sure we can inform you of any changes to your course register for updates on the course page.


Your Learning Experience find out about our distinctive approach at 
www.northumbria.ac.uk/exp

Admissions Terms and Conditions - northumbria.ac.uk/terms
Fees and Funding - northumbria.ac.uk/fees
Admissions Policy - northumbria.ac.uk/adpolicy
Admissions Complaints Policy - northumbria.ac.uk/complaints