Relationships are the core of any relational database management system. The relational database model is based on multiple tables connected via relation. Relationships come in many forms, one to one, one to many, and many to many. In our case, a certain venue has many reviews which make this relationship a one-to-many relationship.
There can be many reviews and ratings for a given restaurant, and putting this information in the feature class will create duplicate information. This is why a related table can be useful here. Both the reviews and ratings are stored in a related table called VENUES_REVIEW. Follow these steps to inspect this related table:
If necessary, copy the entire
bestaurantsfolder from the supporting files for this chapter,B04847_06_Files\bestaurants\to theC:\ArcGISByExample\. If you already have done this in Chapter 5, App 2 – Extending ArcObjects, you can skip this step.From the Start menu, run ArcCatalog.
Connect...