Question: please help me out Que: ABC software makes an online resource sharing app for specialty groups which allows users to post resources and to see
please help me out
Que: ABC software makes an online resource sharing app for specialty groups which allows users to post resources and to see / like resources posted by others. The users detail include basic user info such as username, name, profileImage along with the group they belong to.
The resource itself contains id, topic, description, URL and zero or more tags (to categories the resource) along with other data such as poster details, posted date and time.
The app records data about two activities on different levels. First, every time a user views a resource, the user info, resource info, date and time info of the resource viewed is recorded (if the same user views the resource multiple times, multiple entries are made). Second, a user can like a resource and can do so only once.
PART 1: Identify the dimensions (with attributes), facts and the grain of the fact table(s).
PART 2: draw the star or snowflake schema for the above. You don't need to mention attributes for the dimensions here but you DO need to identify FKs in the fact table(s).
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
