2022/23 - This essay covers DISTINCTION level work for Unit 5: Data Modelling - Assignment 1 - Learning Aim A.
To complete your assingment in the quickest time use the NAVIGATION PANE in Word to follow my layout in order to achieve any grade. (Pass, Merit & Distinction).
All of the following...
Hi Mialyons,
I hope I have helped you clear up any confusion you had with your brief.
If you need anymore help please message me directly again.
Thanks,
Joshua Hall
By: sultandurrani9994 • 1 year ago
By: saadilyas • 1 year ago
Seller
Follow
JoshuaHall
Reviews received
Content preview
Joshua Hall Assignment 1 – Learning Aim A Unit 5 – 2022
Table of Contents
Unit 5 – Data Modelling...............................................................................................................................3
How the Current Model Reflects the Scenario......................................................................................19
Decisions using the Model.....................................................................................................................19
Data Model Improvements....................................................................................................................20
Other Factors.........................................................................................................................................21
Documenting and Justifying Decisions.......................................................................................................21
Summarizing the situation.....................................................................................................................21
Identifying the Information Sources......................................................................................................22
In this assignment, I will be investigating the process of the decision-making process for data modelling.
Therefore, I will first explain the stages in the decision-making process along with others such as
spreadsheet features, considering alternatives, evaluating models and being able to provide
documentation and justifications of the models.
Before you can start designing or creating a spreadsheet for your clients you first need to know what
data modelling is and how it can be applied correctly in fulfilling your client’s needs. Data modelling is
used to help create and consider alternative choices when your client has given you certain tasks that
they would like completed.
Data modelling is the process of creating a visual representation of either a whole information system or
parts of it to communicate connections between data points and structures. The goal is to illustrate the
types of data used and stored within the system, the relationships among these data types, the ways the
data can be grouped and organized and its formats and attributes.
3|Page
, Joshua Hall Assignment 1 – Learning Aim A Unit 5 – 2022
Stages in Decision Making Process
Understanding the Scenario
First of all, you need to understand the scenario that the data model is going to be applied to. If you do
not understand the scenario, then you will not be able to create an effective data model as you will not
understand where it going to be applied to. This would be a problem for the client as the data model will
not be fully optimized to run their scenario as it was created by someone who does not fully understand
what they were creating it for. You need to know the reason as to why this data model is being created.
These reasons will include who wants the data model, why they need it and what they would like to
show from it. By understanding these points and knowing the scenario this will allow you to create a
spreadsheet which will be used to its full extent.
This means that if you make a spreadsheet which allows them to see what is likely to happen from each
possible alternative and in the end showing them the best result that the client will be happy with. If the
client wants, you to create a spreadsheet to decide then price of a newly released product. This
spreadsheet would need to cover the wide range of topics such as how many items have been made,
how many will be sold, the total cost of creating the product, and the profit wanted from the product. If
you understand the scenario to its fullest extent, it will allow you to create the spreadsheet with much
more detail and the customer will be much happier as it will fulfil their needs.
Identifying Information and Sources
All data models need information so by this point in your decision-making process you should know
where the information you will be using will come from and if it is reliable information that you can use.
4|Page
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through EFT, credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying this summary from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller JoshuaHall. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy this summary for R214,46. You're not tied to anything after your purchase.
