Laserfiche WebLink
<br />DEe 1~ l~~b U~:~l <br /> <br />!:II V ~JRn:f-( ~t:..'=.uu~u:.s <br /> <br />JCJ-.J t:lJ::,b ..:'~~=' r. Q (' J...... <br /> <br />Task R2 - Pseudo CGde Development <br /> <br />Approach <br />Pseudo Code is an English like description of how data should be converted from its <br />origin to its destination. Pseudo Code often includes statements of logic and concepts. In <br />this task, RTi will develop a set of pseudo code to aid in converting data to HB - CRDSS. <br />RTi may need to examine sample data sets during this process to understand the <br />relationships between tables and develop any conceptual procedures to migrate and/or <br />populate the database. <br /> <br />RTi \.ill document the pseudo code developed in this task for inclusion as a new section <br />in the Developer's Manual. This section is expected to contain text describing each <br />major data set in HB . CRDSS (e.g. Slrllctures, Irrigated Acres, Oeoloc, derived Water <br />Rights, Streams, Dams, Reservoirs, Headgates, Diversions, Slramflow, Precipitation, <br />Temperature, Evaporation, etc.) <br /> <br />Deliverable <br />RTi \\;11: <br />I. Provide a draft section of the Developers Manual, which describes the Pseudo Code <br />developed in this Task. This section, which may be called Database Population, is <br />expected to be approximately 10 - I S pages in length. <br />2. Incorporate State comments. <br />3. Provide a final section of the Developers Manual in the following formats: one hard <br />copy, one version in Microsoft Word, one version included in the existing on line <br />(HTML) Developers Manual. <br /> <br />Task R3 ' Create Database. <br /> <br />Approach <br />In this Task, R Ti will perfonn the proc.edures necessary to create a new database. These <br />procedures include defining database spaces on the physical disk and Vvriting the database <br />definition script, the table definition scripts and the scripts to check and populate the data. <br /> <br />'-,-.: <br /> <br />During this process, RTi ",'ill work with State representatives to divide the database into <br />logical parts in order to facilitate the creation and sizing of database spaces on the hard <br />disk. Upon request by RTi, State representatives ",ill provide infonnation related to the <br />future use of Hydro Base to assist RTi in the sizing and layout of the database spaces. The <br />space layout used for the CRDSS database will be used as a starting point and guide for <br />this process, <br /> <br />RTi will create and run the scripts necessary to create the database spaces, the database <br />itself and the tables within Hydro Base. The tables created under this task are presented in <br />Eldllbit I. The table creation scripts contain the table and attribute definitions as ""'011 as <br /> <br />Scope ofWorI:, fill. CRDSS. 12ft 0196 <br /> <br />09t\~ <br /> <br />4 <br />