Logical Design (Relational Data structure) PARCEL ( parcelid , area, blid , use, address, value, pop, ...) OWNERSHIP ( ownerid , parcelid , regdate , CofO_no , tenure) OWNER ( ownerid , oname , sex, bdate , bplace , state, occup , ....) ARC ( arcid , bnode , enode , lparcel , rparcel ) NODE ( nodeid , Xcoord , Ycoord ) LOCALGOV ( LGID , lname , hqrts , ...) DISTRICT ( distid , dname , lgid , ...) BLOCK ( blid , luz, distid ,...) Where Table names are in uppercase and attributes of a table are enclosed in parenthesis with primary keys underlined, and Parcelid = identifier of the parcel e.g. plot number Area = metric area (size) of the parcel Blid = block identifier Use = what the parcel is designed for Address = street address Value = value of parcel Pop = population of inhabitants (zero for nonresidential and vacant plots), Ownerid = identifier of owner e.g. name Regdate = registration date Cofo_no = number of certificate of occupancy Tenure = type of tenure e.g. lease-hold