Foundation Design Board

Author / Site: Custom Course Tool / Instructional Design Team

Summary: An interactive HTML-based design board application that provides a drag-and-drop or selection-based workspace for constructing and evaluating relational database schemas. The tool appears to support placing and organizing table structures, keys, and attributes, with visual feedback indicators (color-coded chips, check panels, and scoring) to guide learners through schema design tasks.

Relevance to Module: This tool directly supports the module's focus on converting ER diagrams into relational schemas by providing a hands-on environment where students can map entities, attributes, primary keys, and foreign keys into table structures. Its built-in evaluation feedback (scored checklists, highlighted errors) aligns with the module's emphasis on validating schema correctness against ER constructs.

Pedagogical Purpose

This interactive design board serves as a scaffolded practice and self-assessment tool, giving students immediate visual feedback as they attempt to apply ER-to-relational mapping rules — directly supporting MO1 (identifying correct table structures and key assignments for strong and weak entities), MO2 (placing foreign keys for one-to-many relationships), MO3 (constructing junction tables for many-to-many relationships), and MO4 (forming composite primary keys for weak entities). The scoring and checklist mechanism also supports MO5 by prompting students to evaluate their completed schema for primary key integrity, referential integrity, and normalization against the original ER diagram.

Added September 11, 2026