We want to design a database for a “Smart Urban Farming” system. This would coll

We want to design a database for a “Smart Urban Farming” system. This would collect data from various sensors like soil moisture, temperature, and sunlight, and integrate it with information on plant growth stages, water usage, and fertilizer requirements.
The database could also manage inventory for seeds, tools, and harvests. Users could analyze the data to optimize farming practices, ultimately making urban farming more efficient and sustainable. Consider the following requirements:
The “Smart Urban Farming system” start the monitoring by distribute a different set of sensors in the field where each senor has an id and a location.
Each senor will sense and collect a data depends on its functional categories (Soil sensor, temperature sensor, light sensor, pH sensor).
Each sensor equipped with a sleep mode (Active/ Unactive) property to allow an energy aware scheduling.
The collected data is maintained by the following properties: data id, sensor id, timestamp date, and the sense value.
In the field there are many plants, each is identified by id, a plant name, ideal moisture, ideal temperature, ideal light.
Also, we want to maintain the plants growth stage (Seed, Sprout, Vegetative, Flowering, Fruiting).
All tools, seeds and other resources should be stored in inventory where each inventory quantified by the inventory id, inventory name, quantity, last restocked date.
Each user identified by a user id, a user name, a password, and a role (Supervisor, Farmer).
i want to design EER and ER model (diagrams) and Description of ER Data Model component .

Place this order or similar order and get an amazing discount. USE Discount code “GET20” for 20% discount