On March 2, the SITC hosted a workshop on database modeling and normalization led by Dr. Narasimha Rao Vajjhala and Mr. Evgeny Arkhipov.
Dr. Vajjhala, who chairs the Computer Science and Software Engineering programs, said the workshop was intended for students who plan to design databases in their Senior Design Project (SDP) this semester.
He described E-R Diagrams as a pictorial representation of data that describes how data is communicated and related to each other. E-R Diagrams, he continued, help the designer to visualize the relationships between tables in a database.
“For the SDP students, this is one of the things expected from some of you as part of your projects. This workshop will help you in building conceptual data models for the system you intend to develop.”
Mr. Arkhipov, a Computer Science instructor who concentrated on normalization, defined it as a set of rules that guides the modeling of tables in a database. Normalization, he went on, encompasses creating tables and establishing relationships between those tables.
“Normalization rules are designed to prevent anomalies and data inconsistency. We encourage normalization in database design because it helps to resolve data redundancy, eliminate duplicate data, organize tables and increase the ease of managing data.”
Students, staff and faculty from across the four AUN schools attended the workshop.
Reported by Bashir I. Bashir