Glad to hear the Roger Carlson tutorials were helpful.They are meant to teach you how to break down a business issue/processes into meaningful pieces and to structure a datamodel using database normalization techniques.
The intricacies you mention are part of the details. In my view that is another level and the solution(s) may be very different for different situations. The tutorials are for concepts and come with problem definition and solutions.

What exactly is your current status?
Have you fleshed out the requirement so that there is minimal uncertainty?
Have you vetted your model with sample data? Have you mocked up reports forgetting data from the database? And mocked up screens/form for getting data into your tables? Have you determined any logical concerns that have to be addressed? You mentioned that "an order may have many types of fruit".



Again, and you know this, readers do not know your situation/environment/requirement as well as you. So if and when you ask for focused help/guidance, you have to provide sufficient context. Members may be working with 5 or 6 posters. They are trying to offer the best advice they can, and given the number of concurrent tasks/sessions, it can be difficult to stay focused.

There is an old saying -
It's hard to remember your task is to drain the swamp when you're up to your waist in alligators.