ER diagram.

 

RM Model

Database

DName

CID

Host

Port

Customer

CID

CAddress

CEmail

Cname

CTelephone

Company

SID

SAddress

SEmail

Sname

STelephone

Part Type

SID

TID

Tname

TInformation

Part

TID

PID

Pname

PCost

PInformation

Typeof

CID

SID

TName

Discount

RFP

CID

SID

TID

PID

Qty

Date

Cost