I am modeling a simple dictionary application using the presentation-business logic-data layer pattern. I already have the design but am not sure it is correct:
My presentatioon layer is a simple GUI where users insert their queries. They have a form for entering new words and their definitiom and also another form for querying the dictionary. I think this one is OK.
My Business layer is where the trouble starts: I have an Entry class which has the attributes id_number (for queries), word and definition. As for methods it has the standar CRUD operations. It aso has some transformation methods used for formatting the input (removing plurals, removing gramatica genders, etc.) The CRUD methods simply build a query using the attributes available and immediately instantiate a connection class.
The third layer would be the data access layer. The actual SQL pocessing is being carried out here. The previous object simply builds a query but it doesn't run it. This layer has a special class for running SQL after checking server connectiona nd all that stuff.
Is this properly implemented? Should the Entry class rather be in the data layer? If so, what should I punt in the logic layer?
Thanks in advance.