Answer Happy

Use the conceptual model below to create the necessary column families for this assignment, as described in the instructions in the next section medial type URL alt text MULTIMEDIA CONTENT UUID text (possible values audio, video, image, Hyperlink) + text text COMMENT contains MULTIMEDIA CONTENT POST contains MULTIMEDIA CONTENT USER has profile picture POST posto int text contents text created datetime updated datetime privacy interaction Odtype comment contents Created INTERACTION UUID text (possible values: like, comment) text datetime text USER interacts with POST UD USER creates POST username active firstname lasiname bio USER int text bool text text text FOLLOWER follows USER FOLLOWS Follower dD int
You must turn in a collection of column family definitions that support the queries described below using the CREATE TABLE Y CREATE COLUMN FAMILY Syntax supported by COL. Click here to view the formal documentation e. You can also find many examples in the Topic 3 Learning Guide.) 1. For a specific user, obtain the username and URL of the profile picture for all people who follow that user 2. For a specific post, obtain the username of all users who liked that post. 3. For a specific post, obtain the text contents of all comments on that post, arranged from oldest to newest. For each of those comments, you should also include the username and profile picture URL of the user that posted the comment as well as the type and URL of any multimedia comment in that post, 4. For a specific post, obtain the type and URL of all multimedia associated with the post (only the post media, not media associated with comments on the post). 5. For a specific user, obtain the contents of all posts created by that user, including types and URLs of any associated multimedia content for each post, arranged from newest to oldest. Above, all dates refer to create date, not update date, Assignment Submission Submit your col file containing your CRIATE statements on Gradescope below. Before each statement include the problem number(s) that are served by that table/column family in a comment. For example: This statement verves query CREATE TABLE This statement serves queries 2 and CREATE TABLE