dchaley369

To divide or not, need an experienced developers thoughts

Discussion created by dchaley369 on Dec 26, 2017
Latest reply on Dec 27, 2017 by coherentkris

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…

Property Number

Date Purchased

Transfer Date (if any)

Location Number (linked to a map)

Neighborhood Number (eight to ten)

 

Owner Name

Street

City

Zip

email

phone 1

phone 2

 

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.

 

Chris

Outcomes