Building a document lookup model

[Jacky Luk]

I have the following attributes:
I designed a data model, and hoping someone who can validate for me.

Vendor < we purchase office inventory from
======
Vendor ID(PK)
Vendor Name
Vendor Address
Email Address
Website Address
Telephone No
Fax No
Sales Representative (FK)

Sales < the guy who we contact
=====
Sales ID (PK)
Surname
Lastname
Mobile Phone


Quotation < we ask price here
=========
Quotation ID(PK)
Quotation Type
Date
Delivery Method
Payment Terms
Employee ID (FK)
Vendor ID (FK)
Due Date
Sales Representative (FK)
Sign Date
Funding type

Order < we choose the best vendor which satifies our need
=====
Order ID (PK)
Department ID
Vendor ID (FK)
Quotation ID (FK)
Date
Invoice No
Delivery Address
Description

Order_Line < for normalizatoin
==========
Order ID(PK)
Item ID(PK)
Line No

Item < items we purchased
====
Item ID (PK)
Item Name
Description
Unit Price
Quantity

CPU < CPU lookup table
===
CPUId (PK)
CPUName

RAM < RAM lookup Table
===
RamID (PK)
Type
Size

Inventory
========= < stuff that we have in stock
Item ID (PK)
Item Class
Description
SizeDetails
Serializable
SellPrice

ItemSerialized
===============
SerializeID (PK)
ReceiptID
Item ID
QtySeq
QtyAvail
SerialNo

Maintainence < records we keep for IT department and contracted maintainence
============
Maintainence ID (PK)
Service No
Item No (FK)
Description
Cost

Other tables
============
Employee, Department Tender etc


I've built these tables on a UML class diagrams

Vendor --------- SalesPerson
\
| \_______ Quotation
| |
Order---------------
|
| ______________ CPU, RAM, HD etc
| /
Item --------------Inventory
\
\______________ Maintainence

Sorry for the line-feed stuff, fix it tomorrow... sounds like the forum tends to strip spaces



Is it technically/semantically correct?

Thanks
Jack



Edited 2 time(s). Last edit at 01/31/2008 08:42PM by Jacky Luk.