ERgenerator with participation constraints: Entity-relationship generator

• Main Authors: Cheng, Bernard Gladwin L., Liao, Joann D., Salvador, Buddy Hope E., Sobrevilla, Joanne Louise F.
• Format: text
• Language: English
• Published: Animo Repository 2004
• Subjects: Database management > Computer programs; Database design; Relational databases; Artificial intelligence; Computer Sciences
• Online Access: https://animorepository.dlsu.edu.ph/etd_bachelors/14253
• Institution: De La Salle University

In traditional relational database design process, it is recommended that designers draw the entity-relationship diagram first before converting it to relational database tables. In practice, however, most database designers often skip this part of the database design process and proceed directly to coding. Nevertheless, the Entity Relationship Diagram (ERD) is still one of the requirements in database technical documentation, which helps database designers to visualize the relationships among the tables in a database. ERGenerator is a tool can generate an Entity Relationship Diagram (ERD) from an existing database. This tool will be a big help for database designers in visualizing the existing relational tables they have created. It has an impor/export option that allows the user to modify an existing database while preserving existing data through the use of translation methods. Furthermore, it can also populate these databases with meaningful data which can be used for simulation purposes. Keywords: entity relationship diagram, relational table, relational database, database technical documentation, data population.