Solution
Let's take a look at our solution.
Implementing the database
Let's take a look at what is needed in the database.
SystemObjects
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.
Ratings
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.
System object rating options
In addition to
the ratings table we also have the SystemObjectRatingOptions
table. This table tracks all the options that are...