Planning a database app [closed]

Question

I am in the planning stages of a database app for personal use. I have a good bit of the database structure planned, but as I think about how I'm going to write the program, it made me wonder if I'm doing this in the right order.

Which should I be planning first, the db structure or the classes?

Answer 1

I think designing your data model first is a very good idea.

If the app is to be database driven it is a good idea to have an solid understanding of what your data model is going to look like before even attempting to write any code.

You can still conceptualize how you think the classes may look as your thinking about your data model. Keeping this in the back of your mind as you determine your requirements will help when you begin to write some code as well.

Of course, as you begin to write code you will probably have to revisit your data structure, so it is an iterative process, but good planning at the onset of the project is a good idea.