Li Yang

Work place: University of West Georgia/ Department of Computer Science, Carrollton, GA, USA

E-mail: lyang@westga.edu

Website:

Research Interests: Computer systems and computational processes, Computer Architecture and Organization, Computer Networks, Hardware Security, Information Security, Network Security

Biography

Li Yang, Ph.D. Dr. Yang is an Associate Professor in the Department of Computer Science at the University of West Georgia. She received her doctorate from Florida International University. She has taught a variety of undergraduate courses, such as Information Management, Computing Capstone, Parallel and Distributed Systems, CS1, CS2, Operating Systems, Web Technologies, among others, and graduate courses Operating Systems, and Database Systems I and II. Her research interests include Computer Science Education, Computer Security, and Database Systems.

Author Articles
The Effect of MySQL Workbench in Teaching Entity-Relationship Diagram (ERD) to Relational Schema Mapping

By Li Yang Li Cao

DOI: https://doi.org/10.5815/ijmecs.2016.07.01, Pub. Date: 8 Jul. 2016

While designing a database at the conceptual level using the Entity-Relationship (ER) model is challenging for novices, mapping an Entity-Relationship Diagram (ERD) to a relational schema is not an easy task, either. One of the problems is students’ lack of understanding of the underlying mapping principles. The mental gap between the two models in students also makes it difficult for them to perform the conversion. This paper describes two studies that aimed at helping students fill the gap and improve their ERD-Relational schema mapping performance by the use of a visualization tool, MySQL Workbench. We investigated the effect of using MySQL Workbench in teaching ERD-Relational schema mapping. We identified the pros and cons of using visualization in teaching the topic. Our results show that visualization can increase student interest and engagement, and facilitate students connecting the concepts in the two models. With an instructional delivery method that emphasizes the underlying mapping principles, a visualization tool could help undergraduate students improve their performance on ERD-relational schema mapping and facilitate their understanding of the ER model.

[...] Read more.
Other Articles