You Are The Sql Programmer For A Mental Wellbeing App Which Allows Users To Do Two T 2958805

Case
You are the SQL programmer for a mental wellbeing app, which allows users to do two types of things. The first is to
participate in a Twitter-style social network. The second is to do online units called Steps, which are interactive therapy
modules designed to exercise and develop a range of psychological skills. Your job is to write SQL queries that allow the
app to work. The data model is as follows:
How the app works
When users register into the system, a record is created in the `user` table. Upon registering, a user can follow other users
to see their posts and activity. If user x (following) starts following user y (followed), an appropriate entry is created in the
`user_follow` table (x following y does not necessarily mean that y follows x). The weight attribute of this table holds an
integer that reflects the extent to which x follows y; for example, this number would increase the more x likes or comments
on posts created by y. To help connect users, each user can also select, from a list stored in the `interest` table, interests that
they have (e.g. movies, music, books). For each interest that a user selects, a record is created in the associative table
`user_interest`.
On the therapy side of this app, users can do online modules called Steps. Different Steps take different amounts of time to
complete and users can do a Step in one sitting or return to a Step and complete it later on. Sometimes they might not finish
a Step and will instead move on to something else. Also, they can do any given Step as many times as they would like and
each time they finish a Step they can rate how it made them feel (1 being the lowest and 5 being the highest).
As soon as user x makes a start on doing Step y, an entry is created in the `step_taken` table to record the fact that x started
doing y. The timestamp of this start is also automatically recorded in the `when_started` column. If a user finishes this
attempt to do the Step, the datetime of completion is recorded in the `when_finished` column

Attachments:

INFO90002-S1-….pdfasst2-2019s1-….sql

Prof. Angela

4.6/5

Calculate Price


Price (USD)
$
Open chat