MSGIS Portfolio

Method and Result:The datasets include spatial data like schools, parks, and streets. Non-spatial data like staff for businesses, schools, and public buildings. There were three types of data: polygon, line, and point. The first part of the project was to focus on design conceptual model, there were fourteen given entities, and seven additional entities should be considered for the imaginary city, each entities should identify one primary key attribute and two potential attributes. The second part of the project was to develop a relational data model to show the structure of the database use software DBDesigner. For each relation should identify the primary key attribute and candinality of relationship. Add three more attributes for each entity, and define all attributes' type. The third part of the project was to create an object-oriented database model to more closely mimic the object-relational structure of the Arc geodatabase. The model should includes associations between all classes, association cardinality on all associations, method for each attribute, and dependency indicator. The fourth part of the project was to implement database design for the imaginary city by using ArcGIS server database. Create all of the feature classes and relationships, each feature class should have six attributes. And create a map of the imaginary city.