SIT772: Database and Information Retrieval Report Writing - IT Assignment Help

Assignment Task:

Task:

Learning Outcomes
This assessment assesses the following Unit Learning Outcomes (ULO) and related Graduate Learning Outcomes (GLO):
Unit Learning Outcome (ULO) Graduate Learning Outcome (GLO)
ULO 5: Demonstrate data retrieval skills in the context of a data processing system.

GLO 1: Discipline-specific knowledge and capabilities

ULO 2: Explain the concept of data modelling and use Entity-Relationship (ER) models to represent data.

GLO 1: Discipline-specific knowledge and capabilities

ULO 3: Design and implement relational database systems through the use of SQL

GLO 1: Discipline-specific knowledge and capabilities
GLO 4: Critical thinking

Purpose
This task evaluates the student's technical skills in the management of unstructured data, with potential usage in real applications. This assessment supports student understandings of the techniques related to unstructured data management and data processing Instructions and Submission Guide
This is an individual assessment task. Students are required to submit ONE written report.
• Read these instructions and the following questions.
• ONE written report with the name as using student ID_givenname_A2.pdf, e.g., 123456_Kevin_A2.pdf
• The report must be submitted via CloudDeakin assessment portal. The wrong submission venue or the wrong submitted file may lead to the penalty.

Part A

In the first part of this assignment, you are required to design and implement database from given user story by applying the concept that you have learnt in this unit. Use LucidChart to sketch detail ERD, normalize the relations and create physical database using SQL queries, followed by insertion of small data (at least 6 records in each table).
You are required to provide complete documentation such as Requirements to ERD (entity selection), ERD, Step by step Normalization to 3rd NF, database.sql and mydata.sql.

Question 1: [20 Marks]
Application Description: Suppose there is one bank company – Commonwealth that requires to develop a relational database. The daily duty is to serve their customers managing their saving bank accounts, e.g., withdraw, deposit, etc. Additionally, the company Commonwealth also makes business for the home loan marketing, e.g., a customer may have a home loan account. To set up a home loan account for a customer, there are several information to be collected and recorded: (1) the customer needs to specify a property address; (2) a bank staff needs to be assigned to process the home loan application; (3) the property value should be assessed by using the average of the sold price of the properties located in the same suburb.

Note: suppose there are sold properties in every suburbs; (4) Each customer has their own home loan max limit that is calculated by his/her 10 years annual salary plus 0.65*property value plus customer savings (amount in his accounts): Note: property value is based on avg sold price of that suburb.

Note: In general, the bank company used 10 years’ salary to estimate, e.g., if the customer Kevin has annual income $60,000, then his home loan limit cannot exceed $600,000. For the customers having multiple home loans, their total home load amount cannot exceed the customers’ home loan limit; (5) a customer may have more than one home loan because multiple properties can be bought by one customer.

This SIT772: IT Assignment has been solved by our IT Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.