Relational Database Design

Course Overview

At work, storing and accessing data are part of a person's day-to-day activities. One of the most efficient and powerful ways of managing data is by using relational databases. Information can be stored, linked, and managed using a simple relational database application and its associated tools. You have used databases to store and retrieve data. Now, you may want to plan and design your own database. A well-designed database allows easy maintenance and quick access of data. In this course, you will plan, design, and create a functional and efficient relational database. You can create effective database designs by applying relational database design techniques.

Course Objective

You will design and create a relational database.

Target student

Individuals who are able to write simple queries or run queries that someone else has designed.

Prerequisites

Microsoft Access 2003 or 2007 Level 1 course or equivalent is recommended.

We offer a range of SQL training courses

Analyzing Client Requirements
  • Analyze Current Data Storage Systems
  • Identify New Client Requirements
  • Determine the Required Data Fields
  • Group Fields into Tables
  • Identify Key Fields
Creating a Preliminary Design
  • Create a Preliminary Entity Relationship Diagram
  • Apply the First Normal Form
  • Apply the Second Normal Form
  • Apply the Third Normal Form
  • Apply the Higher Normal Forms
  • Denormalize Tables
  • Incorporate Client Feedback
Implementing the Database Design
  • Translate Business Rules into Constraints
  • Create Tables
  • Create Indexes
Generating Reports
  • Manipulate Data
  • Generate Reports Using Conditions
  • Generate Reports from Multiple Tables
  • Generate Summary Reports
  • Create Views
Customizing a Database
  • Modify Constraints
  • Modify Fields