Modeling and teaching techniques for conceptual and logical relational database design

Area of Science:

• Computer Science
• Information Systems Education

Background:

• Effective teaching of database design is crucial for developing robust information systems.
• Existing Entity-Relationship Diagram (ERD) notations can present challenges for student comprehension.
• The Unified Modeling Language (UML) offers a powerful framework for conceptual modeling.

Purpose of the Study:

• To propose and evaluate a novel ERD notation tailored for educational purposes in database design.
• To enhance student understanding and practical application of database design principles.
• To provide a structured methodology for converting ERD components into normalized database tables.

Main Methods:

• Development of a new ERD notation derived from the Unified Modeling Language.
• Step-by-step process for translating ERD elements into relational database tables.
• Application of database normalization techniques to the generated tables.

Main Results:

• The proposed ERD notation demonstrably facilitates student learning of database design.
• The structured methodology simplifies the transition from conceptual ERDs to physical database tables.
• Students effectively learn to normalize database tables using the presented techniques.

Conclusions:

• The adapted UML-based ERD notation is an effective pedagogical tool for teaching database design.
• A clear, step-by-step process aids students in table creation and normalization.
• This approach improves the overall learning experience and outcomes in database education.