Let's take a look at our solution.
Let's take a look at what is needed in the database.
The SystemObjects table is at the center of this chapter's list of features. Having said that, this table is the easiest part of this equation. It simply keeps track of all the tables in the system. Specifically, it keeps track of the table names and maintains an ID for each name.
The Ratings
table is responsible for holding all the end user ratings. As you can see each rating ties back to the SystemObjects table and also directly to the record within the specified table. In addition to that, we are also tracking the Option that was rated. The most important part of this table though is the Score field. The Score tracks the selected number of stars (in our case) that the end user has selected.
