Venn Versus Relation Diagram Models for Database Relation in SQL Command Line

Abstract

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.