Relational database reconstruction from SQL to Entity Relational Diagrams

Abstract

The absence of requirement documents or incompatibility of the requirement documents with existing software can be a problem in developing or maintaining software. Without knowing things that become requirements can cause software as a product that fails because it does not meet customer desires. One of the main problems in developing or maintaining software is that developers do not know the entity relational schema of the software. So developers will prefer to rebuild from scratch. This paper discusses database reconstruction from SQL to entity relational diagrams by identifying the primary and foreign keys of SQL sampling.