Analysis for Gerund Entity Anomalies in Data Modeling

Des Suryani, Yudhi Arta, Erdisna

2019

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 entity. The result of a good database design or free of anomalies will increase the optimization of memory usage, consistency and integrity of data.

Paper Citation

in Harvard Style

Suryani D., Arta Y. and Erdisna. (2019). Analysis for Gerund Entity Anomalies in Data Modeling.In Proceedings of the Second International Conference on Science, Engineering and Technology - Volume 1: ICoSET, ISBN 978-989-758-463-3, pages 146-150. DOI: 10.5220/0009145601460150

in Bibtex Style

@conference{icoset19,
author={Des Suryani and Yudhi Arta and Erdisna},
title={Analysis for Gerund Entity Anomalies in Data Modeling},
booktitle={Proceedings of the Second International Conference on Science, Engineering and Technology - Volume 1: ICoSET,},
year={2019},
pages={146-150},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0009145601460150},
isbn={978-989-758-463-3},
}

in EndNote Style

TY - CONF

JO - Proceedings of the Second International Conference on Science, Engineering and Technology - Volume 1: ICoSET,
TI - Analysis for Gerund Entity Anomalies in Data Modeling
SN - 978-989-758-463-3
AU - Suryani D.
AU - Arta Y.
AU - Erdisna.
PY - 2019
SP - 146
EP - 150
DO - 10.5220/0009145601460150