Construct a database design in UML for an app store described below.

A Publisher where each publisher is identified by an id and has a name.

A Category where each category has an id$,$ a name, and may have a parent category.

An App storing each app that is identified by a field called id and other attributes include name and description. An App is created by one Publisher. A Publisher may publish multiple Apps. An App has a Category.

A AppVersion stores each version of the app. An AppVersion is associated with exactly one App. Use a version field to identify between versions of the same App. Each AppVersion has a release date, a rating, a price, and a description.

A AppVersionReview stores ratings for each application version. Each instance applies to a single AppVersion, and different reviews are identified by reviewer attribute $($which is name of reviewer$).$ There is also a reviewDate, rating, and review.