Peer review on design 15

Contents Time planning 3 Design 4 Nature of the problem 4 Functions the model must perform 4 Required inputs and validations 5 Sheets in the data model 6 Diagrams of sheets 8 User interface and navigation 12 Constraints 13

Success criteria: 14

Peer review on design 15 Changes made on the design based on feedback 20 Justifying decisions made for the design and how it fulfils its purpose and clients requirements 24 Peer review of data model 27 Email responses 27 Form responses 28 Positive feedback 28 Negative/suggestive feedback 31 Changes and optimisation based of peer feedback 33 Before optimisation 37 After optimisation 38 1 / 4

Testing 39 Testing- functions 39 Testing - formulas and calculations 40 Testing - user interface 42 Testing - validation/verification/formatting 43 Evaluation of data model 44 Evaluation of demonstration of individual responsibility and self management. 47 Time management 47 How well did I manage my time? 48

• / 4

Time planning

Task Description Planned duration Planned start/end data 1.0 Functional specification Create initial design for the data model

• days 11/06/2022-

13/06/2022

1.1 Design peer review Get people to view and give feedback on review

• day 14/06/2022-

14/06/2022

1.2 Act on design feedback Change design based on the feedback received

• day 15/06/2022-

15/06/2022

2.0 Data model Create the initial data model

• days 15/06/2022-

17/06/2022

2.1Data model peer review Get people to view, use and review data model

• day 17/06/2022-

17/06/2022

Act of data model feedback Make changes and optimisations based on feedback

• day 17/06/2022-

17/06/2022

3.0 Data model evaluation Evaluate the data model; requirements, usability etc.

• day 17/06/2022-

17/06/2022

• / 4

Design

Nature of the problem

A company, who import cheeses from France and the Netherlands, and supply restaurants/specialist delicatessens in the UK want data models created. This is because they are impacted by the fluctuations in exchange rates, on the Euro and the Sterling; they buy in Euro (France and Netherlands currency) and sell in Sterling(UK’s currency).The company’s products are relatively expensive and sell better when economic growth is good and worse when it is bad.

When the exchange rate increases the company could decrease their margin so their product sells for the same price which would lower profit margins; this would improve customers' view of the company's reliability and consistency meaning it would be probable for their number of sales to be similar to before the rate increase; or the company could increase the prices of their cheese products which would keep the profit margins the same, but would likely decrease their sales.

The company has found a trend using a base exchange rate of 0.7 between the Euro and Sterling; It shows that increasing and decreasing the sale prices, based on if the exchange rate goes above or below said base rate, decreases or increases unit sales (20 units increase/decrease in sales, per 10p increase/decrease in sale price).

This means that the data found from this trend can be used as a constant when used in the data model and its formulas.

Functions the model must perform.

Menu

● The function of a working menu must be implemented to make it easy for the user to be able to navigate through the data model.● Every button must work and take the user the correct page, from every page; and the main menu should be easily accessible.

• / 4