The complication is not always worth it. As per my experience, normalization does not always mean better performance. It is sometimes better to introduce redundancy to improve performance. But that's...

This doesn't appear to be a task that can be performed with a single SQL if that was what you were looking for. Even if it is possible (because I'm not very good at SQL myself), the query itself is...

Yeah, it's not in 3NF. I thought it was obvious with the example on the Wikipedia link. It's similar to your own example.

cities (cityID, cityName)
districts (districtID, cityID, districtName)...

The first approach is the logical thing for a database design. Having a lot of data is not a consideration while designing a database. The essence of a database design is to model generic entities...

Could you please wrap your code with [code] tags the next time you post it?

Google can

@AWDracer: I believe you quoted the wrong post. ;)

You should visit the Microsoft's website and check for the system requirements. If you are close to the minimum system requirements specified there, it's time to upgrade the system or consider a...

You need to have an Ant task which would compile, build and deploy your web application to Tomcat. JCreator internally makes use of an Ant build file, which is a simple XML. You could edit it to add...