UNIT 5 DATA MODELLING
Assignment 2 & 3
Awais Mustafa
11186970
,Table of Contents
Introduction:.............................................................................................2
P3: Produce designs for a data model which meet client requirements.
..............................................................................................................3
P4: Review the design with others, to identify and inform
improvements.....................................................................................30
P5: Develop a data model to meet Client Requirements:....................49
P6: Test the data model for correctness, functionality and acceptance.
............................................................................................................69
P7: Review the extent to which the data model meets client
requirements.......................................................................................78
M2: Justify decisions made, showing how the design will fulfil its
purpose and client requirements........................................................82
M3: Optimise the data model to meet client requirements:................89
D2: Evaluate the design and optimised data model against client
requirements.......................................................................................96
D3: Demonstrate individual responsibility, creativity, and effective
self-management in the design, development and review of a data
model................................................................................................102
,Introduction:
The company I am working in specialise in importing a different range of
cheeses from two different countries which are as the Netherlands and
France. There are various challenges which the company I work for face.
The first challenge is because of currency, more specifically the currency
exchange rate fluctuations. This is due to the euro that the cheese is
purchased in from these countries and the pound rate that the cheese is
sold in within the United Kingdom. Another challenge the company faces
is the economic growth. This is because the cheese sells well in places
when the economy growth is good and sells less when the economy
growth is poor. My manager has asked me to design and create a
spreadsheet which will hold the company to predict impact that the
company may potentially have on their profit margins due to the
exchange rate fluctuations. Within this report, I will design the
spreadsheet model, review the spreadsheet design model, implement and
build the spreadsheet model and then finally analyse the spreadsheet
model overall.
, P3: Produce designs for a data model which meet client
requirements.
Functional Specification- Nature of the problem:
The main problem which the company are suffering from is the exchange
rate fluctuations. This is because of the euros the company purchase the
cheese in, and the pound which they sell it in. Another problem which the
company is suffering from is the economy growth. This is because certain
cheeses sell better in places where economy growth is good and sell less
where economy growth is poor. I have been asked to produce a data
model spreadsheet by my manager. The data model spreadsheet I create
needs to be able to help the company/manager to be able to see the
impact that the exchange rate fluctuations have on the overall profit
margin of the company. The data model spreadsheet I create also needs
to be able to be used the employees who are not experts in using
spreadsheets and the employees should also be able to change the
margin and the prices within the data model spreadsheet.
Functional specification- Functions the model must perform:
There are various functions which the data model spreadsheet must be
able to perform. Below I have stated the functions which the data model
spreadsheet needs to be able to perform in order to meet client
requirements.
Function 1: Calculate profit.
The first function that the data model spreadsheet needs to be able to
perform is to calculate the total profit. Expanding on this, the data model
spreadsheet needs to be able to calculate the price of each of the
different cheese in euros and then the price of the cheeses in pounds
(which they will be sold in), and then be able to calculate the total profit
the company will be able to make helping them to see the total profit
margin they will make.
Function 2: Select various cheese types.
The second function that the data model spreadsheets needs to be able to
perform is that the user who is using the spreadsheet needs to be able to
choose a variety of cheeses to calculate total profit and effect on margin
for each of the cheese and also be able to view the cost of these cheeses
in euros and pounds etc. The main cheeses that the user using the
Assignment 2 & 3
Awais Mustafa
11186970
,Table of Contents
Introduction:.............................................................................................2
P3: Produce designs for a data model which meet client requirements.
..............................................................................................................3
P4: Review the design with others, to identify and inform
improvements.....................................................................................30
P5: Develop a data model to meet Client Requirements:....................49
P6: Test the data model for correctness, functionality and acceptance.
............................................................................................................69
P7: Review the extent to which the data model meets client
requirements.......................................................................................78
M2: Justify decisions made, showing how the design will fulfil its
purpose and client requirements........................................................82
M3: Optimise the data model to meet client requirements:................89
D2: Evaluate the design and optimised data model against client
requirements.......................................................................................96
D3: Demonstrate individual responsibility, creativity, and effective
self-management in the design, development and review of a data
model................................................................................................102
,Introduction:
The company I am working in specialise in importing a different range of
cheeses from two different countries which are as the Netherlands and
France. There are various challenges which the company I work for face.
The first challenge is because of currency, more specifically the currency
exchange rate fluctuations. This is due to the euro that the cheese is
purchased in from these countries and the pound rate that the cheese is
sold in within the United Kingdom. Another challenge the company faces
is the economic growth. This is because the cheese sells well in places
when the economy growth is good and sells less when the economy
growth is poor. My manager has asked me to design and create a
spreadsheet which will hold the company to predict impact that the
company may potentially have on their profit margins due to the
exchange rate fluctuations. Within this report, I will design the
spreadsheet model, review the spreadsheet design model, implement and
build the spreadsheet model and then finally analyse the spreadsheet
model overall.
, P3: Produce designs for a data model which meet client
requirements.
Functional Specification- Nature of the problem:
The main problem which the company are suffering from is the exchange
rate fluctuations. This is because of the euros the company purchase the
cheese in, and the pound which they sell it in. Another problem which the
company is suffering from is the economy growth. This is because certain
cheeses sell better in places where economy growth is good and sell less
where economy growth is poor. I have been asked to produce a data
model spreadsheet by my manager. The data model spreadsheet I create
needs to be able to help the company/manager to be able to see the
impact that the exchange rate fluctuations have on the overall profit
margin of the company. The data model spreadsheet I create also needs
to be able to be used the employees who are not experts in using
spreadsheets and the employees should also be able to change the
margin and the prices within the data model spreadsheet.
Functional specification- Functions the model must perform:
There are various functions which the data model spreadsheet must be
able to perform. Below I have stated the functions which the data model
spreadsheet needs to be able to perform in order to meet client
requirements.
Function 1: Calculate profit.
The first function that the data model spreadsheet needs to be able to
perform is to calculate the total profit. Expanding on this, the data model
spreadsheet needs to be able to calculate the price of each of the
different cheese in euros and then the price of the cheeses in pounds
(which they will be sold in), and then be able to calculate the total profit
the company will be able to make helping them to see the total profit
margin they will make.
Function 2: Select various cheese types.
The second function that the data model spreadsheets needs to be able to
perform is that the user who is using the spreadsheet needs to be able to
choose a variety of cheeses to calculate total profit and effect on margin
for each of the cheese and also be able to view the cost of these cheeses
in euros and pounds etc. The main cheeses that the user using the
