Introduction

Using the Case below, imagine that this organisation has asked you, an intern, on the basis of the tools and skills you are learning to advise them on how they can begin to better manage their data in a way that they can become more aware of insights that this data may show them.For instance they really want to be able to see the locations, on a map, of the activities they are tracking at specific times and if possible to see an animation of the movement of all participants over time. So when thinking of queries to create you can think of what queries you would need to create an animation of your sketch.

You only need use the extent of the Case required to satisfy the requirements below.

Answer the following questions

Q1. Sketch(es) of the problem	5
Q2. Construct an information model of at least (15 tables)	20

Forest Harvesting Information System_______________________________Case_______________________________

Harvesting a forest involves a constant process of moving resources to places in the forest to cut down trees, load them and then transport them to variety of organisations such as sawmills which transform the raw logs into a wide variety of products or sent directly to ports from where the raw logs are shipped to overseas markets.

This process for, one logging company, is managed by a control centre from which trucks, loaders and crews are dispatched. The people who do this are dispatchers.

Each forest is divided into sub-areas to varying levels of detail. For example, ForestA/1/4/8 or ForestB/26. Within these areas alongside roads are dumps (D1, D2, etc) which is where the crews bring the logs as they cut. At any time, each dump will have a stock of logs which have been categorised into a number of grades. Loaders are sent to the dumps to load trucks which do not have cranes. Trucks may also carry other specialised equipment which is regarded as part of the truck.

Customers place orders for specific numbers of logs of specific grades to be delivered at specified times.

The job of the dispatchers is to optimise this process. Dispatchers have to be able to manage this large and complex set of data making continuous and rapid decisions based on constantly changing circumstances.

The current computer system they use is old and cumbersome and they have asked for a design proposal which will allow them to optimise their operations. The forestry company has heard of HoloLens and see this as potentially central to a new system.