Introduction to Database Design

DESCRIPTION
This course offers delegates an introduction to the design and programming of relational database systems. In particular, the course covers ER (entity-relationship) approaches to data modelling, the relational model of relational database management systems (RBMS) and the use of query languages such as SQL. The first two sections are supplemented with many practical exercises. The delegate will have the opportunity to design and implement a simple relational database using Microsoft Access Tools.

PREREQUISITES
Some exposure to MS Access, or a similar database application.

• What is a database
  
• Database tables
  
• Table Relationships
  
• Using Queries
  
• Using Forms
  
• Stages in Database Design
  
• Tables/Entities
  
• Determining Attributes / Columns / Fields
  
• Table Relationships
  
• Entity-Relationship (ER) model
  
• Primary and Foreign Keys
  
• Referential Integrity
  
• Data Integrity
  
• Data Normalisation
  
• Table indexing and strategy
  
• Implementing an ER Model using Microsoft Access