Here is a restaurant entity relationship flowchart, from which explains the whole process from the guest entering, serving the food to paying the bill. Entity relationship flowchart serve as a visual starting point for database architecture, as well as a tool for determining information system requirements throughout an organization. It can still be used as a reference point after a relational database has been deployed, in case any debugging or business process re-engineering is required afterwards. While an entity relationship flowchart is effective for organizing data that can be represented by a relational structure, it is inadequate for semi-structured or unstructured data. It's also unlikely to be useful in integrating data into an existing information system on its own. You can now create such a diagram with EdrawMax, or customize the example to fit your needs.