Bashar Ramadan

Work place: Department of Computer Science, Umm Al-Qura University, Makkah, Saudi Arabia

E-mail:

Website:

Research Interests: Control Theory, Network Security, Information Security, Computer Networks

Biography

Basher Ramadan is a Teaching Assistance in the Department of Computer Science at Umm Al-Qura University, Saudi Arabia. He get a postgraduate Diploma in computer network from the Department of Computer Engineering, Vladimir University in, Vladimir – Russia in 2002. He received his Bachelor in Information Technology from Vladimir University 2001. His research interests include computer network, Information security, remote control, database, and computer programing.

Author Articles
A Novel Normalization Forms for Relational Database Design throughout Matching Related Data Attribute

By Youseef Alotaibi Bashar Ramadan

DOI: https://doi.org/10.5815/ijem.2017.05.06, Pub. Date: 8 Sep. 2017

One of the main goals for designing database is minimize the data redundancy. Literature shows that there is several approach have been used to minimize the data redundancy, such as converting an Entity Relational Diagram (ERD) scheme according to steps of an algorithm for ER-to-relational mapping, and applying the normalization rules. These techniques have improved the database design quality, reduced the data redundancy, and omitted from a large proportion of repetition. However, there are still a big proportion of duplicated values especially for the huge database as some attribute are related to each other and may have the same data, such as the attributes of first_name, middle_name, and family_name. These attributes cannot be called as the multivalued attribute as these values belong to variety of entities or relations. Therefore, we propose a novel normalization forms for relational database design that match the related data attribute. This proposed approach called Matching Related Data Attribute Normal Form (MRDANF). A civil registration database system is used as a case study to validate the proposed approach. The results show that using our proposed approach has the positive impact on database quality and performance as the data redundancy will be reduced.

[...] Read more.
Other Articles