QUOTE
Sin
You said that God is almighty and knows everything. He rules over time and space. If all this applies then He must have realized the sinning from the beginning.

So why he offered the snake and the apple to Adam and Eve? He must have known that they will fail. He created them. He could have made them robust against sin. He could have made them that way that they dislike forbidden apples and don't want to talk with snakes.

But he did not. So the sin must have been an initial part of his design.
/QUOTE

Well that's one way to look at it, if you must.

The way I see it is that we were made in the image of our creator.
Among other things, this meant we would have a strong desire to create
as he does, and in order to do that effectively we would need to have free will.

Those two characteristics would enable us to extend the garden to cover the earth. However, in doing that he did not relinquish authority to decide what is good and what is bad to us. Obedience to the restriction signified our acceptance of his authority. Taking the forbidden fruit is our attempt at usurping Gods authority. The disatrous results of that usurption are obvious to anyone who wants to look at the world realistically.

I know this is not scientific....but neither is the question.