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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!