Online Rock Salt - Stock/Quote Database

This page is a quick reference to some of the database work I did for Online Rock Salt, a northwest based company who supply to some of the UK's leading supermarkets and outlets. The specification for this project meant the database needed to be delivered and fully operational within a short time scale and on a constrained budget. Visual Basic and MSSQL was used to provide a similar experience to the Companies' existing software whilst simultaneously aiming to deflate costs.

One important criteria of the project meant the database needed to be accessed from multiple workstations concurrently. To accomplish this functionality the database's tables were seperated from the UI and stored on a central server.

Main Page

The default screen presented to system users
The default screen presented to system users

Entering an Order

Adding an order to the database
Adding an order to the database

Quote Editing

Editing one of the quotes in the system
Editing one of the quotes in the system

Stock Level Reporting (Printable A4)

A4 Paper view of current stock levels
A4 Paper view of current stock levels

Backend Database Relationships

How data is stored in a Normalised Form
How data is stored in a Normalised Form

Developing the UI and Search Queries

VB.net used for UI, MSSQL for Search Queries
VB.net used for UI, MSSQL for Search Queries