Relational Database Design

Prerequisites

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.

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

Number of sessions: 1

• Entities
• Relations
• Entity-Relationship Diagrams
• Keys
• Creating tables
• Constraints

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

One half day session