Database Fundamentals

Introduction

In the second Multiverse module we will learn about two important databases: normalised relational databases and NoSQLto understand how and why they are used for analysis.

Following on from this we will look at how we can overcome problems in our projects, implement quality control measures and assure the quality of data uploads.

Learning Objectives

• Explain the concepts and uses of a relational database management system
• Identify the different types of key in a RDBMS
• Understand the principles of normalisation on a relational database
• Design and visualise an entity relationship diagram for a database
• Identify starting points for overcoming project and technical problems
• Implement quality control measures and know how to assure the quality of data uploads and query output

Slides

Session Attendance Log

Session 1

Session 2