Designing Example

Inventory Design

The design and subsequent MonoDevelop application are based on an actual application. However, this implementation has been kept simple.

Use Case

The Use Case diagram shows that the application will be used by several people.

Use Case with Screens Diagram

This Use Case diagram shows the application screens and the various system users .

Entity Relationship Diagram

The Entity Relationship diagram shows the application has a simple data base. The container table has (1) the loc_id field for Enter Location, (2) the con_grade field for Enter Grade, and (3) the con_status field for the Pick Containers ( status changes from Available to Picked ) and for Modify Status ( status changes from Picked to Shipped ).

The Inventory Database

The database tables are defined as shown below. I use phpMyAdmin ( a website based administrator for MySQL ) or MySQLCC the "Control Center" application. Either way, use these tools to load the database and make sure to add a user for the appropriate IP address. (All of my examples, use the "root" user.)

--
-- Table structure for table `container`
--
CREATE TABLE `container` (
`prod_id` varchar(10) NOT NULL,
`con_id` varchar(10) NOT NULL,
`loc_id` varchar(10) NOT NULL,
`con_qty` double NOT NULL,
`con_grade` varchar(10) NOT NULL,
`con_status` varchar(10) NOT NULL,
`con_shipdate` varchar(19) NOT NULL,
PRIMARY KEY (`prod_id`,`con_id`),
KEY `loc_id` (`loc_id`)
);

--
-- Table structure for table `location`
--
CREATE TABLE `location` (
`loc_id` varchar(10) NOT NULL,
`loc_desc` varchar(25) NOT NULL,
`loc_status` varchar(10) NOT NULL,
PRIMARY KEY (`loc_id`)
);

--
-- Table structure for table `product`
--
CREATE TABLE `product` (
`prod_id` varchar(10) NOT NULL,
`prod_desc` varchar(25) NOT NULL,
PRIMARY KEY (`prod_id`)
);

ODBC Database Connection

The MySQL software includes a 3.51 ODBC driver that can be installed from the Linux system or from the MySQL website. My Linux system, uses the unixODBC software for the ODBC connection.

Two files must be configured in the /etc/UnixODBC directory: "odbcinst.ini" and "odbc.ini". The file odbcinst.ini file configures the system for the ODBC driver. The odbc.ini file configures the system for the "inventory" database instance.

odbcinst.ini

[mysql_driver]
Description = mysql_driver351
Driver = /usr/lib/libmyodbc3-3.51.12.so
Driver64 = /usr/local/lib
Setup = /usr/local/lib/libodbcmyS.so.1
Setup64 = /usr/local/lib
UsageCount = 1
CPTimeout =
CPReuse =

odbc.ini

[inv]
Description = mysql_driver
Driver = mysql_driver
Server = 192.168.0.7
Database = inv
Port = 3306
Socket =
Option =
Stmt =

Home | Download Software | Overview | Example: Inventory

Copyright KRMP Corporation 2007. All Rights Reserved
For problems or questions regarding this Web site contact [webmaster@krmpcorp.com].
Last updated: 06/20/07.