1 Monash University FIT5046 – Mobile and Distributed Computing Systems Practical Assignment (Server-Side) (10%) Due Week 5, Friday 3 pm (10th of April) An Overview: The assignment is an individual assignment. This assignment 1 (server-side) does not have an interview. This assignment requires submitting a report that includes all the required code, diagram and screenshots as specified and in the right order, format and structure. (Note: Your mark will be based on the code and screenshots provided in the report) Practical Assignment (client-side) Phase 2 will be developed based on this assignment Phase 1 and it will have an interview. The marks allocated for all the tasks in this assignment will add up to 100 marks and it is worth 10% of the total mark for this Unit. Due Date: The submission is due on Friday Week 5 (10th April) by 3 pm. Objectives and learning outcomes: To identify, develop and apply different approaches and methods for building distributed and mobile computing systems; To select and apply effective and efficient (server-side) approaches for this particular distributed application; To develop and test the server-side components of a mobile distributed application. My Movie Memoir (M3) The practical assignments Phase 1 and Phase 2 (server-side and client-side) aim towards building a mobile and distributed, personalised diary application for keeping track of movies (and TV series) that the user watched or wants to watch in future. The application will provide a movie memoir that allows the user to create a collection of memories that they had about the movies. The practical assignment 1 will focus on creating the backend and server-side components of this mobile, distributed system. The server side will make the data and services (methods) available to all the mobile clients through an API (RESTful web services APIs). The practical Assignment (server-side) requires: 1) creating a database (Java DB database in NetBeans) that will include the specified tables and populating the tables with meaningful data; and 2) creating a RESTful web service that enables querying this data and updating it if necessary. The practical Assignment 3 (client-side) Phase 2 will involve creating an android application that will interact with public web APIs and the REST web service (created in Assignment 1) to query and retrieve data. Assignment 1 MUST be implemented in NetBeans. 2 Figure 1. an overview of Assignment 1 and Assignment 3 Report Format You need to submit a written report as a Word/pdf document, which includes a copy of your written code (copy and paste your code from NetBeans) and screenshots of running RESTful methods in the browser: The report will include a cover page that includes your full name and student id, the assignment name, the unit name, and your tutor name; You need to include Table of contents (this means you have to include a page number) You will include your written code and the screenshots with the same order of tasks listed here. You need to use numbered headings and subheadings (e.g. 1. Task 1. Part a:… ). You must write one sentence to explain your written code/method, and a screenshot of its execution in the browser, similar to Figure 2 (shown on page 4). Your code in the report must be EXACTLY the same code in the NetBeans project that you will submit to Moodle in a zip file. Task 1 – Database (15 marks): Based on the requirements below, you will create the backend database and its tables with the specified attributes and populate them with data as described in part (b). You need to add all the required constraints and create the relationships. a) You need to create the following tables (you should not add any additional table): User Person Table (3 marks) The user Person table will store data about the user that include: first name, surname, gender, DoB, address (street number and street name), state, and postcode (only consider for Australia). Credentials Table (3 marks) The Credentials table will store information about a user’s credentials including: username (we suggest to use the email for the username), password hash, and sign-up date. There is no need for extra security measurements in this application such as adding salt to hashing. Also, there is no need for considering password expiration. Assignment 1 Assignment 3 3 Memoir Table (3 marks) This table will store a collection of memories about movies that the user have watched. These memories include the following information: movie name, movie release date, the date and time that the user watched the movie, a comment about user memory or opinion, a rating score given by the user (not by the public) based on stars. The table below shows the star ratings compared to a 1 – 99 scale. In the Assignment 3 (the phase 2 of this assignment) you must show all the rating scores as stars (half and full). STARS 1-99 scale 0 1-9 0.5 10-18 1 19-27 1.5 28-36 2 37-45 2.5 46-54 3 55-63 3.5 64-72 4 73-81 4.5 82-90 5 91-99 Cinema Table (2 marks) The Cinema table will store data about the cinema that include: cinema name, and its location as suburb or postcode (you can decide on this based on the APIs you will use in Assignment 3). – One person/user can have multiple movie memories in the Memoir table. -One movie memory can be associated with only one cinema. One cinema can repeated in different memories. -The person/user will have only one memory for a movie experience. It means if the user watches the same movie and in the same cinema, it will create a different experience and memory (the date and time will also be different). b) You will use an appropriate and correct schema based on the above-mentioned requirements and implement the right relationships and choose the right FKs. Provide a simple ER diagram. (2 marks) We strongly recommend using a unique ID for each table as the PK because it makes it easy when working with NetBeans RESTful web services. c) All the tables need to be populated with meaningful data and appropriate data types. (2 marks) You need to have at least 3 records in the user person and credentials tables. In Assignment 3 (practical assignment Phase 2), you will automatically generate the latitude and longitude values from the user person’s full address data so make sure you enter correct and real world values. To populate the credential table, you can use an online hash converter to convert a password to hash values but in Practical Assignment (client-side), you will hash the password using Java code and libraries. In the memoir table, you need to include at least 10 records/memories for one of the users. In the cinema table, you will enter at least 5 cinemas. You need to make sure you enter such data that all the queries in Task 4 will return data (not an empty response. 4 You need to provide the SQL code for creating and populating EACH table (and code for establishing FK constraints or any other constraints) and a simple ER diagram in your submitted report document to receive marks for this Task. Any missing or incomplete SQL code or an ER diagram as specified will result in mark deduction. Task 2 – RESTful Web Service (5 marks) A RESTful web service should be created based on the above-mentioned database and tested on the browser without any error. (5 marks) For this part, you need to test the web service and provide one screenshot showing all methods as the figure below. On the left-hand side, you need to expand all the folders and show their contents. Figure 2. An example of the browser screenshot Task 3 – Dynamic and Static Queries (20 marks) In this part, the web service will be extended by adding extra methods and queries using the Java Persistence Query Language (JPQL). The queries that you write will apply two different approaches as discussed in the lectures a
nd tutorials: one approach where you define a static query (NamedQuery) in Entity class and then you call it from a RESTFacade’s method, and the other approach where you create a dynamic query directly in a RESTFacade’s method. a) You will write additional REST methods to query all the tables based on each attribute that the table has. E.g. if the user Person table has 6 attributes, you write 6 REST methods to query each attribute separately. This excludes the method to query the primary key (id) because it is automatically generated. For this task, provide all the code BUT only one screenshot for one of the REST methods for each table. (5 marks) b) You need to create a new REST method that enables querying the user Person table using a combination of three attributes (e.g. address, state and postcode). This should be implemented as a DYNAMIC query. You will decide which attributes to consider based on their usefulness in the query. (5 marks) 5 c) You will write a new REST method that enables querying the memoir and the cinema tables using a combination of two attributes in the condition where each attribute is from a different table. The query should be a DYNAMIC query using an IMPLICIT join. (5 marks) d) You will write a new REST method that enables querying the memoir and the cinema tables using a combination of two attributes in the condition where each attribute is from a different table. The query should be a STATIC query using an IMPLICIT JOIN. For this, you also need to show the code for the NamedQuery in the entity class. (5 marks) For this part, you need to provide your written code for the REST methods (by copying and pasting it from NetBeans), any code added to the Entity classes, and one screenshot per each method after testing on the browser. Any missing code or screenshot will result in mark deduction. In subtask Task 3 (a), only one screenshot of one GET method for each table is sufficient but provide all the code. Task 4 – Advanced REST methods (60 marks) a) You will add a REST method that will accept a user person id, a starting date and an ending date and return a list that contains the cinema’s suburbs/postcodes and the total number of movies watched per suburb/postcode during that period. (10 marks) b) You will add a REST method that will accept a user person id and a year, and return a list that contains the month names and the total number of movies watched per month in that year. (10 marks) c) You will add a REST method that will accept a user person id and return the name(s), the rating score(s) and release date(s) of the movie(s) with the highest rating score given by that user. Please note that the result can be a list if more than one movie received the same score. (10 marks) d) You will add a REST method that will accept a user person id and return a list of movie names and their release years for those movies that their release year is the same as the year the user watched them. E.g. if a movie was released in 2020 and the user watched it in 2020. (10 marks) e) You will add a REST method that will accept a user person id and return a list of movie names and their release years for those movies that the user has watched their remakes as well. E.g. If the user watched The Lion King 2019 and The Lion King 1994. (10 marks) f) You will add a REST method that will accept a user person id and return a list of the movie names, their release dates and rating scores for FIVE movies that have been released in the recent year and have the highest rating score (five top ones). (10 marks) For Task 4 and 5, you need to provide all the code of new REST methods, and any code added to the entity files (and any other additional code/class you added) to receive full marks for this part. You also need to test the web service and provide ONE screenshot for each new method. Any missing or incomplete code or the screenshot will result in mark deduction. Late Submission: Late Assignments or extensions will not be accepted unless you submit a special consideration form and provide valid documentation such as a medical certificate prior to the submission deadline (NOT after). Otherwise, there will be a 5% penalty per day including weekends. Submission Guideline: A ZIP file will be uploaded to Moodle by the deadline including the following files: 6 1. The REPORT with all the specified code and screenshots that were mentioned in each task in ONE word/pdf report document, NOT as separate image files. 2. The NetBeans project including all the packages and classes and files. 3. The zip file should have this name: FIT5046Assign1-Sem1-[studentname]-[studentid]- [tutor name].zip Mark Deduction will be applied if: i) any piece of code or screenshot for each Task is missing, ii) the REPORT does not follow the above-mentioned format, or iii) if any of the NetBeans project files is missing and not included in the zip file PLEASE NOTE. Plagiarism and Collusion Before submitting your assignment, please make sure that you haven’t breached the University plagiarism and cheating policy. It is the student’s responsibility to make themselves familiar with the contents of these documents. Please also note the following from the Plagiarism Procedures of Monash, available at http://www.policy.monash.edu/policy-bank/academic/education/conduct/plagiarism-procedures.html Collusion occurs when a student works with others to produce work, which is then presented as the student’s own work, or the work of the other person(s). Collusion includes when a student without the authorisation of staff involved in the teaching of a unit: works with one or more people to prepare and produce work; allows others to copy their work or shares their answer to an assessment task; allows someone else to write (with the exception of instances where the use of a scribe is approved by the Disability Liaison Unit) or edit their work (noting that proofreading is acceptable, provided it is compliant with the University’s definition contained in the Academic Integrity Policy); writes or edits work for another student; or offers to complete work or seek payment for completing academic work for other students.
