Jove
Visualize
Contact Us
JoVE
x logofacebook logolinkedin logoyoutube logo
ABOUT JoVE
OverviewLeadershipBlogJoVE Help Center
AUTHORS
Publishing ProcessEditorial BoardScope & PoliciesPeer ReviewFAQSubmit
LIBRARIANS
TestimonialsSubscriptionsAccessResourcesLibrary Advisory BoardFAQ
RESEARCH
JoVE JournalMethods CollectionsJoVE Encyclopedia of ExperimentsArchive
EDUCATION
JoVE CoreJoVE BusinessJoVE Science EducationJoVE Lab ManualFaculty Resource CenterFaculty Site
Terms & Conditions of Use
Privacy Policy
Policies

Related Experiment Videos

Modeling and teaching techniques for conceptual and logical relational database design.

Cheryl Bagley Thompson1, Katherine Sward

  • 1University of Nebraska Medical Center College of Nursing, 985330 Nebraska Medical Center, Omaha, Nebraska 68198-5330, USA. cbthompson@unmc.edu

Journal of Medical Systems
|September 27, 2005
PubMed
Summary

This study introduces novel techniques for teaching database design, focusing on an Entity-Relationship Diagram (ERD) notation adapted from the Unified Modeling Language. This method simplifies learning the database design process and table normalization.

Related Concept Videos

You might also read

Related Articles

Articles linked to this work by shared authors, journal, and citation graph.

Sort by
Same author

Real-world management and outcomes of immune-mediated diarrhea and colitis: gaps in guideline adherence and opportunities for implementation.

Supportive care in cancer : official journal of the Multinational Association of Supportive Care in Cancer·2026
Same author

Patterns of self-reported diarrhea in patients with cancer receiving chemotherapy.

Supportive care in cancer : official journal of the Multinational Association of Supportive Care in Cancer·2025
Same author

Patient and parent perspectives on an academic rheumatology transition clinic.

Health care transitions·2025
Same author

Hyperferritinemic sepsis, macrophage activation syndrome, and mortality in a pediatric research network: a causal inference analysis.

Critical care (London, England)·2023
Same author

Early, Persistent Lymphopenia Is Associated With Prolonged Multiple Organ Failure and Mortality in Septic Children.

Critical care medicine·2023
Same author

Assessing EHR Data for Use in Clinical Improvement and Research.

The American journal of nursing·2022

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.

Related Experiment Videos

  • 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.