Data Dictionary

Table Name Column Name Data Type PK or FK FK Referenced Table Description
Parts PartID INT PK Primary Key
Mfg_PartNumber Varchar(100) Part Number provided by Vendor
VendorId INT FK Vendors FK to Vendor Table
WholesaleCost Decimal Wholesale cost from vendor
RetailPrice Decimal Price we charge customers
Vendors VendorId INT PK Primary Key
Name Varchar(100) Vendors Name
Address Varchar(100) Mailing Address
StateCode Char(2) State
ZipCode Char(9) Zip

Is this the question you were looking for? Place your Order Here