\documentclass[12pt,a4paper]{article} \usepackage{inputenc} \usepackage{color} \usepackage{graphicx} \author{Gavin Kromhout and Steven Tucker} \title{OpenMim Database Design} \date{09 November 2008} %\date{\today{}} \begin{document} %Turn off section numbers \setcounter{secnumdepth}{-1} %Need this else header formatting vanishes. \maketitle {} \section{Intro} Many organisations use a ``database''. Maintenace departments often buy very expensive and customised software to monitor and improve their maintenace activities. There are many advantages to using a database. This is our attempt to create openMim, for open source Maintenace and Inventory Management. \section{Common requirements} \begin{itemize} \item Easy install, must have a running demo within a few commands. \subitem Scripted, packaged and/or web framework. \item Open source, GNU GPL. \subitem Leverage the best of open source for fast development \subitem and ease of maintenance. \item SVN and FTP/SSH for collaboration. \item Grails web framework. \item Architecture MVC %TODO: \textcolor{red} { \item Specify naming convention for database and code. \item Maintain Project Flowcharts, ERD, Database Schema, BLL and Documentation. \subitem Use Dia, flowcharts, recall etc. } \end{itemize} \section{Project Management Flowchart} \begin{center} \includegraphics[scale=0.75]{ProjectManagementFlowchart.png} \end{center} \section{Entity Relationship Diagram} \begin{center} \includegraphics[scale=0.25]{openMimEr.png} \end{center} \section{Core Scope} \textcolor{red} { Determine the core scope as per ERD. Determine the initial scope as per ERD. Indicate standalone packages. } \section{Database Schema} \begin{center} \includegraphics[scale=1]{dataModel.png} \end{center} \begin{center} The end. \end{center} \end{document}