I'm pretty new to Arcmap and I am struggling with finding a way to add more structure to how my spatial data is being stored and attempting to design and run reports on it. I would like to add some database relationship features to each feature class I'm storing in a file geodatabase. Basically, I have many feature classes that have same geography or parcel. Each parcel will have many different feature classes within a given year. I was thinking I would have a parcel owner table, a parcel table (since a given owner may own multiple parcels, and a feature class table (to match a parcel to many feature classes stored for that parcel). All of this would help me design and run reports on a given parcel.
So my question is how I should do this? Should I create a sql server database for these tables or just a file geodatabase? I will need an easy way to enter parcel owner and name easily for each new feature class. Will it be easy enough to keep a separate non-spatial sql server database with this metadata and simply reference both this and the spatial feature classes that would be stored in a separate file geodatabase? I only have a arcview license at this point, so I won't be able to SDE.
Any advice here would be appreciated.
