I need an experienced developers view.
I am working on a simple database for property management.
Maximum records is around eight thousand records.
Fields are the following…
Transfer Date (if any)
Location Number (linked to a map)
Neighborhood Number (eight to ten)
The property, location, and neighborhood numbers are predetermined and already entered into the database and cannot be changed.
So, my question is, working with such a limited number of fields and information would you really consider splitting up the property info from the owner info?
If so, why?
Speed, Convenience, or Planning for the future?
Many Thanks for all input.