Web based WOS & Inventory

I’m working on the database for a new work order system (WOS) that also holds inventory information. The database design has taken me a couple of days but it’s coming together pretty well. Here is what I’ve got so far (136K file):

So far, there isn’t any redundant or NULL data. I’m trying to put the database at least in 2nd normal form but third normal form would be ideal. A really good, easy to understand article about database normalization can be found here.

I split the Parts (mice, drives, etc.) and Equipment (printers, computers, etc.) tables because more data is held for equipment than what is held for parts. They would have been combined if it was only one bit of information difference. The split is why there are two inventory tables. I’m trying to find a way to combine them so that equipment and parts is held in the same table. It’s not a big deal if it’s not.

The guy doing the frontend is writing it in ASP and JavaScript. It will be really nice when it gets completed but there’s no date of release set yet. I still have to write some stored procedures that he can use without having to write the procedures into the web pages.

Today I felt pass over me
A breath of wind from the wings of madness. – Charles Baudelaire

02.Sep.06 Microsoft SQL