Stella Pty. Ltd Case Study - Stella Dataset Header - Business Assignment Help

Assignment Task :

1) Background
In this assignment you are required to demonstrate and apply the concepts and knowledge covered in Week 1 – Week 11. For the purposes of the report, assume that you are employed as a business analyst at Best Innovative Solution (BIS) Pty Ltd. You are assigned to investigate the questions from a new client and provide the solution.
The dataset about Stella Pty. Ltd. has been collected and you are given the following two files for the purpose of applying data analytics:
• dataset (StellaData.xlsx)
• header description (StellaDataset-header-description.txt)
These two files are available for download on Canvas | Assignments | Assessment

Task 1: Individual Final Assessment | Individual Assignment – Case Study, Specifications and Dataset for the purpose of applying data analytics. Further information about the dataset is listed below:
• The dataset and header description are stored in two separate files.
• The dataset consists of binary, categorical and numerical data.
• There are 7 different attributes and 1000 cases (or instances).
• There are some missing values in the dataset.
• The dataset covers mainly on the aspect of customer related data.

2) Questions from new client
You need to provide: (a) answers to all the following questions based on the case study, (b) word count on the cover page of your report.

Question 1 Data Modelling
• Provide an Entity Relationship Diagram (ERD). For each entity, provide at least one attributes/ fields with a maximum of two attributes (excluding primary key).
• Provide a Relational Model and show the most appropriate attributes/ fields, primary keys and foreign keys. In addition, include the data type for each attribute/ field listed in each table/ entity.
• You should apply third normal form (3NF) and show consistency in the use of notation.
• If you discover while drawing the diagrams that the narrative of case study is incomplete, then provide justifications, assumptions, or reasonable explanations to complete the case study along with your diagrams. You could include the justifications, assumptions or reasonable explanations under Appendix section. 

This Business Assignment has been solved by our Business 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.