An Approach to Automate the Relational Database Design Process

Uduwela, W.C.; Wijayarathna, Gamini

doi:10.5121/ijdms.2015.7604

Cited by 2 publications

(3 citation statements)

References 9 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…Attributes are representative of the entity as well as the type of relationship between entities. The primary key is an attribute with a unique identifier representing an entity, and a foreign key is an attribute used to connect with the parent entity [16]. Generally, the primary key of an entity will be entered into another entity so that it becomes a foreign key.…”

Section: Database Designmentioning

confidence: 99%

Analysis and Design of Internal Traceability System for Rice Processing Industry

Purwandoko¹,

Seminar

Sutrisno

et al. 2023

IOP Conf. Ser.: Earth Environ. Sci.

View full text Add to dashboard Cite

Data management is needed to monitor production so business processes run according to operational standards. The rice processing industry’s data management system is still manually, causing ineffectiveness. Therefore, an information system that captures and records all business activities is needed. This study aimed to develop an internal traceability system design that is used to document all material flows during rice processing. Based on the results obtained, the business process in the rice processing industry consists of three main activities: receiving raw materials, processing products, and warehousing the final product. The traceability system requirements modeling is done by compiling an information system architecture, analyzing data and information requirements using UML (Unified Modeling Language) object-oriented class diagrams, and developing a user interface (UI) design for the system. The result of this study is a system design that can ensure that the input (a receipt of raw materials), process, and output (final product) are well connected to be used for monitoring rice processing. Furthermore, the application of the traceability system can have a positive impact on the industry, government, and consumers.

show abstract

Section: Database Designmentioning

confidence: 99%

Analysis and Design of Internal Traceability System for Rice Processing Industry

Purwandoko¹,

Seminar

Sutrisno

et al. 2023

IOP Conf. Ser.: Earth Environ. Sci.

View full text Add to dashboard Cite

show abstract

“…The approach of Uduwela and Wijayarathna [22] is to extract the normalized database by identifying the primary key, foreign key and relationships between the data entities from a structured format of requirements (forms). Human involvement required to confirm the selection of entities.…”

Section: Literature Reviewmentioning

confidence: 99%

“…Major portion of the software industry is information systems, being used by all types of organizations [13]. Conceptual model, e.g., Entity Relationship (ER) model plays a vital role in the system specification, analysis, and development [7].…”

Section: Introductionmentioning

confidence: 99%