Index: /trunk/doc/DatabaseDesign.tex
===================================================================
--- /trunk/doc/DatabaseDesign.tex	(revision 8)
+++ /trunk/doc/DatabaseDesign.tex	(revision 8)
@@ -0,0 +1,71 @@
+\documentclass[12pt,a4paper]{article}
+\usepackage[utf-8]{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 Django python web framework.
+%TODO:
+\textcolor{red}
+{
+ \item Specify naming convention for database and code.
+ \item Specify model MVP or Three-tier?
+  \subitem Django is a version of MVP?
+ \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=1]{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}