Courseware to aid database design

  • Authors:
  • Alyson Boyd;Tanya Lawson;Mario Guimaraes

  • Affiliations:
  • Kennesaw State University, Kennesaw, GA;Kennesaw State University, Kennesaw, GA;Kennesaw State University, Kennesaw, GA

  • Venue:
  • Proceedings of the 43rd annual Southeast regional conference - Volume 1
  • Year:
  • 2005

Quantified Score

Hi-index 0.00

Visualization

Abstract

Designing normalized tables is a subject of great difficulty and importance. Unnecessary redundancy may results not only in too much space being used to store the data and poor query performance, but it may also result in inconsistencies as denormalized (unnecessary redundancy) data is much more difficult to keep current. Converting tables from E-R Diagrams (or extended E-R Diagrams or Class Diagrams) is a difficult task for most students. Some students manage this task in their first undergraduate class by simply memorizing the rules and never knowing the reasons behind why the rule was created. Therefore when they get to more advanced classes they had forgotten how to accomplish the conversion because they never understood the reasons behind the rules.