Relational Database Design

BeginnersPrerequisites

This course gives a simple introduction to organizing your data in a relational database. It aims to explain the arranging of your data. It does not deal with specific relational databases systems such as Access, Oracle or SQL Server, or the technical tools that you would or could use to set up your database. The course aims to provide you with enough information to sit down and design your database, regardless of the database product that you intend to use. Exercises will be done on paper, without using computers.

• All current University members (departments and colleges)
• Further details regarding eligibility criteria are available

Although the exercises will not involve using a computer, basic IT literacy/awareness will be helpful.

Number of sessions: 1

• Entity-Relationship Diagrams
  • Tables and Fields
  • Keys and Joins
  • A practical understanding of normalisation

A mixture of presentations and pencil-and-paper exercises.

One half day session

• Access 2016: Creating a Simple Database
• Access 2016: Fast Track Introduction
• Access 2016: Further Use
• MySQL: Implementing a Relational Database Design

• Databases
• Techlinks & IT Support Staff