A consultant was hired for the Bestaurants project to advise on the newly created geodatabase. After taking a look at the geodatabase, the consultant found it a bit difficult to assess the design by looking at the physical geodatabase. So, she suggested that we create an entity relationship diagram in order to visualize the design better and find the bottlenecks, if any.
We will start by laying out the current entity relationship diagram as the consultant suggested. This way, we can identify the inefficiencies and flaws in the current model. There are a lot of tools available that enable you to do database modeling such as Microsoft Visio and ArcgoUML. I'm using an online tool called Gliffy for designing and modeling geodatabases. You can access it for free without creating an account at www.gliffy.com. You don't have to do the modeling part in this chapter; however, it is recommended that you model your design...