source: trunk/doc/DatabaseDesign.tex @ 60

\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}