Database Design Project
nemo12
DataDictionaryTemplate.xlsxData 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 |
