Standard Hardware E-R Diagram
PART
ORDERPROD
SALESORDER
partno CHAR(6)
orderno CHAR(8)
orderno CHAR(8)
partdesc VARCHAR(100) ++
partno CHAR(6)
++ orderdate DATE
onhand INT
partclass CHAR(2)
orderqty INT
custno CHAR(6) (NOT NULL)
+
Â¥
orderprice NUMBER(7,2)
unitprice NUMBER(6,2)
+
INVPROD
INVOICE
invno CHAR(8)
invno CHAR(8)
partno CHAR(6)
invdate DATE
shipqty INT
orderno CHAR(8) NOT NULL
SALESREP
srepno CHAR(3)
srepname VARCHAR(30)
srepstreet VARCHAR(30)
srepcity VARCHAR(30) (NOT NULL) +
srepprov VARCHAR(3) (NOT NULL)
srepcode VARCHAR(6) (NOT NULL)
commrate NUMBER(3,2)
Primary Key: bold
Foreign Key: undelined
CUSTOMER
custno CHAR(6)
custname VARCHAR(30) (NOT NULL)
custstreet VARCHAR(30) (NOT NULL)
custcity VARCHAR(30) (NOT NULL)
custprov VARCHAR(3) (NOT NULL)
custpcode VARCHAR(7) (NOT NULL)
disc NUMBER(3,1)
balance NUMBER(7,2)
creditlimit NUMBER(5,0)
srepno CHAR(3)