Relational Database Design

    

Summary:
This course is designed to provide the student with an introduction to relational database design concepts. Students will learn methodologies such as entity relationship modeling and normalization techniques that will allow them to create a logical database design with business rules and performance in mind. The course focuses on different levels of data integrity, including referential integrity considerations between entities. The lab session allows the students to practice designing a logical data model.

Duration:
1 Day/Lecture & Lab

Audience:
This course is designed for systems analysts and programmers who are responsible for analyzing business areas, designing and creating relational databases.

Topics:

• Basic Structured Analysis Concepts
• Entity Relationship Modeling
• Data Normalization
• Referential Integrity
• Logical and Physical System Models

Prerequisites:
There are no prerequisites required for this course.

Last Update: July 29, 2010