0

    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

                                                                                                                                      Order Now