$)$ What are the tables you would have for the app to store the following data?

$$ Vegetable, their details, including the prices.

$$ Fruit, their details, including the prices.

$$ Customer, their details, and their order history.

$$ Supplier, their details, and the produce $($fruits and vegetables$)$ they list.

$$ Produce can be supplied by one farmer only; However, a farmer can supply multiple

produce. There will only be only supplier supplying the product at any point in time.

However, the history of suppliers for each produce item must be recorded along with the

date interval.