Open AccessVenn Versus Relation Diagram Models For Database Relation in SQL Command Line
Author(s) -
Nunu Kustian,
Siti Julaeha,
Dudi Parulian,
i Selvia,
Erlin Windia Ambarsari
Publication year - 2021
Publication title -
journal of physics. conference series
Language(s) - English
Resource type - Journals
SCImago Journal Rank - 0.21
H-Index - 85
eISSN - 1742-6596
pISSN - 1742-6588
DOI - 10.1088/1742-6596/1783/1/012050
Subject(s) - venn diagram , relation (database) , computer science , diagram , table (database) , entity–relationship model , database , sql , communication diagram , representation (politics) , line (geometry) , data mining , relational database , class diagram , programming language , mathematics , software , unified modeling language , mathematics education , politics , political science , law , geometry
The study was to analyze the difference between two diagrams, such as a Venn and relation diagram. Comparisons are made based on syntax in SQL Command-Line, primarily when used the Select condition clause. The sample command used for diagrams was inner join and where syntaxes. The diagrams will act as data representation for the Relational Database to display an outline of data relationship analysis. The results obtained that difference between them was significant. The Venn diagram was useful to evaluate how the attribute in the table is connected. The opposite, the relationship diagram, shown how the dataset was related to the tables. Therefore it recognizes the data that had to deceive. However, the more data related then, the more diagram is complex.