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

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: Document Preview:

INFO90002 Database Systems and Information Modelling Assignment 2, Semester 1 2019 Assignment 2: SQL INDIVIDUAL PROJECT (10%) 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…

Attachments:

INFO90002-S1-….pdf

Prof. Angela

4.6/5

Calculate Price


Price (USD)
$
Open chat