Transform complex data requirements into clear, professional crow's foot diagrams with a proven, structured methodology.
Relational database design is a fundamental aspect of software development. A well-designed database provides the foundation for reliable, efficient, and maintainable applications, while design errors can lead to data inconsistencies, performance issues, and costly modifications. This course introduces a simple, structured, and reliable six-step technique for designing relational databases that can be implemented on virtually any relational database management system (RDBMS).
Based on the book Six-Step Relational Database Design™, the course guides students through six logical steps, beginning with the identification of entities and attributes and progressing through the discovery of relationships, the creation of Entity-Relationship (E-R) diagrams, and the development of a complete Crow’s Foot Relational Model (R-M) diagram suitable for implementation on any relational database management system (RDBMS).
The course also introduces basic inline CRUD (Create, Read, Update, Delete) auditing techniques, demonstrating how attributes such as CreatedBy, CreatedOn, LastUpdatedBy, LastUpdatedOn, IsDeleted, DeletedBy, and DeletedOn can be incorporated into database designs to support accountability, traceability, and data management.
A real-world case study is used throughout the course to demonstrate each step of the process. Through practical examples and exercises, students will learn to systematically analyze problem statements, identify entities and relationships, develop conceptual models, and transform these models into implementable relational database designs.
The course also explores how the six-step technique can be used alongside artificial intelligence (AI) tools to validate, refine, and improve AI-generated database designs. This provides students with a systematic approach to evaluating the accuracy, completeness, and logical consistency of database models, whether developed manually or with AI assistance.
Topics Covered:
8 activities • 12 videos • duration: 1h 12m

Educator & IT Project Management Consultant
A qualified and experienced IT professional with over 25 years’ experience designing, developing, implementing and managing IT solutions in the areas of IT project management, database design and website design.
Provincial regulators of CPAs in Canada do not require that independent providers of CPD be approved to offer courses. Instead, individual CPAs are responsible for assessing whether a CPD activity meets their requirements, and may take activities from any source provided those requirements are met.
Every course offered on LearnFormula is delivered by a qualified subject matter expert or learning organization, and advances learning objectives that are relevant to the responsibilities or professional competencies of Canadian CPAs. All activities on LearnFormula are quantifiable in terms of hours, and are also verifiable, in that users receive documented evidence of their attendance via a certificate of completion after finishing a course (and this certificate is stored by LearnFormula indefinitely). Nearly 100,000 Canadian CPAs successfully satisfy their CPD requirements via LearnFormula on an annual basis.