ER Diagram Optional Relationship – It is believed that the ER Diagram can be a useful tool for data mining. This is due to the fact that it allows you to show complex relationships in a simple format. The fundamental steps are identical wherever you work. In the beginning, it is to determine “what” your system is….