[For reference, please see the attached file].
The database will be SQL Server 2012. The Server OS will be Windows 2012. ESRI's ArcGIS for Server 10.3 will be the GIS Server.
The challenge before me is to enable non-technical staff to Add a building to the enterprise geodatabase and then add individual Rooms for that Building, and Floor Plans for that Buildings for each Floor of that Building.
Solution 1: I foresee a web-based solution as better: A 'wizard' which would guide the users through adding data through online forms. Not a problem. But the problem is Spatial data. Specifically, how can each Building's polygon be made into the Building's table in a web interface? The users could have an ArcMAP document where they could draw the Polygon but how could that be sent to the data's correct field? Maybe some python script?
Solution 2: ArcMAP based solution: There can be two MXDs/Building. Each MXD can have all the Rooms (or Floor Plans) data for a specific building. So these two MXDs would cover all the required data for a Building. There can also be an additional field called 'Building_ID' with hard-coded value for a Building (which would exist in another table in the geodatabase). This is the current solution in a 'Pilot' project and kind of works: Each of the two MXDs get Published to the GIS Server--through an interface with SQL Server (ArcSDE). However, this is not a true relational database.
Let me add that I may be completely off or maybe over-complicating matters. I thought a wizard based approach would be better but am more than willing to listen to other ideas.