Authors:
Des Suryani
1
;
Yudhi Arta
1
and
Erdisna
2
Affiliations:
1
Department of Informatics Engineering, Universitas Islam Riau, Pekanbaru, Indonesia, Indonesia
;
2
Department of Information System, Universitas Putra Indonesia, Padang, Indonesia
Keyword(s):
Anomaly, Data Redundancy, Data Inconsistency, Gerund Entity, Entity Relationship Diagram.
Abstract:
Data is the most important component of an information system development. Collected data that will be used in future needs should be kept well to make it easy to inquire. The data stored in a database consists of
several groups of data relations. These relations should be connected through fields which are unique to the relations linked. In designing database itself, it is very important to note how data is organized and stored to minimize data redundancy. The tools used in depiction of the relationship between tables or entities are Entity Relationship Diagram (ERD) that can have one to one, one to many and many to many relationships. Gerund
entity will be formed if the relationship between the entities is many to many. However, the new entity is still a possible anomaly. The reanalysis is needed to be free of anomalies. Gerund entity that still has an anomaly will form a new entity again, which in this case referred to as a sub gerund entity which is a derivative of a gerund entit
y. The result of a good database design or free of anomalies will increase the optimization of
memory usage, consistency and integrity of data.
(More)