[Solved]Introduction Answer Following Questions Q1 Construct Erd Model Least 15 Tables Given Case Q37243477
Introduction
Answer the following questions
Q1. Construct an ERD model of at least (15 tables) from thegiven case below
Forest Harvesting Information System
_______________________________Case_______________________________
Harvesting a forest involves a constant process of movingresources to places in the forest to cut down trees, load them andthen transport them to variety of organisations such as sawmillswhich transform the raw logs into a wide variety of products orsent directly to ports from where the raw logs are shipped tooverseas markets.
This process for, one logging company, is managed by a controlcentre from which trucks, loaders and crews are dispatched. Thepeople who do this are dispatchers.
Each forest is divided into sub-areas to varying levels ofdetail. For example, ForestA/1/4/8 or ForestB/26. Within theseareas alongside roads are dumps (D1, D2, etc) which is where thecrews bring the logs as they cut. At any time, each dump will havea stock of logs which have been categorised into a number ofgrades. Loaders are sent to the dumps to load trucks which do nothave cranes. Trucks may also carry other specialised equipmentwhich is regarded as part of the truck.
Customers place orders for specific numbers of logs of specificgrades 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 ofdata making continuous and rapid decisions based on constantlychanging circumstances.
The current computer system they use is old and cumbersome andthey have asked for a design proposal which will allow them tooptimise their operations. The forestry company has heard ofHoloLens and see this as potentially central to a new system.
Expert Answer
Answer to Introduction Answer the following questions Q1. Construct an ERD model of at least (15 tables) from the given case below… . . .
OR
