2006-193B. - Laserfiche WebLink

Home Browse Search

eLogical Database Design Methodology The Logical Database Design should consist of four parts : 1 . Kickoff Meeting 2. Existing data acquisition and review 3. Interviews 4. Logical Database Design Kickoff Meeting Kickoff meeting attendees should include all Indian River County personnel that currently or will in the future: • Create spatial data • Provide input on the creation , updating or use of spatial data • Use spatial data on a regular basis . The kickoff meeting should introduce the goals and objectives of this project, outline how the project will be conducted , and inform attendees of what will be required of each them . Existing Data Acquisition and Review Before the Logical Database Design process can move forward , Indian River County will need to ensure that if has a copy of all existing County data layers and source data from each department that will be included in the database design . Interviews All pertinent staff members from each County department/division should be interviewed . Interviews can be conducted separately for each department, or in logical groupings . The goal of each interview is to discuss in detail each data layer for which attendees are the Subject Matter Expert . Issues that should be discussed include : Deletion of existing attribute fields w0 Addition of new attribute fields • Allowable values for important attribute fields • Relationship of layer to other layers • Associated tables and cardinality • Description or alias of each field (when not obvious) • Subtypes • Default values • Whether null values are allowed or not • Indexes Several important metadata aspects ( not documented or available from the earlier existing data acquisition ) to include ( but not limited to) should be documented , including : • Feature Class Name • Feature Class Type ( point, line , polygon or raster) Feature Dataset • Description • Purpose • Data source 54 GIS Needs Assessment and Implementation Plan Chapter 5 - Database Design and Setup