Relational Database Design

$450.00
$450.00
Start Date Time Days Price GTR Availability
August 28, 2017 09:00 (EST) 1 $450.00 Register
November 27, 2017 09:00 (EST) 1 $450.00 Register

Duration: 1 Day

Course Description
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.

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

Prerequisites
Microsoft Access Level 1.

Objectives
Upon successful completion of this course, students will be able to:

  • Analyze client requirements
  • Create a preliminary design
  • Implement the database design
  • Generate reports
  • Customize a database

Course Content

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
  • De-normalize 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
  • Modify Tables