e Assessment 5 Database management systems on cloud CSE2DCX Database Fundamentals on the Cloud CSE2DCX – Assessment 5 2 Before you begin Objectives This is an individual assignment. Students are not...

this is a rather complicated one if you need more details or cant do certain parts please let me know all the details for it are in the attached file


e Assessment 5 Database management systems on cloud CSE2DCX Database Fundamentals on the Cloud CSE2DCX – Assessment 5 2 Before you begin Objectives This is an individual assignment. Students are not permitted to work in a group when writing this assignment. Copying and Plagiarism This is an individual assignment. Students are not permitted to work in a group when writing this assignment. Plagiarism is the submission of another person’s work in a manner that gives the impression that the work is their own. La Trobe University treats plagiarism seriously. When detected, penalties are strictly imposed. Further information can be found on http://www.latrobe.edu.au/students/academic- integrity/explanation/plagiarism Submission Guidelines Your assignment submission should be typed, not written/drawn by hand. Submit the electronic copy of your assignment through the subject LMS. Submission after the deadline will incur a penalty of 5% of the available assignment mark per day capped at 5 days. No assignment will be accepted after 5 days. If you have encountered difficulties that lead to late submission or no submission, you should apply for special consideration. CSE2DCX – Assessment 5 2019 Edition 3 Possible Research Topics As part of this subject you learned about creating and working with relational database on the Amazon cloud. However, it is not the only cloud provider to offer such services. In this assignment, you are required to produce a research report on the alternatives i.e. other cloud-based database solutions. Select one of the following topics: 1. Microsoft Azure 2. Google Cloud Services 3. Oracle Cloud 4. IBM cloud databases You may select an alternative topic (not on the list above) but only with the approval of your lecturer. You need to get the approval in writing after discussing the topic with your lecturer and submit that together with your assignment. All research reports should conform to the following basic requirements. • Include a cover page with your student details. • Include the following three sections in your report: 1. Introduction to cloud database provider 2. Creating a cloud database 3. Working with the cloud database Introduction section will be used to describe the cloud provider you chose, and the RDBMS resources it offers. Include details about the reasons behind your selection, and the advantages/disadvantages of using the selected provider. The “Creating a cloud database” section will include information about creating a database on the selected cloud provider. You can access the Microsoft Azure through the Learning Portal; go to “Forms and Links” and click on the link under “Microsoft Azure Dev Tools for teaching”. While the other cloud providers could be accessed through their free trials. Include screenshots for all the steps including creating account (not need to this for Azure), accessing account, creating database etc. In “Working with the database” section, you will be running queries on the newly created database. For this task you will run 4 queries on the newly created database. These would be a create table query, inserting data into the newly created table, selecting data from the table, and displaying all information about all tables in the database (data dictionary). You can use tasks in assessment 3 as an inspiration or can come up with your own table and data. You should remember that every database is different, and your responses may need a little tweaking. For instance, the task about data dictionary might require a different response. Make sure that you run all the queries and provide screenshot for each output. • Include screenshots for sections 2 and 3. • You can optionally include appendices if they are not excessive. • Include references where necessary. • Strict minimum of 1,100 words and strict maximum of 2,000 words, excluding any appendices and bibliogrpy. Marks will be deducted for not meeting this requirement. Please read the marking criteria on the next page for understanding the core requirements of this assessment task. CSE2DCX – Assessment 5 4 Submitting your Assignment When you have completed your answers, submit the assessment on the Learning Portal. You should submit the following: • Submit your report in a document called xxx_cse2dcx_assessment5.docx (where xxx is your student number). Marking Criteria Marking Rubric Criteria Description Marks 1 Section 1 (Introduction to cloud database provider). 6 2 Section 2 (Creating a cloud database). 4 3 Section 3 (Working with the cloud database). 9 4 Quality of writing. 6 TOTAL 25 Criteria Marks Description Total 1 6 Section 1 of the report was satisfactory. 6 4 Section 1 of the report needs minor improvements. 2 Section 1 of the report needs major improvements. 0 Section 1 of the report was unsatisfactory. 2 4 Section 2 of the report was satisfactory. 4 3 Section 2 of the report needs minor improvements. 2 Section of the report was partially correct. 1 Section 2 of the report needs major improvements. 0 Section 2 of the report was unsatisfactory. 3 9 Section 3 of the report was satisfactory. 9 6 Section 3 of the report needs minor improvements. 3 Section 3 of the report needs major improvements. 0 Section 3 of the report was unsatisfactory. 4 6 Quality of writing was satisfactory. 6 4 Quality of writing needs minor improvements. 2 Quality of writing needs major improvements. 0 Quality of writing was unsatisfactory. TOTAL 25 CSE2DCX – Assessment 5 2019 Edition 5