source: trunk/doc/DatabaseDesign.tex @ 48

Last change on this file since 48 was 21, checked in by gavin, 16 years ago

Remove TypeOfClass? and change to ClassType?. Update ERD to match.
Create and add openMimLogo/Icon.
Generate-all *.
Configure BootStrap? and add entries, some not saving yet.
Update DatabaseDesign?.tex and index.gsp

File size: 1.8 KB
Line 
1\documentclass[12pt,a4paper]{article}
2\usepackage{inputenc}
3\usepackage{color}
4\usepackage{graphicx}
5\author{Gavin Kromhout and Steven Tucker}
6\title{OpenMim Database Design}
7\date{09 November 2008}
8%\date{\today{}}
9
10\begin{document}
11%Turn off section numbers
12\setcounter{secnumdepth}{-1}
13%Need this else header formatting vanishes.
14\maketitle {}
15
16
17\section{Intro}
18 Many organisations use a ``database''.
19 Maintenace departments often buy very expensive and customised software to monitor and improve their maintenace activities.
20 There are many advantages to using a database.
21 This is our attempt to create openMim, for open source Maintenace and Inventory Management.
22
23
24\section{Common requirements}
25\begin{itemize}
26 \item Easy install, must have a running demo within a few commands.
27  \subitem Scripted, packaged and/or web framework.
28 \item Open source, GNU GPL.
29  \subitem Leverage the best of open source for fast development
30  \subitem and ease of maintenance.
31 \item SVN and FTP/SSH for collaboration.
32 \item Grails web framework.
33  \item Architecture MVC
34%TODO:
35\textcolor{red}
36{
37 \item Specify naming convention for database and code.
38 \item Maintain Project Flowcharts, ERD, Database Schema, BLL and Documentation.
39  \subitem Use Dia, flowcharts, recall etc.
40}
41\end{itemize}
42
43\section{Project Management Flowchart}
44\begin{center}
45 \includegraphics[scale=0.75]{ProjectManagementFlowchart.png}
46\end{center}
47
48\section{Entity Relationship Diagram}
49\begin{center}
50 \includegraphics[scale=0.25]{openMimEr.png}
51\end{center}
52
53\section{Core Scope}
54\textcolor{red}
55{
56Determine the core scope as per ERD.
57Determine the initial scope as per ERD.
58Indicate standalone packages.
59}
60
61\section{Database Schema}
62\begin{center}
63 \includegraphics[scale=1]{dataModel.png}
64\end{center}
65
66\begin{center}
67The end.
68\end{center}
69
70\end{document}
Note: See TracBrowser for help on using the repository browser.