I want to design a database for a listing website, this is the first time I design the database, so I am not sure if I in the correct path. Here is the fields that needed in a listing,
- title - Character
- pub_date -Timestamp
- modi_date -Timestamp
- ex_date - Timestamp
- desc - Character
- thumb - Character
- office_no - Integer
- mobile_no - Integer
- email - Character
- web - Character
- status - Character
- state - Character
- city - Character
- address - Character
- postcode - Character
- lat - float
- lng - float
The lat (latitude) and lng (longitude) are used for searching, eg, searching nearby listing by comparing the lat and lng. So these fields will be queried often.
My question is should I separate the lat and lng into another table (normalization) since these fields will be query a lot. Or I just leave it in one table.