100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
Previously searched by you
Previously searched by you
logo
2022 BTEC IT Level 3 - DISTINCTION* Unit 5 Learning aim A $12.29
Add to cart
Quickly navigate to
Preview
  2.  
  3. PEARSON (PEARSON)
  4.  
  5. Information Technology 2016/2017 NQF
  6.  
  7. Unit 5 - Data Modelling

Essay

2022 BTEC IT Level 3 - DISTINCTION* Unit 5 Learning aim A

2 reviews
 3 purchases
  • Course
  • Unit 5 - Data Modelling
  • Institution
  • PEARSON (PEARSON)
  • Book
  • BTEC Nationals Information Technology Student Book + Activebook

Deadline? Coursework coming up? No stress! A presentation evaluating the role of data modelling in the decision-making process. Before you can design or create a spreadsheet to meet client requirements, you need to understand what data modelling is and how it is used. This section takes you through...

[Show more]

Preview 9 out of 56  pages

Document information

  • October 4, 2021
  • 56
  • 2021/2022
  • Essay
  • Unknown
  • A+

Subjects

  • unit 5 learning aim a
  • 2021 btec it level 3
  • distinction

Connected book

book image

Book Title:

Author(s):

  • Edition:
  • ISBN:
  • Edition:

Written for

  • BTEC
  • PEARSON (PEARSON)
  • Information Technology 2016/2017 NQF
  • Unit 5 - Data Modelling
All documents for this subject (73)

2  reviews

review-writer-avatar

By: oliverjdb123 • 8 months ago

review-writer-avatar

By: frosty1836 • 3 year ago

Seller

avatar-seller
Courseworks2u

Reviews received

Content preview

Downloaded by: Coursework2U |
Distribution of this document is illegal

,Downloaded by: Coursework2U |
Distribution of this document is illegal

,Downloaded by: Coursework2U |
Distribution of this document is illegal

,Stuvia.co.uk - The Marketplace for Revision Notes & Study Guides




Downloaded by: Coursework2U |
Distribution of this document is illegal

, Stuvia.co.uk - The Marketplace for Revision Notes & Study Guides




Data modelling can be utilised to examine and process information by distinguishing
factors inside the cheese company, identifying links within the data and exploring
various opportunities to improve the cheese company's profits and efficiency.
Business analysts and programmers can use data modelling to build a suitable model
for the cheese company so that it helps the employees to understand and make
relationships between them about the scenario much clearly.
While data modelling takes account of data and features of different types, the data
must be relevant to one another without any disruptions because this will make it as
much sense to the employees when they're examining the data in the cheese
company. Categorising and sorting raw information make the process of interpreting
from the data model much more manageable.

Using data modelling is good as it provides a clear representation of what the
collected data means. This helps to give an overview of what is currently happening,
such as exchange rates and oversight of trends like what cheeses are the most
popular. Data modelling can be applied to conduct Revenue Forecasting, which helps
the cheese company to prepare itself from losing money.

To construct a data model, there should be a minimum of two factors where each




Downloaded by: Coursework2U |
Distribution of this document is illegal

, Stuvia.co.uk - The Marketplace for Revision Notes & Study Guides




factor has its collection of data to be modelled. Modelling data shows how each factor
impacts each other and how one element can be adjusted to change another. For
instance, lowering the price of cheese may increase sales and vice versa.
Conclusion
Overall, data modelling can be employed to provide an apparent overlooking of how
the exchange rate fluctuations can impact the cheese company's profits and supply,
how the company should prepare for weak economic growth also provides a
comparison of current and previous supply and demand of cheeses.




Downloaded by: Coursework2U |
Distribution of this document is illegal

,Stuvia.co.uk - The Marketplace for Revision Notes & Study Guides




Downloaded by: Coursework2U |
Distribution of this document is illegal

, Stuvia.co.uk - The Marketplace for Revision Notes & Study Guides




It's important to realise what information must be required in the first place. Identifying
what information is required helps investigate appropriate and reliable sources from
which data can be gathered or collected.

The data provided in the scenario are that of cheeses from France and the
Netherlands where various restaurants and specialist delicatessens purchase their
cheeses throughout the UK. The cheese company faces several challenges due to
currency exchange rate fluctuations between the Euro, that they buy the cheese in
and the pound that they sell it in and the variations in economic growth which impacts
their business. However, these need to be elaborated upon to grow into complete
data that can be compared against each other.

Benefits
Understanding which data is mandatory can help explore information that has already
been made available. This information can be gathered from reading the scenario
given to create a data model. The inputs can be found from the situation, as well as
the outputs.
In addition, the data model may require additional information from other sources to
find relevant information. To do this, the origins of the collected information must
carefully be examined and referenced to. This can be done via recording the title,
date, author and so forth which are important to avoid plagiarism. Various sources of
information may be found in libraries, newspapers, raw data from interviews or
surveys, and the internet. The reliability and contexts must carefully be looked at to




Downloaded by: Coursework2U |
Distribution of this document is illegal

, Stuvia.co.uk - The Marketplace for Revision Notes & Study Guides




identify false statistics or invalid information. Examining the current scenario on
what is required about the suppliers, currency rate fluctuations and how much
demand is all-important to consider where the information comes from. The Internet
is fine to check currency rate fluctuations, but the cheese company must use its
data to consider supply and demand.

Drawbacks
The currency of the data affects its accuracy. What was true many years ago may not
be true today. The older the information, the less likely it is that it is relevant but there
are exemptions as long as the information is checked thoroughly to see that it's still
valid.

Conclusion
The decisions the cheese company takes can affect them both positively and
negatively since they need to make sure that they source all their information from
reliable sources to avoid making the wrong decision.
Also, to make the data model to be valid the cheese company must verify that all
the information used is reliable and correct.




Downloaded by: Coursework2U |
Distribution of this document is illegal

The benefits of buying summaries with Stuvia:

Guaranteed quality through customer reviews

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

Quick and easy check-out

You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.

Focus on what matters

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 these notes from?

Stuvia is a marketplace, so you are not buying this document from us, but from seller Courseworks2u. Stuvia facilitates payment to the seller.

Will I be stuck with a subscription?

No, you only buy these notes for $12.29. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

65630 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy study notes for 15 years now

Start selling
$12.29  3x  sold
  • (2)
Add to cart
Added