How to store the land Area with Unit and covered Area with U

Mark Tabor

I am designing a simple Real Estate Management System , in which I have a page for posting new property Adds for this I have two Columns in my Form like below

I have a landArea with Units and Covered Area with Units How to save this information into the Database for LandArea I have textbox and for Unit I already have a dropdown list like Squaremeter,Kanal,Marla should i save both the information in one column like 10_LandArea_with_Unit_MARLA ,My Question is how to store Plot/Land Area and Unit in database should i use one column for both or two columns and same is the case with Covered area ,

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mangesh G9y ago
Welcome mark If u are good with my answers mark them as approved please Thanks
0
Mark Tabor9y ago
Thanks
Mangesh Gaherwar For your time and support
0
Mangesh G9y ago
Yes mark that's how it should be as there is a major possiblilty that units will be different for them. So it's good idea to save them differently
0
Mark Tabor9y ago
I understand that you said for Unit I should have a master table ok I agreed
for Unit I have a standalone master table like below

ID Measure_Name
1 Marla
2 Kanal
now My question is that as i shared a picture with you while posting the property I have to save Land Area with Unit and Covered Area with Unit ,
So as per your suggestion I should have just three columns
1-Land_Area 2-Covered Area 3-Unit{unit comes from Master table}
So If I have Different Unit for Covered Area and Different Unit for Land_Area then how to save it ,
for this i think I should have four columns 1- Land_Area ,2- Unit_For_Land_Area
3-Covered _Area 4-Unit_For_Covered_ARea
M i right
0
Mangesh G9y ago
Hey Mark what Method I will Follow is the Every DropDown Must be from the Master table so Make the Unit a master table an just Reference them in Your Table So How Your Table shud Be that U will need 2 columns storing the UnitOfLandArea and UnitOfCoveredArea It will have reference from the Master Table so next time when U want to show the things U will be able to show them easily If you can share the dB structure that will be helpful here...
0

ID	Measure_Name
1	Marla
2	Kanal

How to store the land Area with Unit and covered Area with U

Mangesh Gaherwar For your time and support