本文對宜蘭縣礁溪鄉林美社區之石磐步道巡護表單建立資料庫,希望所有的資料能以有系統的方式進入資料庫中,不但提供使用者快速便捷的查詢內容及更明確的資訊,並讓經營者更易於掌握社區步道狀況,做出明確的經營決策。 本文依循「系統發展生命週期模式」:初步調查、系統分析、系統設計、系統實作、系統維護等五大步驟。首先針對本案例逐步探討及分析,同時又針對資料庫的設計步驟,逐一說明如何設計此資料庫,用ER MODEL及關聯圖呈現出設計好的結果,接著進行系統實作,針對使用者的需求完成網頁設計。提供五大功能包含既有監測點管理系統、巡護管理系統、維修管理系統、資料查詢系統、權限管理系統。讓使用者容易操作並方便使用,而經營管理者則可以依據不同查詢目地,知道如何去管理最為適當。最後針對此系統的設計提出討論與建議,期望能使此步道監測管理資訊系統提供更人性化的服務與方便的使用。
I focused on how to build up the database in Lin-Mei shih-tan Trail in this article, hoping all of the data can be completely storaged in a systematic way. Not only the system provides much more clear information, but also the management can query any information easily ; furthermore , the management can handle how the facility go on in the trail easily to make a proper decision. I first used the design flow called System Life Cycle (SDLC): Primary investigation ; System analysis ; System design ; System implement ; and then focus on database design to explain how to design this database and what stands for in each of the database. Finally I used the entity-relationship model to show what I have designed. The Lin Mei Trail Monitor System provides the user input function , query function , add up function , modify function in a easy and simple way. Manager will know how to appropriately manage the facility in the trail different query goal. Discussing the system design hopes improving the better trail monitor management information system which provides the use of convenience and better service